EXCEL Shortcut keys
Switches the worksheet to Normal view.
Switches the worksheet to Page Break Preview view.
Displays the menu or message for an Error Checking button.
Move one cell up, down, left, or right in a worksheet.
Left Arrow or Right
Arrow
Selects the tab to the left or right when the Ribbon is selected. When a
submenu is open or selected, these arrow keys switch between the main
menu and the submenu. When a Ribbon tab is selected, these keys
navigate the tab buttons.
Selects the next or previous command when a menu or submenu is open.
When a Ribbon tab is selected, these keys navigate up or down the tab
group.
Down Arrow or
Alt+Down Arrow
Opens a selected drop-down list.
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.
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 turns End mode on or off. In End mode, you can press an arrow key
to move to the next nonblank cell in the same column or row as the active
cell. End mode turns off automatically after pressing the arrow key. Make
sure to press End again before pressing the next arrow key. End mode is
shown in the status bar when it is on.
If the cells are blank, pressing End followed by an arrow key moves to the
last cell in the row or column.
End also selects the last command on the menu when a menu or
submenu is visible.
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.