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:
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.

Thanks to Daily Dose of Excel