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 moving and scrolling on a worksheet
To |
Press |
Move one cell in a given direction |
Arrow key |
Move to the edge of the current data region |
CTRL- Arrow key |
Move between unlocked cells on a protected worksheet |
TAB |
Move to the beginning of the row |
HOME |
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 right-most used column and the bottom-most used row
(in the lower-right corner); cell opposite the Home cell, which is usually
A1 |
CTRL-END |
Move down one screen |
PAGE DOWN |
Move up one screen |
PAGE UP |
Move one screen to the right |
ALT-PAGE DOWN |
Move one screen to the left |
ALT-PAGE UP |
Go to a specific
cell |
CTRL-G |
Find a cell entry |
CTRL-F |
Repeat the last
find |
SHIFT-F4 |
Scroll to display the active cell |
CTRL-BACKSPACE |
In End mode, to |
Press |
Turn End mode on or off |
END |
Move by one block of data within a row or column |
END, Arrow key |
Move to the last cell on the worksheet, which is the cell at the
intersection of the right-most used column and the bottom-most used row
(in the lower-right corner); cell opposite the Home cell, which is
typically A1 |
END, HOME |
Move to the last cell to the right in the current row that is not blank
(unavailable if you have selected the Transition navigation keys
check box on the Transition tab [Tools menu, Options command]) |
END, ENTER |
With SCROLL LOCK turned on, to |
Press |
Turn SCROLL LOCK on or off |
SCROLL LOCK |
Move to the cell in the upper-left corner of the window |
HOME |
Move to the cell in the lower-right corner of the window |
END |
Scroll one row up or down |
UP ARROW or DOWN ARROW |
Scroll one column left or right |
LEFT ARROW or RIGHT ARROW |
Go Back to the Top of the Page
|