Home > Articles > Programming > General Programming/Other Languages

  • Print
  • + Share This
This chapter is from the book

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.12).

Figure 3.12

Figure 3.12 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 simply 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 prior versions of Excel, only the sum would appear, but you could right-click the sum in order to see other values, such as the average, count, minimum, and maximum.

As with past versions of Excel, in Excel 2007 you can customize which statistics are shown in the status bar. In Excel 2007, you can configure all of the status bar elements. To do so, you right-click the status bar to display the Status Bar Configuration panel. In this panel, you can see the current value of all status bar icons, whether they are hidden or not (see Figure 3.13).

Figure 3.13

Figure 3.13 You can configure the status bar to show or hide all these indicators.

To add new items to the status bar, you click them in the Status Bar Configuration panel.

  • + Share This
  • 🔖 Save To Your Account