Tip Printed from ExcelTip.com

---

Watch Calculation Results Immediately in Excel 2007


To watch calculations results immediately:

1. Select range of cells containing numeric data.
2. Select the Status Bar and right-click to open Status Bar shortcut menu.

Six functions are available:
Average, Count, Numerical Count, Minimum, Maximum and Sum

Results appear at the right of each formula in the shortcut menu.
Or
Check all or any other formulas you want to watch the result calculation for in the Status Bar.