Microsoft Office Tutorials and References
In Depth Information
Using the Status Bar Selection Statistics Feature
Using the Status Bar Selection Statistics Feature
I’m always surprised when I encounter Excel users who have never noticed the handy selection
statistics field on the status bar. When you select a range that contains values, Excel displays
information about the selected range on the status bar, which is at the bottom of the Excel
window. As you can see in Figure 74-1, the selected cells have an average value of 198.62, the
number of selected cells is 39, and the sum of the values is 7,746.
Figure 74-1: Excel displays information about the selected cells on the status bar.
If you prefer to see some other statistic relating to the selection, right-click the text on the status
bar and make your selection from the shortcut menu (see Figure 74-2). Your choices are any or
all of the following:
h Average
h Count
h Numerical Count
h Minimum
h Maximum
h Sum
 
Search JabSto ::




Custom Search