Thursday, April 15, 2021

Status bar in Excel - Free Online Excel Training with MR.Excel

 

What is Status bar in Excel?

Status Bar in Excel

The Status Bar in Excel is the area which is at the very bottom in Excel which have special keys that are engaged can be seen or different information about the current mode. We can also select zoom in and out and different worksheet views on the worksheet from the status bar.

status bar in excel

Status Bar

we will see number wise details in status bar as below.
  1. In this tab we can see current mode and special keys information that are engaged. Here we are mentioning some extra features in bullet points
  • More common modes include in number 1:
    • Ready mode is general status of Excel by default.
    • Enter mode is Currently entering content into a cell.
    • Edit mode is Currently editing a cell.
    • Extend Selection mode will see after pressing F8
    • Add to Selection mode will see after pressing SHIFT+F8.
  • Some special keys like Caps LockNum Lock and Scroll Lock might be added.
2. Macro Recorder status tells us macro currently recording. We can start recording a macro by clicking this icon status and when we're done, we can stop recording by pressing again the icon status.

3. To open the customize status menu Right click anywhere in the status bar. We can select which items we want to show by checking them, and also we can hide the items which we do not want to show in the status bar.  Current statuses will also display on the right-hand side of the menu.

4.The Status Bar can be set to show summary of numerical values which we have selected in our workbook. 

5. Here you can select from three different worksheet views
  • Normal view
  • Page Layout view
  • Page Break preview
6. Zoom Scroll Bar will allow us on the current working sheet, adjust the level of magnification.

7. Current Zoom Level will display the level of magnification on the worksheet on the current basis and when we will click it, it will open the Zoom menu to select the preset magnification options

Also Read : How to customize the ribbon?


No comments:

Post a Comment