Excel Basics - Status Bar - Class (Excel Training)
The primary job of an application's Status Bar is to display vital information about the application to its user. Similar to other Windows applications, Excel Status bar is located at the bottom of the Excel window as shown below.
Cell Mode
Indicator
Cell
Mode Indicator displays the cell editing modes of Active Cell. It is located on
the left-most side of the status bar as shown in above image.
Four
available Cell Modes are explained below.
1) Ready Mode: The "Ready"
mode shows that Excel worksheet is ready to accept an input from the user.
Excel
Cell Mode status will become "Ready" when
•
Excel user is not editing any cell or user is not inserting any data
•
Excel user is not editing any defined name
•
Excel user is not editing any conditional formatting formula
•
Excel user is not editing any chart.
When at "Ready" mode, Excel is waiting for the user input.
Next three modes are Excel input modes. When the user is editing data in a cell, a defined name, a conditional formatting formula, or a chart, the Cell Mode status will become any of the three following modes. 1) Enter mode 2) Edit mode or 3) Point mode
2) Enter Mode: When a user is
entering data into a cell, the Cell Mode will become "Enter" mode. By
default, Cell Mode will become "Enter" mode, when you double click on
a blank (empty)
Excel cell with mouse pointer. One more click will change the mode to
"Edit" mode.
When
at "Enter" mode, you can change to "Edit" mode by typing
the function key "F2". You may toggle between "Enter" mode
and "Edit" mode by typing the function key "F2".
At "Enter" mode, typing any Arrow key will make the current cell lose its focus as Active Cell. Next cell will become the Active Cell in the direction of the typed Arrow key.
3) Edit Mode: If you type function
key "F2" at any Excel cell, the Cell mode will change to
"Edit" mode. If you double click on a non-blank (where
data is already filled) Excel Cell with mouse pointer, the Cell mode will
become "Edit" mode.
At "Edit" mode, typing left or right Arrow keys will make text cursor move left or right within the cell data, in the direction of Arrow key. Up and down arrows have no effect in "Edit" mode.
4) Point Mode : Point Mode is
also called as formula cell selection mode. The Cell mode status will become
Point, when you start typing a formula inside a cell (begining with
"=", "+", or "-") and then select the cells that
you want to include in that formula.
AutoCalculate Indicator
AutoCalculate
Indicator displays AutoCalculate Options. AutoCalculate Indicator is located on
the Excel Status bar, as shown in below image. AutoCalculate Options provide a
quick summary of numerical data (Sum, Average, Count).
AutoCalculate
options are explained below.
In above image, we
have four cells with numeric data 100 in each of it.
1) Average : As shown in the
status bar, "Average" is equal to 100 [(100 + 100 + 100 + 100)/4].
2) Count : As shown in the
status bar, "Count" is equal to 4, since we have four cells (with
data) in the selection.
3) Sum : As shown in the
status bar, "Sum" is equal to 400 (100 + 100 + 100 + 100).
Please
note the points below.
•
In Excel 2019, if you have cells with both numeric and text data, Excel will
show the "Count" of all cells in the selection including numeric and
non-numeric data. "Sum" and "Average" of numeric data is
also displayed.
Below
image, we have four cells in selection. Three cells with numeric data and one
cell with text data. In the status bar, Excel has displayed sum and average of
three cells with numeric data, but count of all the four cells.
• If you have cells
with all text data in the selection, Excel will show only the "Count"
value. Average and Sum values have no meaning here and will not be displayed.
Below image, we have four cells in selection. All cells in the selection contain text data only. Excel has displayed only "Count" in this case.
Caps Lock, Num Lock and Scroll Lock Indicators
Caps
Lock, Num Lock and Scroll Lock Status indicators are very helpful while working
with Excel. Caps Lock button in the left of the keyboard allows the user to
key-in text in Upper Case.
Num Lock button
allows the user to toggle the number keys on extreme right-hand side of your
keyboard between number and movement keys. When Num Lock key is ON, those keys
can be used to key-in numbers. When Num Lock key is OFF, those keys can be used
as movement keys.
Scroll
Lock button allows the user to scroll the worksheet without changing the Active
cell, while using arrow keys for navigation within the Excel worksheet.
Scroll Lock and Num Lock buttons in keyboard are shown below.
By default, Caps Lock
and Num Lock indicators are disabled in status bar and Scroll Lock is enabled.
If
Caps Lock Num Lock and Scroll Lock status indicators are enabled in Excel and
those keys are "ON" in keyboard, Excel will display those statuses as
shown below. These option statuses inform the Excel user that Caps Lock is ON,
Num Lock is ON, or Scroll Lock is ON respectively.
Typing
the "End" button enables End mode. End button in keboard is shown
below.
While at
"End" mode in Excel, typing any arrow keys allows the Excel user to
move to the end of the current region in the direction of the typed arrow key.
"End"
mode is automatically switched off once any of the arrow keys is typed. You
need to type End key again to use that functionality next time.
Extend
Selection Mode Indicator
Typing
the function key "F8" enables "Extended" mode. Normally you
select multiple cells by clicking and dragging the mouse pointer over a range
of cells. In "Extended" mode you can select a range of cells by using
the arrow keys.
You
can toggle between "Extended" mode ON/OFF by typing the function key
"F8".
Please
note that "Extended" mode and "Scroll Lock" mode can not
work together. While you are using "Extended" mode, turn OFF Scroll
Lock mode.
Add or Remove Selection Mode Indicator
Typing
Shift + F8 enables "Add or Remove Selection" mode. Normally, you add
non-adjacent cells to the selection (called as multiple selection) by pressing
Control key and then by clicking & dragging mouse pointer. In "Add or
Remove Selection" mode, you can add more cells to the current selection
without pressing Control key. You may remove already selected cells by clicking
and dragging mouse pointer again over selected cells.
Overtype mode Indicator
Typing
"Insert" key enables "Overtype" mode. Overtype mode is
similar to insert mode in normal text editors. "Overtype" mode option
is disabled by default in Excel status bar.
When you key-in a new
character in Excel Overtype mode, the newly typed character replaces the
existing character at same location.
Below
image shows an Excel window where Overtype mode is enabled. The text cursor at
character "m" in below image covers the entire character
"m". If you type a new character, "m" will be replaced by
the newly keyed character.
Circular Reference Indicator
While
writing formulas inside an Excel cell, you normally refer other cells. But, if
you refer the same cell itself inside a formula directly or indirectly, there
is a possibility of infinite loop of calculations. This situation is called
Circular Reference.
Page
View Buttons are enabled in Status Bar by default. There are three Page View
buttons on the Excel Status Bar, as shown in top-most image. Those buttons are
"Normal", "Page Layout", and "Page Break Preview"
buttons. Page View Buttons are marked in top-most image.
Page
View buttons in status bar are the shortcuts for "Normal", "Page
Layout", and "Page Break Preview" buttons available on Ribbon
> View Tab > Workbook Views group.
"Normal"
is the default view of Excel worksheet. Page Layout view displays Excel
worksheet as individual pages. "Page Break Preview" allows the user
to adjust page breaks manually.
Zoom Slider Control and Zoom Percentage indicator
Zoom
Slider Control and Zoom Percentage indicator are located at right-most part of
Excel Status Bar, as shown in top-most image. Zoom Slider Control allows Excel
users to alter the magnification level of Excel worksheet. Zoom Percentage
indicator displays the percentage of current level of magnification of Excel
worksheet.
Maximum
possible Zoom percentage of a Excel 2019 worksheet is 400% and minimum Zoom
percentage is 10%.
No comments:
Post a Comment