90+ Best Excel Shortcut Keys and Hotkeys with CTRL Key

90+ Best Excel Shortcut Keys and Hotkeys with CTRL Key

By

Microsoft Excel offers a couple of Excel Shortcut Keys with the help of a keyboard (also known as Keyboard Shortcuts) which handling its features and commands smartly to customize the Excel activity. CTRL key is one of the important hotkeys in Excel that combines with other keys to make a number of excel shortcut keys. Broadly, the hotkeys are well known as shortcut keys

 

What are the Excel shortcut Keys?

Excel shortcut keys or keyboard shortcut keys may be the key or combination of keys, after pressing/using them Excel allows users to access a particular feature, or perform a command quickly to customize the Excel activity. 

 

What are the uses of Excel shortcut Keys?

• Keyboard Excel shortcut(s) allows performing many commonly used commands.

For example, Ctrl+S is the keyboard shortcut for the Save command, which means users hold down the CTRL key, then press the S key to save the workbook. Otherwise, we should follow the following steps: File ⇨ Save.

Similarly, Excel shortcut Ctrl+N allows creating a New Workbook command. Otherwise, we should follow the following steps: File ⇨ New ⇨ Blank Workbook.

 

Keyboard Excel shortcut(s) allow moving quickly on the ribbon.

The first time pressing the ALT key displays the Key Tips, which are the labels that appear over each tab and command on the ribbon. Then, press the key or keys indicating to access the corresponding tab, command, or button simultaneously.

The main motto of using Excel shortcuts is to customize the Excel activity rapidly other than using a mouse input device.


Types of Excel Shortcut Keys with CTRL Key

There are six types of Excel shortcuts made with a combination of CTRL Key. 

 

Types I: Excel Shortcut Keys with ‘CTRL’ Key & ‘ALPHABET’ Keys

 

• Ctrl+A / Ctrl+Shift+* (asterisk): Select All

One-time press to select the entire range of active cells in a database, second-time press to select the entire worksheet.

In a blank worksheet, it selects the entire worksheet.

⇒ FAQs: What is a shortcut key for select all?  What is the ‘select all’ keyboard shortcut?

Ctrl+A-step1

 

Ctrl+A-step2

• Ctrl+B / Ctrl+2: Apply or remove the Bold formatting

Equivalent to Home ⇨ Font ⇨ B (Bold)

• Ctrl+C: Copy the selection

Equivalent to Home ⇨ Clipboard ⇨ Copy

 

• Ctrl+D: Fill Down

Both the Formula and the Value copy down from the above cell(s).

Equivalent to Home ⇨ Editing ⇨ Fill ⇨ Down

Ctrl+D

• Ctrl+E: Flash Fill

Equivalent to Home ⇨ Editing ⇨ Fill ⇨ Flash Fill

⇒ FAQs: What is the function of excel CTRL E? 

CTRL+E

• Ctrl+F / Shift+F5: Display the Find dialog box.

Equivalent to Home ⇨ Editing ⇨ Find & Select ⇨ Find

⇒ FAQs: What is the find shortcut key? 

CTRL+F

• Ctrl+G / F5: Display the Go To dialog box.

Equivalent to Home ⇨ Editing ⇨ Find & Select ⇨ Go To

⇒ FAQs: What does the function of CTRL G excel? 

CTRL+G

• Ctrl+H: Display the Find and Replace dialog box.

Equivalent to Home ⇨ Editing ⇨ Find & Select ⇨ Replace

⇒ FAQs: What is the replace shortcut key?   What is the function of CTRL H in excel?

CTRL+H(1)Step-1: Select the range and open the Find and Replace dialog box by using Ctrl+H

CTRL+H(2)

Step-2: Fills “-” in the “Find what” box and “*” in the “Replace with” box and press the ‘Replace All’ button.

• Ctrl+I / Ctrl+3: Apply or remove the Italic formatting.

Equivalent to Home ⇨ Font ⇨ I (Italic)

Ctrl+I or Ctrl+3

• Ctrl+K: Insert Hyperlink

Equivalent to Insert ⇨ Links ⇨ Hyperlink

⇒ FAQs: What is the hyperlink shortcut key? 

Ctrl+K

• Ctrl+L / Ctrl+T: Convert database into a Table.

Equivalent to Insert ⇨ Tables ⇨ Table

Note: Before applying the convert to Table shortcut, we should select the entire database by pressing Ctrl+A then apply Ctrl+L or Ctrl T. 

⇒ FAQs: What does the function of CTRL T excel?  What does the function of CTRL T in excel? 

Ctrl+T or Ctrl+L(1)
Step-1: Ctrl+T or Ctrl+L

Ctrl+T or Ctrl+L(2)Step-2: Ctrl+T or Ctrl+L



• Ctrl+Shift+L
/ Alt+D+F+F:
Apply or Remove the Filter controls in a table or range

Equivalent to Home ⇨ Editing ⇨ Sort & Filter ⇨ Filter

Note: It is always a good practice to apply the filter after selection the entire database – first select the heading by Shift+Spacebar ⇨ then extend the selection downward till the end of the database by Ctrl+Shift+↓

⇒ FAQs: What is the excel filter shortcut?  What does the function of CTRL SHIFT L excel? 

Ctrl+Shift+L or Alt+D+F+F

• Ctrl+N: Create a New Workbook

Equivalent to File ⇨ New ⇨ Blank Workbook

⇒ FAQs: What is the new tab shortcut?  What does the function of CTRL N in excel? 

CTRL+N

 

• Ctrl+O / Ctrl+F12: Open the Save Workbook

Equivalent to File ⇨ Open

CTRL+O

• Ctrl+P / Ctrl+F2 / Ctrl+Shift+F12: Print Preview 

Equivalent to File ⇨ Print

⇒ FAQs: What is a print shortcut key?  What is a print preview shortcut key? 

Ctrl+F2 or Ctrl+P or Ctrl+Shift+F12

• Ctrl+R: Fill to the Right

Equivalent to Home ⇨ Editing ⇨ Fill ⇨ Fill Right

⇒ FAQs: What does the function of CTRL R in excel?

CTRL+R

• Ctrl+S / Alt+Shift+F2: Save the active workbook

Equivalent to File ⇨ Save

Note: While we work with a database, we shouldn’t wait till the completion of the database. It is always a good practice to save the database/workbook frequently so that, in the event of sudden power off or accidentally system crash, we will only lose a small portion of data and get all the last saved data.

⇒ FAQs: What does the function of CTRL S excel?  

 

• Ctrl+U / Ctrl+4: Apply or remove an Underline

Equivalent to Home ⇨ Font ⇨ U (Underline)

Ctrl+U or Ctrl+4

 

• Ctrl+V: Paste the selection

Equivalent to Home ⇨ Clipboard ⇨ Paste

⇒ FAQs: What is the shortcut key for paste? 

CTRL+C AND CTRL+V

Ctrl+C (Copy) ⇨ Ctrl+V (Paste)

CTRL+X AND CTRL+V

Ctrl+X (Cut) ⇨ Ctrl+V (Paste)

 

• Ctrl+W / Ctrl+F4: Close only the current workbook

Note: If there are a number of workbooks open for working purposes, it is always good practice to close them one by one with Ctrl+W. The benefit is that the user can choose the option which files want to save or not. 

If we go with the Alt+F4, it allows closing all the workbooks at a time. If the files are saved, close them at a time. Otherwise, for unsaved workbooks, by default open Save As option in each case. 

⇒ FAQs: What is the shortcut key to close window? 

 

• Ctrl+X: Cut the selection

Equivalent to Home ⇨ Clipboard ⇨ Cut

 

• Ctrl+Y: Redo the last undo

Note: only activate after undo an action.

⇒ FAQs: What is the redo keyboard shortcut?    What is the redo shortcut in excel?   What does the function of CTRL Y excel?  

 

• Ctrl+Z / Alt+Backspace: Undo the last command or action

Note: both undo and redo allow Excel users to choose from among the last 16 actions.

⇒ FAQs: What is the undo keyboard shortcut?  What is the undo shortcut in Excel?  What does the function of CTRL Z excel? 

 


Types II: Excel Shortcut Keys with ‘CTRL’ Key & ‘NUMERIC’ Keys

 

• Ctrl+1: Displays the Format Cells dialog box for the selected cell or range

Equivalent to Home ⇨ Number ⇨ Number Format settings

Equivalent to Home ⇨ Alignment ⇨ Alignment settings

⇒ FAQs: What does the function of  CTRL 1 excel? 

Ctrl+1

 

• Ctrl+2 / Ctrl+B: Apply or remove the Bold formatting

Equivalent to Home ⇨ Font ⇨ B (Bold)

 

• Ctrl+3 / Ctrl+I: Apply or remove the Italic formatting

Equivalent to Home ⇨ Font ⇨ I (Italic)

 

• Ctrl+4 / Ctrl+U: Apply or remove an Underline

Equivalent to Home ⇨ Font ⇨ U (Underline)

 

• Ctrl+5: Apply or remove strikethrough

Equivalent to Home ⇨ Font ⇨ Font Settings ⇨  Strikethrough

⇒ FAQs: What is an Excel strikethrough shortcut? 

Ctrl+5

 

• Ctrl+6: Cycles among various ways of displaying objects on a worksheet

⇒ FAQs: What does the function of CTRL 6 excel?  

 

• Ctrl+9: Hide Rows

Note: Selects the entire row(s) want to hide by Shift+Spacebar then apply Ctrl+9

⇒ FAQs: What does the function of CTRL 9 excel?  

Ctrl+9

 

• Ctrl+0: Hide Columns

Note: Selects the entire column(s) want to hide by Ctrl+Spacebar then apply Ctrl+0

⇒ FAQsWhat is an Excel hiding shortcut? 

Ctrl+0

Types III: Excel Shortcut Keys with ‘CTRL’ Key & ‘PUNCTUATION’ Keys

 

• Ctrl+; (semicolon): Insert the Current Date

⇒ FAQs: What is a date shortcut in excel? 

 

• Ctrl+Shift+; (semicolon) / Ctrl+: (colon): Insert the Current Time

Ctrl+Semicolon and Ctrl+Colon

 

• Ctrl+’ (single quotation mark): Copy formula from Cell Above

 

• Ctrl+Shift+’ / Ctrl+” (double quotation mark): Copy Value from Cell Above

Ctrl+'(Single quotation) and Ctrl+" (Double quotation)

 

• Ctrl+ + (plus): Insert columns/rows whatever selected

Equivalent to Home ⇨ Cells ⇨ Insert ⇨ Insert Sheet Columns

Equivalent to Home ⇨ Cells ⇨ Insert ⇨ Insert Sheet Rows

Note: (i) when we try to insert column(s), it is good practice to select the particular column(s) by Ctrl+Spacebar before which we want to insert the new column(s), then press Ctrl++

(ii) Similarly, when we try to insert row(s), it is good practice to select the particular row(s) by Shift+Spacebar before which we want to insert the new row(s), then press Ctrl++.   

⇒ FAQsWhat is the insert row shortcut?   What does the insert column excel shortcut?  What is the shortcut to add row in excel? 

 

Insert columns by Ctrl++

Figure:
Insert column(s) by Ctrl+ +

Insert rows by Ctrl++

Figure:
Insert row(s) by Ctrl+ +

 

• Ctrl+ – (minus): Delete column(s) / row(s) whatever selected

Equivalent to Home ⇨ Cells ⇨ Delete ⇨ Delete Sheet Columns

Equivalent to Home ⇨ Cells ⇨ Delete ⇨ Delete Sheet Rows

⇒ FAQsWhat is an excel delete row shortcut? 

Delete columns by Ctrl+-

Figure: Delete column(s) by Ctrl+

 

Delete rows by Ctrl+ -

Figure  Delete row(s) by Ctrl+

 


Types IV: Excel Shortcut Keys with ‘CTRL’ Key & ‘FUNCTION’ Keys

 

• Ctrl+Esc (Escape): Show the Windows Start Menu

Ctrl+Esc

 

  • Ctrl+F1: Toggles the display of the ribbon for more space

⇒ FAQs: What is the function of CTRL F1?

Ctrl+F1

Hide and Unhide the ribbon

 

  • Ctrl+Shift+F1: Toggles auto-hiding the ribbon

Ctrl+Shift+F1

 

• Ctrl+F2 / Ctrl+P: Print Preview

Equivalent to File ⇨ Print

⇒ FAQs: What does the function of CTRL F2 excel?

 

• Ctrl+F3: Define the Name of a selected range or a table.

Equivalent to Formulas ⇨ Defined Names ⇨ Name Manager

⇒ FAQsWhat does the function of CTRL F3 excel? 

Ctrl+F3

• Ctrl+Shift+F3: Create Names from Selection

Equivalent to Formulas ⇨ Defined Names ⇨ Create from Selection

Ctrl+Shift+F3

• Ctrl+F4: Close all the active/open workbooks

Equivalent to File ⇨ Close

⇒ FAQs: What does the function of CTRL F4 excel? 

Ctrl+F4

• Ctrl+F5: Restore the individual active/open workbook window size

Ctrl+F5

 

• Ctrl+F6: Switch to the next workbook

⇒ FAQs: What does the function of CTRL F6 excel? 

Ctrl+F6

• Ctrl+Shift+F6: Switch to the previous workbook

 

Ctrl+Shift+F6

 

• Ctrl+F9: Minimize the individual open workbook to an icon

Note: Please remember that Windows+D minimizes all the active windows. 

⇒ FAQs: What is a minimize shortcut key?   What does the function of CTRL F9 excel? 

 

• Ctrl+F10: Maximize or restore the workbook window

 

• Ctrl+F11: Inset an Excel 4.0 Macro sheet

 

• Ctrl+F12 / Ctrl+O: Open the Save Workbook.

Equivalent to the File ⇨ Open

 

• Ctrl+Shift+F12 / Ctrl+P / Ctrl+F2: Print Preview

Equivalent to the File ⇨ Print


Types V: Excel Shortcut Keys with ‘CTRL’ Key & ‘NAVIGATION’ Keys

 

• Ctrl+ → (Right Navigation Arrow):

1. Move right to the edge of a database 

2. If there is a blank cell, move right to the first non-blank cell

 

• Ctrl+ ↓ (Down Navigation Arrow):

1. Move down to the edge of a database 

2. If there is a blank cell, move down to the first non-blank cell

 

• Ctrl+ ← (Left Navigation Arrow):

1. Move left to the edge of a database 

2. If there is a blank cell, move left to the first non-blank cell

 

• Ctrl+ ↑ (Up Navigation Arrow):

1. Move up to the edge of a database 

2. If there is a blank cell, move up to the first non-blank cell

CTRL+NAVIGATION ARROW

 

• Ctrl+ Page DownMove to the next worksheet

 

• Ctrl+ Page UpMove to the previous worksheet

CTRL+PAGE UP, CTRL+PAGE DOWN

 

• Ctrl+ Shift+Page Down: Select the current and the next worksheet in a workbook

CTRL+SHIFT+PAGE DOWN

 

• Ctrl+ Shift+Page Up: Select the current and the previous worksheet in a workbook

CTRL+SHIFT+PAGE UP

 

• Shift+Page Down: Extend the selection down one screen (Vertically move)

• Shift+Page Up: Extend the selection up one screen (Vertically move)

SHIFT+PAGE DOWN, SHIFT+PAGE UP

• Ctrl+Home: Move to the first cell (A1) from any cell in the worksheet 

CTRL+HOME

 

• Ctrl+End: Move to the last non-empty cell of the worksheet (defined as the intersection of the last used column and last used row in an active worksheet)

 


Types VI: Excel Shortcut Keys with ‘CTRL’ Key, ‘SHIFT’ Key & ‘SYMBOL’ Keys

 

• Ctrl+Shift+~: Apply the General Number Format

Excel Shortcut Ctrl+Shift+~

• Ctrl+Shift+!: Apply the Comma Format with two decimal places

Excel Shortcut Ctrl+Shift+!

• Ctrl+Shift+#: Apply the Date Format (DD-MMM-YY)

Excel Shortcut Ctrl+Shift+#

[email protected]: Apply the Time Format (hour, minute, a.m./p.m.)

Excel Shortcut Ctrl+Shift+@

• Ctrl+Shift+$: Apply the Currency format with two decimal places

Excel Shortcut Ctrl+Shift+$

• Ctrl+Shift+%: Apply the Percent Format with no decimal places

Excel Shortcut Ctrl+Shift+%

• Ctrl+Shift+&: Apply Outside Borders to a range selection

Excel Shortcut Ctrl+Shift+&

• Ctrl+Shift+_ (underscore): Remove all Borders for the range selection

Excel Shortcut Ctrl+Shift+_

Read More Tag (Purple)• 80+ Excel Shortcuts with ALT Key|| Best Hotkey of Keyboard Shortcuts


Sudipta Mondal
Follow AEF
Advance Excel Forum

90+ Best Excel Shortcut Keys and Hotkeys with CTRL Key

Editor's Rating:
5

Leave a Comment

You may also like