When you select a range of cells you can quickly see key metrics like the Sum, Count, Minimum, Maxi mun and Average.

To activate this you will need to Right Click on the Status Bar at the bottom of your workbook and choose the metrics that you want to show.  Once selected, these option remain saved for all future workbooks.

DOWNLOAD EXCEL WORKBOOK

STEP 1: Right click anywhere on the Status Bar to show the customization menu

STEP 2: Tick the values that you want to be displayed in your Status Bar

Now when you select and highlight numerical values, these auto-computed metrics will now show up in your status bar!

Helpful Resource:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn