Hints and tips home » Excel hints and tips » Using basic functions without doing formulas

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

Added by Martin on 14th September 2006

More Excel hints and tips, like:

• Manually rotating a 3D chart
• Change the default location for opening and saving spreadsheets
• Cycling through Absoulte cell references