Key Combination | Action |
---|---|
Shift + F2 | Add comment |
Shift + F3 | Open insert function dialog |
Shift + F4 | Find Next Match (after closing Find Dialog) |
Shift + F6 | Move to previous pane (Split pane) |
Shift + F7 | Open Thesaurus Dialog box) |
Shift + F8 | Toggle add to Selection Mode |
Shift + F9 | Calculate active worksheet |
Shift + F10 | Display Right click menu |
Shift + F11 | Insert new worksheet |
Shift + ↑ | Extend Selection by one cell/row up |
Shift + ↓ | Extend Selection by one cell/row down |
Shift + → | Extend Selection by one cell/row right |
Shift + ← | Extend Selection by one cell/row left |
Shift + HOME | Extend selection up to the first cell of the row |
Shift + → | Select one character right |
Shift + ← | Select one character left |
Shift + Drag and Drop | Swap or Insert Cells/Rows/Columns |
Shift + Click (left mouse button) | Select adjacent worksheets |
Shift + TAB | Move active cell left in selection |
Shift + ENTER | Move active cell UP in selection |
Shift + BACKSPACE | Select Active Cell only |
Shift + HOME | Select up to Beginning of a cell |
Shift + SPACE | Select entire Row/Rows |
Shift + END | Select up to End of a cell |
Shift + ENTER | Move up one cell in selection |
Shift + TAB | Move left one cell in selection |
Shift + TAB | Move to next control (any Dialog box) |
Read more about Excel Shortcuts…