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 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:
- Default zoom values (25%, 50%, 75%, 100%, 200%).
- Adjust the view to the selected cells. Up to 400%.
- Enter the specific value between 10% and 400%.
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.
If you select multiple cells, and none of them will be a number, Excel will return information only about Counter.
Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.