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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!