Select
data, cells, chart items, or objects by using shortcut keys
|
|
|
|
Select cells, columns, rows, or objects in worksheets and
workbooks by using shortcut keys
|
|
To
|
Press
|
|
Select the current region around
the active cell (the current region is an area enclosed by blank rows and
blank columns)
|
CTRL+SHIFT+* (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
|
|
Tip When you use the scrolling keys (such as
PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the
distance you scroll. If you want to keep the same selection as you scroll,
turn on SCROLL LOCK first.
|
|
|
|
|
|
Select cells with special characteristics by using shortcut keys
|
|
To
|
Press
|
|
Select the current region around
the active cell (the current region is an area enclosed by blank rows and
blank columns)
|
CTRL+SHIFT+* (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
|
|
|
|
|
Select chart items by using shortcut keys
|
|
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
|
|
|
|
|
|