Microsoft Office Tutorials and References
In Depth Information
Other shortcut keys
END turns on what’s called End Mode. In End mode, you can then press an arrow key to
move to the next nonblank cell in the same column or row as the active cell. If the cells are
blank, pressing END followed by an arrow key moves to the very last cell in the row or
column – that is row 1048576 or column XFD.
END 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, to the lowest used row of the rightmost
used column. But see the additional discussion about this in Chapter 2. If the cursor is in the
formula bar, CTRL+END moves the cursor to the end of the text as does END.
CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet
(lower-right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in
the formula bar from the cursor position to the end—this does not affect the height of the
Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by
Opens a selected ribbon (press F10 to activate the menu bar) or performs the action for a
In a dialog box, it performs the action for the default command button in the dialog box (the
button with the bold outline, often the OK button).
ALT+ENTER starts a new line in the same cell – a kind of a manual Wrap Text, when entering
data in that cell.
CTRL+ENTER fills the selected cell range with the value you’re currently entering. That is, if
you select A1:A10 and type 45 in A1, CTRL+ENTER – instead of ENTER - will copy 45 to cells
SHIFT+ENTER completes a cell entry and selects the cell above.
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 (achieved via View tab Worksheet Views Full Screen)
when this mode has been applied, and returns to normal screen mode to display the ribbon
and status bar again.
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.
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.