Useful Shortcut Keys in Excel
2000
Do you find that using the keyboard
is sometimes quicker than using your mouse? Shortcut keys can help you bypass
menus and carry out commands directly. You can use shortcut keys in many ways
with Excel, from accessing commands and toolbar buttons to outlining and editing
information. Shortcut keys are sometimes listed next to the command name on
menus. For example, on the Edit menu, the Copy command shows the shortcut CTRL+C.
| Activity |
Shortcut Keys |
| Select the current column |
CTRL+SPACEBAR |
|
Select the current row
|
SHIFT+SPACEBAR |
| Move to the beginning of the worksheet |
CTRL+HOME |
| Move to the last cell on the worksheet, which is the cell at
the intersection of the rightmost used column and the bottommost used row
(in the lower-right corner), or the cell opposite the home cell, which is
typically A1 |
CTRL+END |
| Paste a function into a formula |
SHIFT+F3 |
| When you enter a formula, display the Formula Palette
after you type a function name |
CTRL+A |
| Select all (when you are not entering or editing a formula) |
CTRL+A |
| Alternate between displaying cell values and displaying cell
formulas |
CTRL+` (single left quotation mark) |
| Calculate all sheets in all open workbooks |
F9 |
| Calculate the active worksheet |
SHIFT+F9 |
| Create a chart that uses the current range |
F11 or ALT+F1 |
| Enter the date |
CTRL+; (semicolon) |
| Enter the time |
CTRL+: (colon) |
| Fill the selected cell range with the current entry |
CTRL+ENTER |
| Display the Go To dialog box |
F5 |
| Display the Format Cells dialog box |
CTRL+1 |
| Copy |
CTRL+C |
| Paste |
CTRL+V |
| Undo |
CTRL+Z |
| Save |
CTRL+S |
| Print |
CTRL+P |
| Open |
CTRL+O |
