All About the Status Bar in Excel and How to Use It

The status bar, which runs horizontally along the bottom of the Excel screen, can be customized to display a number of options, most of which give the user information about the current worksheet, spreadsheet data, and on/off status of individual keys on the user's keyboard, such as Caps Lock, Scroll Lock, and Num Lock.

Default Options

Status bar defaults include the page number of the selected worksheet page and the number of pages in the worksheet when you are working in Page Layout or Print Preview. Other details shown by default include:

• Conducting mathematical and statistical calculations
• Changing the magnification of the worksheet
• Changing the worksheet view
• Cell mode

Right-click the status bar to open the status bar context menu. The menu lists available options — those with a checkmark beside them are currently active. Click an option in the menu to toggle it on or off.

Calculation Options

The default calculation options include finding the average, count, and sum for selected cells of data in the current worksheet; these options are linked to the Excel functions by the same name.

If you select two or more cells containing number data in a worksheet the status bar displays:

• The average value of the data in the cells
• The number of cells selected (count)
• The total value of the data in the cells (sum)

Although not active by default, options for finding the Maximum and Minimum values in a selected range of cells are also available using the status bar.

Zoom and Zoom Slider

One of the most-used options of the status bar is the zoom slider in the bottom right corner, which allows users to alter the magnification level of a worksheet. Next to it is zoom, which shows the current level of magnification.

If you choose to display the zoom option but not the zoom slider, you can change the magnification level by clicking on zoom to open the dialog box, which contains options for adjusting magnification.

Worksheet View

Also active by default is the view shortcuts option. Shortcuts are next to the zoom slider, and the three default views are the normal view, page layout view, and page break preview.

Cell Mode

Another well-used option and one also activated by default is Cell Mode, which displays the current status of the active cell in the worksheet. The cell mode is on the left side of the status bar and displays as a single word denoting the current mode of the selected cell.

These modes include:

• Ready: Indicates that the worksheet is ready to accept user input, such as data input, formulas, and formatting.
• Edit: Indicates, as the name states, that Excel is in editing mode. You can activate editing mode by double-clicking on a cell with the mouse pointer or by pressing the F2 key on the keyboard.

• Enter: Occurs when a user is entering data into a cell; this state is activated automatically by typing data into a cell or by pressing the F2 key on the keyboard twice in succession.
• Point: This occurs when a formula is being entered using a cell reference by mouse pointing or the arrow keys on the keyboard.