![]() This has been a guide to Status Bar in Excel. Not all the options are active by default you can customize the status bar in Excel options anytime.Some of the options are feasible with numeric as well as string (character) data.Some options are only feasible with numeric data Eg.Status Bar in Excel gives the status of simple but frequently used options like Sum, Average, etc.Things to Remember About Status Bar in Excel That’s all from my end, guys we will take a moment to wrap up the things with some Things to Remember quickly. It is enabled by default and gives several currently used pages (A page in a workbook is said to be in use if a user is editing that page).The Page number option is very useful in your worksheet in Page Layout View.It becomes more useful when you have mixed data values (Numeric + Character/String) in cells. This option allows you to capture several numeric entities in a column. Numerical Count – This option is not enabled by default, so you must enable it through Excel status bar customization.Sum – It does what the word suggests, sums up all the numeric values.Average – It averages all the non-empty cells from columns/rows.(irrespective of data type Numeric/Character). Count – It counts the number of non-empty cells from columns/rows.Some statistical/mathematical options exist for a quick calculative view of the numeric data in the Excel status bar. Once you click on zoom percentage, the zoom dialog box opens, from where you can select the magnification percentage for a current worksheet.It is situated next to the zoom slider on the left-hand side of the status bar.Zoom percentage can also magnify the worksheet and be considered to function the same as that of the Zoom slider.See the below sample image for your reference. Zoom Out helps you reduce the worksheet’s magnification, and you can see more data in a single shot. Using Zoom In, you can magnify the current worksheet and look closely at the data. Moreover, it has (+) (-) keys that can be used for “ Zoom In ” and “ Zoom Out “, respectively. ![]() ![]() The zoom slider lets you quickly zoom in or out of the Excel worksheet you are working on.If you are working on Excel frequently, you might be well know to this option which is provided at the rightmost corner of the status bar.Please see the attached sample image for your reference. Point – It gets activated when the user enters a formula in a cell while providing other cells (which have data in them) as input to the formula. It is displayed when the user double-clicks the cell or presses F2 once. It means the cell is being edited (new data replace old data). Word entered itself suggests that input entering has been started.Įdit – It is quite like Enter. It can also consider as in the general state, where the cell has no input data.Įnter – It means that the user has either started typing the data in the cell or pressed F2 twice to edit the cell. Ready –It means the cell on which you have your cursor is ready to take user input from you. The “Cell Mode” option is enabled by default in excel and can be seen at the extreme left side of the status bar. ![]() This tutorial will cover default options enabled in the Excel status bar and additional options that can add and prove useful. Note : If you want to come out of the Customized status bar, simply click anywhere in the sheet outside the popped-up menu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |