Status Bar Options in Excel- Customize and Use Status Bar in Excel!

Status Bar Options in Excel:

A Status Bar in the Worksheet is located at the bottom of the worksheet. It displays a good deal of information about the worksheet.

Here we come up with an exciting article about Status Bar Options in Excel 365.

Description of Status Bar:

• The Status Bar of the Excel window can show more information about the worksheet, like Number Lock is on or off in the worksheet.
• You can show or hide items in the Status Bar by Right-clicking anywhere on the Status Bar, and it will display the menu. You can select the item you want to show.

Options in Status Bar:

Common Modes in Status Bar are:

• *Ready Mode – * It gives the general status of the worksheet by default.
• Enter Mode – It is enabled when you are entering data in the cell currently.
• *Edit Mode – * It is enabled while editing a cell in the worksheet.
• Extend Selection – ** It is enabled after clicking **the F8 Key.
• Add to Selection – ** It is enabled after clicking **(SHIFT + F8) Keys.
• You can include special keys like Num Lock, Scroll Lock, Caps Lock in the Status Bar.

Right-click anywhere in the status bar. It will open the Customize Status Bar menu. You can choose any option in that menu to show or not show some items in the Status Bar. The right side of that menu will display the current status.

Customize Status Bar

• Status Bar will show the Summary Statistics based on the numerical values selected in the spreadsheet.
• Refer to the below image.

• You can select three types of worksheet views from the Status Bar. They are Normal view, Page Layout View, Page break preview.

• The ** Zoom Scroll Bar** is used to adjust the current level of magnification of the worksheet.

Conclusion:

In the above article, we have illustrated the Status Bar Options with example images. I hope this can help you to understand the Excel Status Bar. Drop your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!