Home > Ctrl Key Microsoft Excel Shortcuts

Control Key Shortcuts for Excel

Please click on a header to see the shortcuts

Ctrl + Function

Ctrl + F1 Closes and reopens the current task pane (ribbon in 2007)

Ctrl + F2 Print Preview

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

Ctrl + F4 Closes the selected workbook window

Ctrl + F5 Restores the size of the active workbook or window

Ctrl + F6 Moves to the next open workbook or window

Ctrl + F7 Activates the Move window command

Ctrl + F8 Activates the Resize window command

Ctrl + F9 Minimises the size of the active workbook or window

Ctrl + F10 Maximises the size of the active workbook or window

Ctrl + F12 Displays the (File > Open) dialog box

Alt + Ctrl + Function

Alt + Ctrl + F9 Calculates All cells on All worksheets in All workbooks

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 + Numbers

Ctrl + 0 Hides the columns in the current selection

Ctrl + 1 Displays the formatting dialog box

Ctrl + 2 Toggles bold on the current selection

Ctrl + 3 Toggles italics on the current selection

Ctrl + 4 Toggles underlining on the current selection

Ctrl + 5 Toggles the strikethrough of text on the current selection

Ctrl + 6 Toggles between hiding, displaying

Ctrl + 8 Toggles the display of Outline symbols on the active worksheet

Ctrl + 9 Hides the rows in the current selection (Format > Row > Hide)

Ctrl + Shift + 0 Unhides the columns in the current selection

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

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

Ctrl + Shift + 9 Unhides the rows in the current selection

Ctrl + Letters

Ctrl + A Displays formula palette given a function name or selects the whole worksheet or current date

Ctrl + B Toggles bold on the current selection

Ctrl + C Copies the current selection to the clipboard

Ctrl + D Copies the first cell in the selection downwards

Ctrl + F Displays the Find dialog box

Ctrl + G Displays the GoTo dialog box

Ctrl + H Displays the Replace dialog box

Ctrl + I Toggles italics on the current selection

Ctrl + K Displays the Insert Hyperlink dialog box

Ctrl + L Displays the Create Table dialog box

Ctrl + N Creates a new workbook

Ctrl + O Displays the Open dialog box

Ctrl + P Displays the Print dialog box

Ctrl + R Copies the leftmost cell in the selection to the right

Ctrl + S Saves, Displays the Save As dialog box if a new workbook

Ctrl + U Toggles underlining on the current selection

Ctrl + V Pastes the entry from the clipboard

Ctrl + W Closes the active workbook or window

Ctrl + X Cuts the current selection to the clipboard

Ctrl + Y Repeats the last workbook action Ctrl + Z Undo the last workbook action

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

Entering Data

Ctrl + ' Enters the contents from the cell directly above into the active cell

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

Ctrl + ; Enters the current date into the active cell

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

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

Editing Data

Ctrl + Delete Deletes text to the end of the line Ctrl + - Displays the Delete dialog box

Ctrl + Shift + = Displays the Cells dialog box

Selecting Data

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

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

Ctrl + / Selects the array containing the active cell ??

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

Ctrl + * Selects the current region (using the * on the number keyboard)

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

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

Ctrl + ] Selects all the cells that directly refer to the active cell (dependents)

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

Ctrl + Spacebar Selects the current column

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

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 + (# or ~) Applies the Custom Date format "dd-mmm-yy" 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

Ctrl + Tab Moves to the next open workbook or window

Ctrl + Home Moves to cell "A1" on the active sheet

Ctrl + End Moves to the last used cell on the active worksheet*

Ctrl + Up Arrow Moves to the first row in the current region

Ctrl + Down Arrow Moves to the last row in the current region

Ctrl + Left Arrow Moves to the first column in the current region

Ctrl + Right Arrow Moves to the last column in the current region

Ctrl + Page Up Moves to the previous worksheet in the workbook

Ctrl + Page Down Moves to the next worksheet in the workbook

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

Manoeuvring (within a selection)

Ctrl + . Moves clockwise to the next corner within a selection

Alt + Ctrl + Left Arrow Moves to the left between non adjacent cells in a selection

Alt + Ctrl + Right Arrow Moves to the right between non adjacent cells in a selection

Other

= Starts a Formula

Ctrl + ` Toggles between the value layer and the formula layer

Ctrl + Insert Copies the current selection to the clipboard

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

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

Ctrl + Shift + \ Select unequal cells