|
1. Navigating in Worksheets and
Selecting Cells
|
|
|
Ctrl+Shift+[+]
|
Insert a new row or column (after the
current row is selected with shift+space, or column is selected
with ctrl+space
|
|
arrow left, arrow right, arrow up, arrow down
|
Move one cell up, down, left, or right
in a worksheet.
|
|
Ctrl+Arrow Keys
|
Moves to the edge of the current data
region
|
|
Shift+Arrow Keys
|
Extends the selection of cells by one
cell.
|
|
Ctrl+Shift+Arrow Keys
|
Extends the selection of cells to the
last nonblank cell in the same column or row as the active cell, or if the
next cell is blank, extends the selection to the next nonblank cell
|
|
Backspace
|
Deletes one character to the left in
the Formula Bar. Also clears the content of the active cell. In cell editing
mode, it deletes the character to the left of the insertion point
|
|
Delete
|
Removes the cell contents (data and
formulas) from selected cells without affecting cell formats or comments. In
cell editing mode, it deletes the character to the right of the insertion
point.
|
|
End
|
Moves to the cell in the lower-right
corner of the window when SCROLL LOCK is turned on. Also selects the last
command on the menu when a menu or submenu is visible.
|
|
Ctrl+End
|
Moves to the last cell on a worksheet,
in the lowest used row of the rightmost used column. If the cursor is in the
formula bar, CTRL+END moves the cursor to the end of the text
|
|
Ctrl+Shift+end in
worksheet
|
Extends the selection of cells to the
last used cell on the worksheet (lower-right corner).
|
|
Ctrl+Shift+end in
formula bar
|
Selects all text in the formula bar
from the cursor position to the end—this does not affect the height of the
formula bar.
|
|
Enter
|
Completes a cell entry and selects the
cell below
|
|
Shift+Enter
|
Completes a cell entry and selects the
cell above.
|
|
Ctrl+Enter
|
Completes a cell entry and stays in
the same cell
|
|
Alt+Enter
|
Starts a new line in the same cell
|
|
Esc
|
Cancels an entry in the cell or
Formula Bar. Closes an open menu or submenu, dialog box, or message window.
It also closes full screen mode when this mode has been applied, and returns
to normal screen mode to display the Ribbon and status bar again.
|
|
Home
|
Moves to the beginning of a row in a
worksheet. Moves to the cell in the upper-left corner of the window
when scroll lock is turned on. Selects
the first command on the menu when a menu or submenu is visible.
|
|
Ctrl+Home
|
Moves to the beginning of a worksheet.
|
|
Ctrl+Shift+Home
|
Extends the selection of cells to the
beginning of the worksheet
|
|
Page Down
|
Moves one screen down in a worksheet.
|
|
Alt+Page Down
|
Moves one screen to the right in a
worksheet.
|
|
Ctrl+Page Down
|
Moves to the next sheet in a workbook.
|
|
Ctrl+Shift+Page Down
|
Selects the current and next sheet in
a workbook
|
|
Page Up
|
Moves one screen up in a worksheet.
|
|
Alt+Page Up
|
Moves one screen to the left in a
worksheet.
|
|
Ctrl+Page Up
|
Moves to the previous sheet in a
workbook.
|
|
Ctrl+Shift+Page Up
|
Selects the current and previous sheet
in a workbook
|
|
Space
|
In a dialog box, performs the action
for the selected button, or selects or clears a check box.
|
|
Ctrl+Space
|
Selects an entire column in a
worksheet.
|
|
Shift+Space
|
Selects an entire row in a worksheet.
|
|
Ctrl+Shift+Space
|
Selects the entire worksheet.
|
|
Tab
|
Moves one cell to the right in a
worksheet. Moves between unlocked cells in a protected worksheet. Moves to
the next option or option group in a dialog box.
|
|
Shift+Tab
|
Moves to the previous cell in a
worksheet or the previous option in a dialog box.
|
|
Ctrl+Tab
|
Switches to the next tab in dialog box
|
|
Ctrl+Shift+Tab
|
Switches to the previous tab in a
dialog box.
|
Comments