Excel Shortcuts – Ctrl Key

Reading time: 9 minutes
Last Updated on 05/12/2021 by Frédéric LE GUEN

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