From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using autocalculate in the status bar

Using autocalculate in the status bar

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Using autocalculate in the status bar

“

- At the bottom of the Excel screen, just below the Sheet names, is an area called the Status bar, and it has a valuable tool in it called Auto Calculate. At the moment we're seeing nothing here. Now, I'm highlighting some cells. If I highlight two or more cells with values, we see a number of totals down here. Now, if you're using this on your computer right now, if you happen to not see as many of the entries as I'm seeing right now, there's six different ones, you can right-click down there, and in this section right here, where I'm scrolling up and down, you'll see Average, Count, Numerical Count, Minimum, Maximum, Sum. You can uncheck these if you wish. If I uncheck Count, that's no longer visible in the Status bar, Numerical Count. On the other hand, those might come in handy. But any time we highlight two or more cells, we get those totals down there, and that can be used for a variety of different reasons. On a different worksheet here, to the left, maybe I simply want to know…

Contents