98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

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:

• Moving or Copying Sheets Between Workbooks in Excel 2010
• Outlining - ungrouping rows or columns
• Converting an American date format to European using Formula