- Feb 20, 2013
- Using the Ribbon
- Using the Quick Access Toolbar
- Using the Full-Screen File Menu
- Using Other Excel Interface Improvements
- Using the New Sheet Icon to Add Worksheets
- Navigating Through Many Worksheets Using the Controls in the Lower Left
- Using the Mini Toolbar to Format Selected Text
- Expanding the Formula Bar
- Zooming In and Out on a Worksheet
- Using the Status Bar to Add Numbers
- Switching Between Normal View, Page Break Preview, and Page Layout View Modes
Using the Status Bar to Add Numbers
If you select several cells that contain numeric data and then look at the status bar, at the bottom of the Excel window, you can see that the status bar reports the average, count, and sum of the selected cells (see Figure 3.36).
Figure 3.36. The status bar shows the sum, average, and count of the selected cells.
If you need to quickly add the contents of several cells, you can select the cells and look for the total in the status bar. This feature has been in Excel for a decade, yet very few people realized it was there. In legacy versions of Excel, only the sum would appear, but you could right-click the sum to see other values, such as the average, count, minimum, and maximum.
You can customize which statistics are shown in the status bar. Right-click the status bar and choose any or all of Min, Max, Numerical Count, Count, Sum, and Average.
Note that the panel might show values for items that you have recently unselected. These figures will be wrong if the selection has changed.