So far we have learnt about the start screen and backstage view of Excel 2016 and also explored the different parts of excel worksheet. We have studied the various parts of worksheet in detail as well e.g. we have seen the parts of Excel ribbon, we have explored the formula bar, Quick access toolbar etc. In this series we come at the very last portion of the worksheet - the status bar. At the very bottom of the Excel window is the status bar. Though it is at the very bottom of the program but it has some important roles to perform while using Excel.
Status bar is divided into five main components –
- Mode Indicator
The Mode Indicator
- This portion of the status bar indicates the mode in which excel is running currently. While studying the different Excel keyboard shortcuts to navigate the cells we have seen the END Mode. Similarly there are other modes like READY, ENTER, EDIT etc.
- Record Macro
The Macro recording button
- Then there is the Macro recording button which appears next to the Mode indicator as soon as we start recording a macro. We’ll study more about recording macros in detail later. While we are not recording any macro this button is replaced by an inactive macro indicator as shown in the image.
- This indicator displays the Average, Count and Sum values of the numerical values in the currently selected cells.
- This portion on the status bar has three buttons with each one corresponding to a layout of the worksheet. The three layout options are the Normal layout, Page layout and the Page break Preview. You can switch to any of these layouts by clicking the corresponding button on the status bar.
- Zoom Slider
Zoom slider –
- This is the last section of the status bar and is used to zoom in and zoom out of the worksheet area. This can be done by dragging the slider to left or right.
Every part of an Excel worsheet, no matter how small it is, has some important role to play. If we make it a habit ti go into the nitty gritties of using Excel then we'll realise the importance of every portion visible on the worksheet.