Hints and tips home » Excel hints and tips » Display Functions on Worksheets

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function

Added by Orok on 27th September 2006

More Excel hints and tips, like:

• Outlining - ungrouping rows or columns
• Use RANDBETWEEN to generate random numbers
• Deleting cells, Rows & columns