Shift Key Shortcuts in Excel

Shift Key Shortcuts in Excel
Key CombinationAction
Shift + F2Add comment
Shift + F3Open insert function dialog
Shift + F4Find Next Match (after closing Find Dialog)
Shift + F6Move to previous pane (Split pane)
Shift + F7Open Thesaurus Dialog box)
Shift + F8Toggle add to Selection Mode
Shift + F9Calculate active worksheet
Shift + F10Display Right click menu
Shift + F11Insert 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 + HOMEExtend selection up to the first cell of the row
Shift + →Select one character right
Shift + ←Select one character left
Shift + Drag and DropSwap or Insert Cells/Rows/Columns
Shift + Click (left mouse button)Select adjacent worksheets
Shift + TABMove active cell left in selection
Shift + ENTERMove active cell UP in selection
Shift + BACKSPACESelect Active Cell only
Shift + HOMESelect up to Beginning of a cell
Shift + SPACESelect entire Row/Rows
Shift + ENDSelect up to End of a cell
Shift + ENTERMove up one cell in selection
Shift + TABMove left one cell in selection
Shift + TABMove to next control (any Dialog box)

Read more about Excel Shortcuts…

200+ Excel Shortcuts

Functions keys and Excel Shortcuts

Crtl Key Shortcuts in Excel