The right side of the menu displays the current values for the different calculations.Ĭlick to toggle (on or off) the available types of calculations. The shortcut menu displays all the available status information you can track. If you want to change the type of calculations that appear on the Status bar, right-click anywhere on the Status bar to display a shortcut menu.The sum, average, and count of the selected cells appears on the status bar by default.Select the range of cells you want to calculate.If a cell contains text, it’s ignored, except when you select the Count option. The Status bar results do not appear on the worksheet when printed but are useful for giving you quick answers while you work. The Status bar automatically displays the sum, average, maximum, minimum, or count of the selected values. You can simplify your work using the Status bar calculations when you don’t want to insert a formula, but you want to quickly see the results of a simple calculation. Learn More Buy Displaying Calculations with the Status Bar