Reading: Excel Keyboard Shortcuts
Estimated time needed: n/a
The table below lists keyboard shortcuts for some of the most common Excel tasks.
Task Shortcut
Close a workbook Ctrl+W
Open a workbook Ctrl+O
Save a workbook Ctrl+S
Copy Ctrl+C
Cut Ctrl+X
Paste Ctrl+V
Undo Ctrl+Z
Remove cell contents Delete
Bold Ctrl+B
Open context menu Shift+F10
Expand or collapse the ribbon Ctrl+F1
Move up one cell in the worksheet Up arrow key
Move down one cell in the worksheet Down arrow key
Move one cell left in the worksheet Left arrow key
Move one cell right in the worksheet Right arrow key
Move to the edge of the current data region in the Ctrl+Arrow key (e.g.
worksheet (e.g. end of column) Ctrl+Down arrow)
Move to the last cell on a worksheet Ctrl+End
Move to the beginning of a worksheet Ctrl+Home
Extend the selection of cells to the last used cell on a Ctrl+Shift+End
worksheet (lower right corner)
Move to the cell in the upper-left corner of the window Home+Scroll Lock
(when Scroll Lock is On)
Move one screen down in a worksheet Page Down
Move one screen up in a worksheet Page Up
Move one screen to the right in a worksheet Alt+Page Down
Move one screen to the left in a worksheet Alt+Page Up
Move to the next sheet in a workbook Ctrl+Page Down
Move to the previous sheet in a workbook Ctrl+Page Up
Task Shortcut
Edit the active cell and put the cursor at the end of the F2
cell's contents
Enter the current time Ctrl+Shift+colon (:)
Enter the current date Ctrl+semi-colon (;)