Excel: Status Bar

The status bar is located at the bottom of the screen, below the working area. It displays information about the current activities in the worksheet.

 

The left side of the Status Bar

The first thing that stands out when you look at the Status Bar is the word READY. It will be present for most of the time when you work with Excel.

As soon as you start typing in a cell, it will change to the ENTER. Double-click the cell containing a value, and the text will change to EDIT.

Next to it, you will find the Macro Recorder. It is used to create macros that will allow you to automate your tasks. 

The right side of the Status Bar

On the right side, you will find three icons. With these icons, you can adjust the way your sheet will be displayed. The default mode is set to normal.

Next, to the right there is a slider. It allows you to zoom the working area. By default, it is set to 100%. Click this value and a new window will appear. You can choose one of the following options:

  1. Default zoom values (25%, 50%, 75%, 100%, 200%).
  2. Adjust the view to the selected cells. Up to 400%.
  3. Enter the specific value between 10% and 400%. 

Additional options

If you select a group of cells that contain numbers, Excel will print additional information, such as Average, Count, and Sum.

 

In order to have a quick preview of additional information, right-click the status bar and choose one of the three options: Numerical Count, Minimum and Maximum.

 

NOTICE

If you select multiple cells, and none of them will be a number, Excel will return information only about Counter.