Some Quick Excel Formula Tips
While you enter a formula in a cell, press CTRL+SHIFT+A to see the arguments in a formula. If you type =RATE, and then press CTRL+SHIFT+A, you can see all the arguments for that function–for example, =RATE(nper,pmt,pv,fv,type,guess). If you want more details, type =RATE, and then press CTRL+A to display the Function Wizard.
If you want to quickly enter the same text or the same formula in a range of cells, follow these steps:Thanks to Daily Dose of Excel
1. Select the range of cells that you want to fill.
2. Type the text or formula but do not press ENTER. Instead, press CTRL+ENTER.
The data appears in the range that you selected.