The Message area on the left of the Status Bar shows your status and gives hints about what you are doing. You'll see things like:
Ready
Edit
Preview: Page 1 of 3
Select destination and press ENTER or choose Paste.
Some messages, like Edit,
are mode indicators, too. When in Edit mode, your standard keys for navigating
(arrow keys, TAB, ENTER) behave as they do in Word. This is what you need when
you want to edit what is in a cell.
The globe spins while a Web Query is running. A Web query gets data from a source over the Internet. Stock market prices, for example, are available this way and are displayed as an Excel worksheet once the data is downloaded to your computer.
The command to start a Web Query is on the menu: | |
The AutoCalculate area will use the current selection in the spreadsheet to do one of 6 standard calculations.
You can switch to another calculation. Right click the status bar to see the popup menu listing the functions you can choose. Click on the function you want. This is useful for quick checks, especially for counting the number of cells in a selection.
The mode indicators on the right end of the Status Bar show when certain features are turned on. Unlike in Word, double-clicking these indicators does not toggle them on and off. You must use the keyboard.
If your keystrokes are not producing the expected result, check to see if one of the mode indicators is on.
| Mode | Key | Action |
|---|---|---|
|
CAPS |
Caps Lock |
Makes your letters upper case. |
|
NUM |
Num Lock |
Allows the keypad on the right to enter numbers. |
|
SCRL |
Scroll Lock |
Affects the way certain key combos scroll the screen. |
|
END |
End |
Certain key combos produce different motions in End mode. Scroll Lock must be off to use End mode. |
|
OVR |
Insert |
If you are editing a cell, the INSERT key toggles overtyping on and off. |
To see the whole list of key combos affected, look at the
Help article on keyboard shortcuts:
First, open Excel's Help
and search for "keyboard shortcuts".
Choose "Keys for moving and scrolling in a worksheet or workbook" from the Keyboard Shortcuts article.
In the task pane, open the topic Keyboard shortcuts, and read the articles "Move and scroll in End mode" and "Move and scroll with SCROLL LOCK on".
|
Teachers: Request permission to use this site with your class Copyright © 1997-2012 Jan Smith <jegs1@jegsworks.com>All Rights Reserved |
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~
