Mastering the Excel Control (Ctrl) key shortcuts is essential for increasing productivity.
With these shortcuts, you can easily navigate, format, and manipulate data in Excel, saving time and reducing the need for a mouse. Whether you’re a beginner or advanced user, these shortcuts will streamline your workflow and help you get more done in less time.
Top Excel Ctrl Key Shortcuts with Numbers
Note: These shortcuts only work with the standard number keys, not the numeric keypad.
Action
Shortcut
Open Cell Format dialog box
Ctrl + 1
Toggle Bold
Ctrl + 2
Toggle Italic
Ctrl + 3
Toggle Underline
Ctrl + 4
Toggle Strikethrough
Ctrl + 5
Show/Hide objects
Ctrl + 6
Show Outline (Group / Ungroup Rows / Columns)
Ctrl + 8
Hide Row
Ctrl + 9
Hide Column
Ctrl + 0
Excel Ctrl Key Shortcuts with Letters
Below is a comprehensive list of Excel shortcuts using the Ctrl key and letters.
Action
Key Combination
Select all cells around the active cell (non-empty) or the entire worksheet (if empty). In formulas, this opens the formula’s dialog box.
Ctrl + A
Toggle Bold formatting.
Ctrl + B
Copy selected cells or content.
Ctrl + C
Fill Down or duplicate a selected object (Chart, Shape, SmartArt, etc.).
Ctrl + D
Apply Flash Fill for quick pattern recognition.
Ctrl + E
Open the Find dialog box.
Ctrl + F
Open the Go To dialog box.
Ctrl + G
Open the Replace dialog box.
Ctrl + H
Toggle Italic formatting.
Ctrl + I
[Hidden Shortcut] Insert a break line in the Find or Replace dialog box.
Mastering the Excel Control (Ctrl) key shortcuts is essential for increasing productivity.
With these shortcuts, you can easily navigate, format, and manipulate data in Excel, saving time and reducing the need for a mouse. Whether you’re a beginner or advanced user, these shortcuts will streamline your workflow and help you get more done in less time.
Top Excel Ctrl Key Shortcuts with Numbers
Note: These shortcuts only work with the standard number keys, not the numeric keypad.
Action
Shortcut
Open Cell Format dialog box
Ctrl + 1
Toggle Bold
Ctrl + 2
Toggle Italic
Ctrl + 3
Toggle Underline
Ctrl + 4
Toggle Strikethrough
Ctrl + 5
Show/Hide objects
Ctrl + 6
Show Outline (Group / Ungroup Rows / Columns)
Ctrl + 8
Hide Row
Ctrl + 9
Hide Column
Ctrl + 0
Excel Ctrl Key Shortcuts with Letters
Below is a comprehensive list of Excel shortcuts using the Ctrl key and letters.
Action
Key Combination
Select all cells around the active cell (non-empty) or the entire worksheet (if empty). In formulas, this opens the formula’s dialog box.
Ctrl + A
Toggle Bold formatting.
Ctrl + B
Copy selected cells or content.
Ctrl + C
Fill Down or duplicate a selected object (Chart, Shape, SmartArt, etc.).
Ctrl + D
Apply Flash Fill for quick pattern recognition.
Ctrl + E
Open the Find dialog box.
Ctrl + F
Open the Go To dialog box.
Ctrl + G
Open the Replace dialog box.
Ctrl + H
Toggle Italic formatting.
Ctrl + I
[Hidden Shortcut] Insert a break line in the Find or Replace dialog box.
{"mobile_concate":{"mobile-menu":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/mobile-menu.css"},"tf_base":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/css\/base.min.css","v":"8.6.4"},"themify_common":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/css\/themify-common.css","v":"8.6.4"},"builder-styles-css":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/themify-builder-style.css","v":"8.6.4"},"tb_tbp":{"s":"https:\/\/excel-tutorial.com\/wp-content\/plugins\/themify-builder-pro\/public\/css\/tbp-style.css","v":"3.9.3"},"tb_tbp-woo":{"s":"https:\/\/excel-tutorial.com\/wp-content\/plugins\/themify-builder-pro\/public\/css\/wc\/tbp-woocommerce.css","v":"3.9.3"},"tb_tbp-qty":{"s":"https:\/\/excel-tutorial.com\/wp-content\/plugins\/themify-builder-pro\/public\/css\/wc\/tbp-qty.css","v":"3.9.3"},"woocommerce-layout":{"s":"https:\/\/excel-tutorial.com\/wp-content\/plugins\/woocommerce\/assets\/css\/woocommerce-layout.css","v":"11.2.2"},"woocommerce-smallscreen":{"s":"https:\/\/excel-tutorial.com\/wp-content\/plugins\/woocommerce\/assets\/css\/woocommerce-smallscreen.css","v":"11.2.2","m":"only screen and (max-width: 768px)"},"woocommerce-general":{"s":"https:\/\/excel-tutorial.com\/wp-content\/plugins\/woocommerce\/assets\/css\/woocommerce.css","v":"11.2.2"},"wp-block-library":{"s":"https:\/\/excel-tutorial.com\/wp-includes\/css\/dist\/block-library\/style.min.css","v":"7.1.4"},"tf_theme_site-logo":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/styles\/modules\/site-logo.css","v":"7.7.6"},"tf_theme_site-description":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/styles\/modules\/site-description.css","v":"7.7.6"},"tf_search_form":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/css\/modules\/search-form.css","v":"8.6.4"},"tb_divider":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/divider.css","v":"8.6.4"},"tb_post-content":{"s":"https:\/\/excel-tutorial.com\/wp-content\/plugins\/themify-builder-pro\/public\/css\/modules\/post-content.css","v":"3.9.3"},"tb_image":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/image.css","v":"8.6.4"},"tb_image_left":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/image_styles\/left.css","v":"8.6.4"},"tb_comments":{"s":"https:\/\/excel-tutorial.com\/wp-content\/plugins\/themify-builder-pro\/public\/css\/modules\/comments.css","v":"3.9.3"},"tb_image_top":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/image_styles\/top.css","v":"8.6.4"},"tb_text":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/text.css","v":"8.6.4"},"theme-style":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/style.css","v":"7.7.6"},"themify-media-queries":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/media-queries.css","v":"7.7.6","m":"(max-width:1200px)"}}
