Home > Microsoft Excel Shortcuts by Shift Key

Shift Key Shortcuts for Excel

Please click on a header to see the shortcuts

Shift + Function Keys

Shift + F2 Inserts or edits a cell comment (Insert > Comment)

Shift + F3 Displays the (Insert > Function) dialog box

Shift + F4 Repeats the last Find, the same as (Edit > Find Next)

Shift + F5 Displays the (Edit > Find) dialog box

Shift + F6 Moves to the previous pane in a workbook (if the window is split)

Shift + F8 Toggles between switching Add Mode on or off*

Shift + F9 Calculates just the active worksheet

Shift + F10 Displays the (Shortcut) menu for the selected item

Shift + F11 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet)

Shift + F12 Saves, Displays the (File > Save As) dialog box if a new workbook

Ctrl + Shift + Function

Ctrl + Shift + F3 Displays the (Insert > Name > Create) dialog box

Ctrl + Shift + F6 Moves to the previous open workbook or window

Ctrl + Shift + F10 Activates the Menu Bar or Shortcut Characters in 2007

Ctrl + Shift + F12 Displays the (File > Print) dialog box

Ctrl + Shift + Letters

Ctrl + Shift + F Activates the Font Tab of the format cells

Ctrl + Shift + O Selects all the cells with comments

Ctrl + Shift + P Activates the Font Size tab of the format cells

Editing Data

Ctrl + Shift + = Displays the Cells dialog box

Entering Data

Shift + Enter Enters the contents of the active cell and moves to the cell above (by default)

Shift + Tab Enters the contents of the active cell and moves one cell to the left

Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell

Ctrl + Shift + ; Enters the current time into the active cell

Ctrl + Shift + Enter Enters the formula as an Array Formula

Shift + Insert Enters the data from the clipboard

Selecting Data

Ctrl + Shift + \ Selects the cells in a selected column that do not match the value in the active cell

Ctrl + Shift + (8 or *) Selects the current region (surrounded by blank rows and columns)

Ctrl + Shift + [ Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell

Ctrl + Shift + ] Selects all the cells that directly (or indirectly) refer to the active cell

Ctrl + Shift + Page Down Selects the active worksheet and the one after it

Ctrl + Shift + Page Up Selects the active worksheet and the one before it

Ctrl + Shift + Spacebar Selects all the objects on the worksheet when an object is selected or selects the whole worksheet

Shift + Arrow keys Selects the active cell and the cell in the given direction

Shift + Backspace Selects the active cell when multiple cells are selected

Shift + Spacebar Selects the current row

Extending Data

Ctrl + Shift + Arrow Key Extends the selection to the next cell adjacent to a blank cell in that direction

Ctrl + Shift + End Extends the selection to the last used cell on the worksheet

Ctrl + Shift + Home Extends the selection to the beginning of the worksheet

Shift + Arrow Keys Extends the selection by one cell in that direction

Shift + Home Extends the selection to the first column

Shift + Page Down Extends the selection down one screen

Shift + Page Up Extends the selection up one screen

End + Shift + Arrow Keys Extends the selection to the next non-blank cell in that direction

End + Shift + End Extends the selection to the last cell in the current row*

End + Shift + Home Extends the selection to last used cell on the worksheet

Formatting Data

Ctrl + Shift + ( ' or ) Applies the Time format "hh:mm" to the selection

Ctrl + Shift + (1 or !) Applies the Comma separated format "#,##0.00" to the selection

Ctrl + Shift + (4 or $) Applies the Currency format "£#,##0.00" to the selection

Ctrl + Shift + (5 or %) Applies the Percentage format "0%" to the selection

Ctrl + Shift + (6 or ^) Applies the Exponential format "#,##E+02" to the selection

Ctrl + Shift + (# or ~) Applies the General format to the selection

Ctrl + Shift + (7 or &) Applies the outline border to the selection

Ctrl + Shift + (- or _ ) Removes all the borders from the selection

Manoeuvring

Alt + Shift + Tab Moves to the previous application open on your computer

Shift + Enter Moves to the cell directly above (opposite direction to Enter)

Shift + Tab Moves to the cell directly to the left (opposite direction to Tab)

Ctrl + Shift + Tab Moves to the previous open workbook or window

Manoeuvring (within a selection)

Shift + Tab Moves from right to left within a selection (opposite direction to Tab)

Other

Ctrl + Shift + ( Unhides any hidden rows within the selection

Ctrl + Shift + ) Unhides any hidden columns within the selection

Ctrl + Shift + \ Select unequal cells

Alt + Shift + Left Arrow Displays the (Data > Group and Outline > UnGroup) dialog box

Alt + Shift + Right Arrow Displays the (Data > Group and Outline > Group) dialog box

Shift + Insert Pastes the entry from the clipboard