Adding items to the status bar

The status bar is located at the bottom of the Office 2019 environment. It displays information about the current file you are working on and provides quick access to some tasks. Right-clicking on the status bar provides you with a shortcut menu to make changes to it. You can add or remove items from the status bar:

A tick to the left of an option identifies that it is already active. When we say active throughout this book, we mean already selected, visible, or selected. To add or remove an item from the status bar, simply click on the desired option in the shortcut menu:

Average, Count, and Sum are the default functions that reside on the status bar. They provide a result when selecting values on a worksheet in Excel 2019. To change how these values are calculated, right-click on them and select another function to perform. If you highlight a range of numerical values on a worksheet, Excel will display the count, sum, and average of those values on the status bar.