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.

Status Bar Metrics | MyExcelOnline


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:


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


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn