Excel 2007’s Quick Data Analysis from the Status Bar

By Stephen L. Nelson

Part of Excel 2007 Data Analysis For Dummies Cheat Sheet

Excel 2007 can tell you quite a bit about a selected range of cells just from the status bar. When you select cells that have data in them, Excel’s status bar can tell you some useful information about those cells. When you right-click the status bar, Excel displays a pop-up menu that includes several statistical measures that you can make on the selected range; they’re shown in the following table:

Statistical Measures Option What It Does Statistical Measures Option What It Does
[None] Tells Excel that you don’t want it to calculate and then show a
statistic on the status bar.
Maximum Finds the largest value in the selected range
Average Finds the mean of values in selected range. Minimum Finds the smallest value in the selected range
Count Tallies the cells that hold labels, values, or formulas. Use
this when you want to count the number of cells that aren’t
Sum Adds the values in the selected range
Numerical Count Tallies the number of cells in a selected range that hold
values or formulas.