View summary data on the status bar

To quickly see how numbers in selected cells add up, take a look at the status bar below your spreadsheet. When you select two or more cells that have numeric data, Excel Online automatically summarizes that data and shows the average, count, and sum on the status bar. These summarized values update immediately when you change values in the selected cells or select a different range of cells.

Status bar entries

Change what's shown on the status bar

Excel Online can show status bar entries for average, count, numerical count, min, max, and sum. You can customize the status bar to show and hide any or all of them. Here's how:

  1. In the status bar, click the arrow next to the last status bar entry.

    Customize status bar

  2. In the Customize Status Bar gallery, pick the status bar entries you want.

    Status bar options

    A check mark appears when an entry is selected. To deselect entries, click them again to remove their check marks.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×