From the course: Excel 2016: Tips and Tricks

Unlock the full course today

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

Customize the display of status bar totals

Customize the display of status bar totals

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Customize the display of status bar totals

“

- [Voiceover] We're looking at the worksheet Split Freeze. Maybe it's just been sent to us. We're a little curious about some of the data that's in it. It's about seven hundred rows or so. We'd like to know for starters here how much is that ADC department spending on compensation, its hours and so on. So I'm going to be highlighting cells L2 down through L6, that's for the ADC people. And at the bottom of my screen, I'm seeing a total. But not only a total, also the highest value within the list, the minimum. I don't necessarily care about all this information. I see the average, I wanted to know the total. But there's some other information there as well too. This area of the screen is referred to as the status bar. Now, I might want to know the total here for the entire column. I'll just click column L. And I see that this company or organization is spending 47 million on new compensation. And I see the highs and lows there, maybe that's a little more interesting now. That one is…

Contents