Wednesday, January 19, 2005

Some Quick Excel Formula Tips

Daily Dose of Excel
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


Post a Comment

<< Home