Toggle Automatic Calculations in Status Bar

Summary: Toggle whether or not Excel 2007 should perform automatic function calculations on selected cells in its status bar.

Depending on your configuration, when you highlight cells containing numeric data inMicrosoft Excel 2007, the status bar contains the results of function calculations, which may include:

* Average
* Count
* Sum

Plus, the following functions are also available:

* Numerical Count
* Minimum
* Maximum

Example of Excel 2007 performing function calculations in the Status Bar

If you would like to configure which functions are automatically calculated in the status bar, or if you find this information annoying and wish to disable this feature completely, perform the following:

1. Right-click on the status bar.

2. Between “Page Number” and “View Shortcuts” you will see the above-named functions. Check or uncheck each function as desired.

comments powered by HyperComments
READ  Cell Formatting Keyboard Shortcuts