The Status Bar in Microsoft Excel 2021 is a horizontal bar located at the bottom of the workbook window that provides useful information about the current worksheet. By default, the Status Bar displays the sum, count, and average of the selected cells, as well as the page number and the zoom level.
In this article, we’ll take a closer look at the different elements of the Status Bar in Microsoft Excel 2021 and how to customize it to display the information you need.
Elements of the Status Bar
The Status Bar in Microsoft Excel 2021 displays several different elements that provide information about the current worksheet. These elements include:
- Sum: The Sum displays the total of the selected cells.
- Count: The Count displays the number of cells in the selection that contain data.
- Average: The Average displays the average value of the selected cells.
- Page Number: The Page Number displays the current page number in a multi-page worksheet.
- Zoom Level: The Zoom Level displays the current zoom level of the worksheet.
Customizing the Status Bar
The Status Bar in Microsoft Excel 2021 can be customized to display different elements depending on your preferences. To customize the Status Bar, right-click on any part of the Status Bar and select “Customize Status Bar.” This will open a dialog box that allows you to add or remove elements from the Status Bar.
You can choose from a variety of elements to display on the Status Bar, including:
- Selection Sum: Displays the sum of the selected cells.
- Selection Count: Displays the count of the selected cells.
- Selection Average: Displays the average of the selected cells.
- Minimum: Displays the minimum value of the selected cells.
- Maximum: Displays the maximum value of the selected cells.
- Numerical Count: Displays the count of cells that contain numerical data.
- Error Checking: Displays the status of error checking on the worksheet.
- Caps Lock: Displays a message when the Caps Lock key is activated.
- Scroll Lock: Displays a message when the Scroll Lock key is activated.
- Selection Mode: Displays the current selection mode, such as “Normal” or “Extend.”
The Status Bar in Microsoft Excel 2021 is a useful tool for providing information about the current worksheet. By default, the Status Bar displays the sum, count, and average of the selected cells, as well as the page number and zoom level. However, you can customize the Status Bar to display the information that is most relevant to your work. By taking advantage of this feature, you can work more efficiently and effectively in Excel.