Working with Worksheet Functions

Close Window 

Accessing Fast Formula Help

To get instant help with the syntax for any worksheet function, type an equal sign plus the function name, then press Ctrl+Shift+A. Excel displays the functionís arguments right there in the cell.

To enter the function, replace required arguments with data or cell references, delete any optional arguments you donít use, and press Enter.

(Posted 09/23/2000)

"Press F2 immediately after Ctrl+Shift+A. That lets you use the left and right arrow keys to move through the arguments Excel displays in the cell."