Spreadsheet: 104267d1301924707-learning-keyboard-shortcuts-for-excel-shortcut-keys
Sheet: OTHERS

Key | Description
[NAME] | Move one cell up, down, left, or right in a worksheet.
 | CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet.
 | SHIFT+ARROW KEY extends the selection of cells by one cell.
 | CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell.
 | [NAME] or RIGHT ARROW selects the menu to the left or right when a menu is visible. When a submenu is open, these arrow keys switch between the main menu and the submenu.
 | DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open.
 | In a dialog box, [NAME] move between options in an open drop-down list, or between options in a group of options.
 | ALT+DOWN ARROW opens a selected drop-down list.
BACKSPACE | Deletes one character to the left in the Formula Bar.
 | Also clears the content of the active cell.
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.
 | CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner).
ENTER | Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default).
 | In a data form, it moves to the first field in the next record.
 | Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command.
 | 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.
 | CTRL+ENTER fills the selected cell range with the current entry.
 | SHIFT+ENTER completes a cell entry and selects the cell above.
ESC | Cancels an entry in the cell or [NAME].
 | It also closes an open menu or submenu, dialog box, or message window.
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.
SPACEBAR | In a dialog box, performs the action for the selected button, or selects or clears a check box.
 | CTRL+SPACEBAR selects an entire column in a worksheet.
 | SHIFT+SPACEBAR selects an entire row in a worksheet.
 | CTRL+SHIFT+SPACEBAR selects the entire worksheet.
 | If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet.
 | When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet.
 | ALT+SPACEBAR displays the Control menu for the Excel window.
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.