75. Excel Tips - Helpful Hints On The StatusBar
There is a way to get some simple information quickly and without having to write formulae :
- Use the statusbar (the thing at the bottom)
Here's a screen shot of our data in Excel:
Note, that when you select multiple cells, you can get following information about your selection on the statusbar:
- A count of the number of populated cells
- A count of the number of numeric cells
If you don't see these calculations automatically, right click and customise the statusbar.
It even works well with Autofilter on..
Training Video on how to use Helpful Hints On The StatusBar in Excel: