Hints and tips home » Excel hints and tips » Turn Function tooltips on and off

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

Added by Alan on 16th September 2006

More Excel hints and tips, like:

• Counting Non Number Cells (Text)
• Moving between split pane sections in a spreadsheet
• Quickly create a list of numbers