Excel 97/2000 Shortcut Keys
[Keys for working with spreadsheet files]
[Keys for moving and scrolling on a worksheet] [Keys for moving between worksheet panes, worksheets, and
workbooks] [Keys for entering data] [Keys for formatting data]
[Keys for editing data] [Keys for selecting data, cells, chart items, or
objects] [Keys for printing and previewing a spreadsheet file]
[Keys for working with names] [Keys for working with databases, lists, and
PivotTables] [Keys for outlining data]
Keys for editing data
To
|
Press
|
Edit the active cell
|
F2
|
Accept edits
|
ENTER
|
Cancel edits
|
ESC
|
Navigating a cell entry
To
|
Press
|
Move one character up,
down, left, or right
|
UP, DOWN, LEFT, OR
RIGHT ARROW
|
Move to the beginning
of the line
|
HOME
|
Move
to the end of the line |
END |
Move to the beginning
of the entry
|
CTRL-HOME
|
Move
to the end of the entry |
CTRL-END |
Move
one group of characters to the left or right |
CTRL-LEFT
OR RIGHT ARROW |
Editing cell entries
To
|
Press
|
Delete the character
to the left of the insertion point, or delete the selection
|
BACKSPACE
|
Delete the character
to the right of the insertion point, or delete the selection
|
DELETE
|
Delete text to the end
of the line
|
CTRL-DELETE
|
Paste a name into a
formula
|
F3
|
Insert the argument
names and parentheses for a function (after you type a valid function name
in a formula)
|
CTRL-SHIFT-A
|
Inserting, deleting, cutting, or copying a selection
To |
Press |
Cut the selection |
CTRL-X |
Copy the selection |
CTRL-C |
Paste the selection |
CTRL-V |
Clear the contents of the selection |
DELETE |
Insert blank cells |
CTRL-SHIFT-+ (PLUS SIGN) |
Delete selected cells |
CTRL- – |
Go Back to the Top of the Page
|