Via kbAlertz’s RSS feed, I saw a new knowledge base article called Description of the undiscovered tips about Excel. I love reading these kinds of articles because amid the mundane, there’s always something I didn’t know. For instance,
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 functionfor 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.
It’s a shame that I’m just learning this, it’s quite useful, the Ctrl+Shift+A part. I’ve never much cared for the Function Wizard. Oh, how many times I had to look up FIND in help to see the order of the arguments.
Then there’s the tips I know, but somehow never use:
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.
That’s so handy, I don’t know why I never remember to use it.