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.

YouTube video

Status Bar Metrics | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

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

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

Status Bar Metrics | MyExcelOnline

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

Status Bar Metrics | MyExcelOnline

Helpful Resource:

728x90

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin