This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2007 - Toggle Automatic Calculations in Status Bar

Depending on your configuration, when you highlight cells containing numeric data in Microsoft 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.


Toggling functions in Excel 2007's status bar



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2007 - Toggle Automatic Calculations in Status Bar.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.