Excel Shortcuts – Ctrl Key

Excel Shortcuts – Ctrl Key
Last Updated on 05/12/2021
Reading time: 9 minutes

Discover all the shortcuts with the Control Key

Follow these links to have others shortcuts with Excel,

Shortcut with figure

Warning: These shortcuts don't work with the keypad.

Ctrl + Ctrl + 1 Open the dialog box Cell Format
Ctrl + Ctrl + 2 Toogle Bold
Ctrl + Ctrl + 3 Toogle Italic
Ctrl + Ctrl + 4 Toogle Underline
Ctrl + Ctrl + 5 Toogle Strike through
Ctrl + Ctrl + 6  
Ctrl + Ctrl + 7  
Ctrl + Ctrl + 8 Outline
Ctrl + Ctrl + 9 Hide Row
Ctrl + Ctrl + 0 Hide Column

Shortcut with letter

Ctrl + Ctrl + A
  • Select all cells around the active cell (non-empty)
  • Select all cells of your worksheet (if the active cell is empty)
  • When you fill a formula, Ctrl + A display the formula's Dialog box.
Ctrl + Ctrl + B Toogle Bold
Ctrl + Ctrl + C Copy
Ctrl + Ctrl + D
  • Fill Down
  • Duplicate an object selected (Chart, Shapes, SmartArt, ...)
Ctrl + Ctrl + E  FlashFill
Ctrl + Ctrl + F Open the dialog box Find
Ctrl + Ctrl + G Open the dialog box Goto
Ctrl + Ctrl + H Open the dialog box Replace
Ctrl + Ctrl + I Toogle Italic
Ctrl + Ctrl + J  
Ctrl + Ctrl + K Insert an Hyperlink
Ctrl + Ctrl + L Create a table
Ctrl + Ctrl + M  
Ctrl + Ctrl + N Open a new workbook
Ctrl + Ctrl + O Open the dialog box Open a workbook
Ctrl + Ctrl + P Print
Ctrl + Ctrl + Q  
Ctrl + Ctrl + R Fill Right
Ctrl + Ctrl + S Save your workbook
Ctrl + Ctrl + T Create a table (yes, one more time)
Ctrl + Ctrl + U Toogle Underline
Ctrl + Ctrl + V Paste
Ctrl + Ctrl + W Close your workbook
Ctrl + Ctrl + X Cut
Ctrl + Ctrl + Y Repeat action
Ctrl + Ctrl + Z Undo the last action

Shortcut with symbol

Ctrl + Ctrl + Star Select all the continous cells around the active cell
Ctrl + Ctrl + Home Return to the cell A1
Ctrl + Ctrl + End Return to the last cell known by Excel (and it's not necessarily the last cell of your array)
Ctrl + Ctrl + Arrow Down Goto the last non-empty cell of your column
Ctrl + Ctrl + Arrow Up Goto the first non-empty cell of your column
Ctrl + Ctrl + Arrow Left Goto the first non-empty cell of your row
Ctrl + Ctrl + Arrow Right Goto the last non-empty cell of your row
Ctrl + Ctrl + < Copy the contain of the first row to the rest of your selection (more than 1 cell selected)
Ctrl + Ctrl + > Copy the contain of the first column to the rest of your selection (more than 1 cell selected)
Ctrl + Ctrl + ` Toogle Formula mode
Ctrl + Ctrl + ; Insert the Date in your active cell
Ctrl + Ctrl + : Insert the Time in your active cell
Ctrl + Ctrl + % Format percentage
Ctrl + Ctrl + - Delete selection
Ctrl + Ctrl + + Insert selection
Ctrl + Ctrl + & Applies the outline border to the selected cells
Ctrl + Ctrl + _ Removes the outline border from the selected cells
Ctrl + Ctrl + ( Unhides any hidden rows within the selection
Ctrl + Ctrl + ) Unhides any hidden columns within the selection
Ctrl + Ctrl + # Applies the Date format with the day, month, and year
Ctrl + Ctrl + ^ Applies the Exponential number format with two decimal places

Shortcut with Function keys

Ctrl + Ctrl + F1 Hide / Unhide the Ribbon
Ctrl + Ctrl + F2 View before Print
Ctrl + Ctrl + F3 Define name
Ctrl + Ctrl + F4 Close workbook
Ctrl + Ctrl + F5 Restore Windows size
Ctrl + Ctrl + F6 Toogle to the next workbook
Ctrl + Ctrl + F7 Move Window (with the arrows)
Ctrl + Ctrl + F8 Resize Window (with the arrows)
Ctrl + Ctrl + F9 Minimize Workbook
Ctrl + Ctrl + F10 Restore Workbook
Ctrl + Ctrl + F11 Insert a Macro Excel 4
Ctrl + Ctrl + F12 Open the dialog box Open a Workbook

Leave a Reply

Your email address will not be published. Required fields are marked *

Excel Shortcuts – Ctrl Key

Reading time: 9 minutes
Last Updated on 05/12/2021

Discover all the shortcuts with the Control Key

Follow these links to have others shortcuts with Excel,

Shortcut with figure

Warning: These shortcuts don't work with the keypad.

Ctrl + Ctrl + 1 Open the dialog box Cell Format
Ctrl + Ctrl + 2 Toogle Bold
Ctrl + Ctrl + 3 Toogle Italic
Ctrl + Ctrl + 4 Toogle Underline
Ctrl + Ctrl + 5 Toogle Strike through
Ctrl + Ctrl + 6  
Ctrl + Ctrl + 7  
Ctrl + Ctrl + 8 Outline
Ctrl + Ctrl + 9 Hide Row
Ctrl + Ctrl + 0 Hide Column

Shortcut with letter

Ctrl + Ctrl + A
  • Select all cells around the active cell (non-empty)
  • Select all cells of your worksheet (if the active cell is empty)
  • When you fill a formula, Ctrl + A display the formula's Dialog box.
Ctrl + Ctrl + B Toogle Bold
Ctrl + Ctrl + C Copy
Ctrl + Ctrl + D
  • Fill Down
  • Duplicate an object selected (Chart, Shapes, SmartArt, ...)
Ctrl + Ctrl + E  FlashFill
Ctrl + Ctrl + F Open the dialog box Find
Ctrl + Ctrl + G Open the dialog box Goto
Ctrl + Ctrl + H Open the dialog box Replace
Ctrl + Ctrl + I Toogle Italic
Ctrl + Ctrl + J  
Ctrl + Ctrl + K Insert an Hyperlink
Ctrl + Ctrl + L Create a table
Ctrl + Ctrl + M  
Ctrl + Ctrl + N Open a new workbook
Ctrl + Ctrl + O Open the dialog box Open a workbook
Ctrl + Ctrl + P Print
Ctrl + Ctrl + Q  
Ctrl + Ctrl + R Fill Right
Ctrl + Ctrl + S Save your workbook
Ctrl + Ctrl + T Create a table (yes, one more time)
Ctrl + Ctrl + U Toogle Underline
Ctrl + Ctrl + V Paste
Ctrl + Ctrl + W Close your workbook
Ctrl + Ctrl + X Cut
Ctrl + Ctrl + Y Repeat action
Ctrl + Ctrl + Z Undo the last action

Shortcut with symbol

Ctrl + Ctrl + Star Select all the continous cells around the active cell
Ctrl + Ctrl + Home Return to the cell A1
Ctrl + Ctrl + End Return to the last cell known by Excel (and it's not necessarily the last cell of your array)
Ctrl + Ctrl + Arrow Down Goto the last non-empty cell of your column
Ctrl + Ctrl + Arrow Up Goto the first non-empty cell of your column
Ctrl + Ctrl + Arrow Left Goto the first non-empty cell of your row
Ctrl + Ctrl + Arrow Right Goto the last non-empty cell of your row
Ctrl + Ctrl + < Copy the contain of the first row to the rest of your selection (more than 1 cell selected)
Ctrl + Ctrl + > Copy the contain of the first column to the rest of your selection (more than 1 cell selected)
Ctrl + Ctrl + ` Toogle Formula mode
Ctrl + Ctrl + ; Insert the Date in your active cell
Ctrl + Ctrl + : Insert the Time in your active cell
Ctrl + Ctrl + % Format percentage
Ctrl + Ctrl + - Delete selection
Ctrl + Ctrl + + Insert selection
Ctrl + Ctrl + & Applies the outline border to the selected cells
Ctrl + Ctrl + _ Removes the outline border from the selected cells
Ctrl + Ctrl + ( Unhides any hidden rows within the selection
Ctrl + Ctrl + ) Unhides any hidden columns within the selection
Ctrl + Ctrl + # Applies the Date format with the day, month, and year
Ctrl + Ctrl + ^ Applies the Exponential number format with two decimal places

Shortcut with Function keys

Ctrl + Ctrl + F1 Hide / Unhide the Ribbon
Ctrl + Ctrl + F2 View before Print
Ctrl + Ctrl + F3 Define name
Ctrl + Ctrl + F4 Close workbook
Ctrl + Ctrl + F5 Restore Windows size
Ctrl + Ctrl + F6 Toogle to the next workbook
Ctrl + Ctrl + F7 Move Window (with the arrows)
Ctrl + Ctrl + F8 Resize Window (with the arrows)
Ctrl + Ctrl + F9 Minimize Workbook
Ctrl + Ctrl + F10 Restore Workbook
Ctrl + Ctrl + F11 Insert a Macro Excel 4
Ctrl + Ctrl + F12 Open the dialog box Open a Workbook

Leave a Reply

Your email address will not be published. Required fields are marked *