All about the status bar in Excel and how to use it

status bar which runs horizontally across the bottom of the Excel screen, can be configured to display a number of options, most of which provide the user with information about the current worksheet, spreadsheet data, and the on/off status of individual keys on the keyboard, such as: Caps Lock scroll lock And Num Lock

These instructions apply to Microsoft Excel 2019, 2016, 2013, 2010, and Excel for Office 365.

  1. Change status bar options
  2. Standard options
  3. Calculation options
  4. Zoom and Zoom Slider
  5. Sheet view
  6. Mobile mode

Change status bar options

The status bar has some default options such as the page number of the selected worksheet page and the number of pages in the worksheet when you are in page layout or Example

The parameters can be changed by pressing right click on the status ba r with the mouse pointer to open context menu status bar † The menu contains a list of available options – those with a check mark are currently active. Clicking an option in the menu toggles it on or off.

Standard options

As mentioned, some options are pre-selected to appear in the status bar by default. These options include:

  • Performing Mathematical and Statistical Calculations

  • Change page magnification

  • Change the view of a worksheet

  • Mobile mode

Calculation options

Standard calculation options include finding the mean, count, and sum for selected data cells in the current worksheet; These options are associated with the Excel functions of the same name.

When you select two or more cells with numeric data in a worksheet, a status bar appears:

  • Average value of data in cells

  • Number of selected cells (number)

  • Total cost of data in cells (sum)

Although this feature is disabled by default, options are also available from the status bar to find the maximum and minimum values ​​in a selected range of cells.

Zoom and Zoom Slider

One of the most commonly used status bar options is the zoom slider at the bottom right, which allows users to change the zoom level of the worksheet. Next to it is zoom showing the current zoom level.

If you choose to show the parameter: zoom but not zoom slider you can change the zoom level by clicking increase to open a dialog box with options for adjusting the magnification.

Sheet view

The option is also enabled by default. vision labels † The labels are next to: zoom slider and the default three views are normal view display page layout And page break example.

Mobile mode

Another commonly used option, also enabled by default, is: Mobile mode One that displays the current state of the active cell on the worksheet. Cell mode is located on the left side of the status bar and is displayed as a single word indicating the current mode of the selected cell.

These modes include:

  • Finished † Indicates that the worksheet is ready to accept user input, such as data entry, formulas, and formatting.
  • edit † Indicates that, as the name suggests, Excel is in edit mode. You can activate edit mode, double click in a cell with the mouse pointer or by pressing a key F2 on keyboard.

If you cannot enter edit mode by double clicking or pressing F2, you must enable edit mode by going to: File parameters: Additionally † In section Editing options select Allow direct editing in cells

  • Enter † Occurs when the user enters data into a cell; this status is automatically activated when you enter data in a cell or press the key twice F2 on keyboard.
  • Point † Occurs when you enter a formula using a cell reference with the mouse or the arrow keys on your keyboard.

Leave a Reply

Your email address will not be published. Required fields are marked *