Back to menu

Quick Functions

Many Excel users, and even the advanced users among them, often fail to notice one of the most handy features of Excel:
The moment you select a range of cells – their sum immediately appears below on the status bar.

The quick functions on the status bar

This is extremely handy for anytime you need to have a quick glimpse of your data, even before applying the “standard” functions.

But not only their sum – in Excel 2007 you can see their average, and the number of cells in that range that contain any data (the “Count” value).

Right click the status bar, and you will see a list of more quick functions you can add to it, such as Minimum (the smallest number in the range), Maximum (the largest number) and Numerical Count (which means how many numbers you have in the selected range).

menu for adding more functions

In older versions of Excel you could see only one quick function at a time, and in order to switch from “Sum” to “Average” you had to right click the word “Sum” and choose the new function from a short menu.