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 selecting data, cells, chart items, or
objects
Selecting cells, columns, rows, or objects in worksheets and workbooks
To |
Press |
Select the current region (an area around the active cell enclosed by
blank rows and blank columns) |
CTRL-* (ASTERISK) |
Extend the selection by one cell |
SHIFT- Arrow key |
Extend the selection to the last nonblank cell in the same column or
row as the active cell |
CTRL-SHIFT- Arrow key |
Extend the selection to the beginning of the row |
SHIFT-HOME |
Extend the selection to the beginning of the worksheet |
CTRL-SHIFT-HOME |
Extend the selection to the last cell used on the worksheet
(lower-right corner) |
CTRL-SHIFT-END |
Select the entire column |
CTRL-SPACEBAR |
Select the entire row |
SHIFT-SPACEBAR |
Select the entire worksheet |
CTRL-A |
If multiple cells are selected, select only the active cell |
SHIFT-BACKSPACE |
Extend the selection down one screen |
SHIFT-PAGE DOWN |
Extend the selection up one screen |
SHIFT-PAGE UP |
With an object selected, select all objects on a sheet |
CTRL-SHIFT-SPACEBAR |
Alternate between hiding objects, displaying objects, and displaying
placeholders for objects |
CTRL-6 |
Show or hide the Standard toolbar |
CTRL-7 |
In End mode, to |
Press |
Turn End mode on or off |
END |
Extend the selection to the last nonblank cell in the same column or
row as the active cell |
END, SHIFT- Arrow key |
Extend the selection to the last cell used on the worksheet
(lower-right corner) |
END, SHIFT-HOME |
Extend the selection to the last cell in the current row; this
keystroke is unavailable if you selected the Transition navigation keys
check box on the Transition tab (Tools menu, Options command) |
END, SHIFT-ENTER |
With SCROLL LOCK on, to |
Press |
Turn SCROLL LOCK on or off |
SCROLL LOCK |
Scroll the screen up or down one row |
UP ARROW or DOWN ARROW |
Scroll the screen left or right one column |
LEFT ARROW or RIGHT ARROW |
Extend the selection to the cell in the upper-left corner of the window |
SHIFT-HOME |
Extend the selection to the cell in the lower-right corner of the
window |
SHIFT-END |
Selecting cells with special characteristics
To |
Press |
Select the current region (an area around the active cell enclosed by
blank rows and blank columns) |
CTRL-* (ASTERISK) |
Select the current array, which is the array that the active cell
belongs to |
CTRL-/ |
Select all cells with comments |
CTRL-SHIFT-O (the letter O) |
Select cells whose contents are different from the comparison cell in
each row (for each row, the comparison cell is in the same column as the
active cell) |
CTRL-\ |
Select cells whose contents are different from the comparison cell in
each column (for each column, the comparison cell is in the same row as
the active cell) |
CTRL-SHIFT-| |
Select only cells that are directly referred to by formulas in the
selection |
CTRL-[ |
Select all cells that are directly or indirectly referred to by
formulas in the selection |
CTRL-SHIFT-{ |
Select only cells with formulas that refer directly to the active cell |
CTRL-] |
Select all cells with formulas that refer directly or indirectly to the
active cell |
CTRL-SHIFT-} |
Select only visible cells in the current selection |
ALT-SEMICOLON |
Moving within a selection
To |
Press |
Move from top to bottom within the selection (down), or in the
direction that is selected on the Edit tab (Tools menu, Options command) |
ENTER |
Move from bottom to top within the selection (up), or opposite to the
direction that is selected on the Edit tab (Tools menu, Options command) |
SHIFT-ENTER |
Move from left to right within the selection, or move down one cell if
only one column is selected |
TAB |
Move from right to left within the selection, or move up one cell if
only one column is selected |
SHIFT-TAB |
Move clockwise to the next corner of the selection |
CTRL-PERIOD |
Move to the right between nonadjacent selections |
CTRL-ALT-RIGHT ARROW |
Move to the left between nonadjacent selections |
CTRL-ALT-LEFT ARROW |
Selecting chart items
To |
Press |
Select the previous group of items |
DOWN ARROW |
Select the next group of items |
UP ARROW |
Select the next item within the group |
RIGHT ARROW |
Select the previous item within the group |
LEFT ARROW |
Go Back to the Top of the Page
|