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. The CTRL key is one of the important hotkeys in Excel that combines with other keys to make more than 90 Excel Ctrl Shortcuts. Broadly, the hotkeys are well known as shortcut keys.
In this tutorial, we suggest every Excel user make the Ctrl shortcuts handy after repeated practices. These excel shortcuts evenly used in any Windows version including Windows 10.
I. WHAT ARE THE EXCEL SHORTCUT KEYS / KEYBOARD SHORTCUTS?
Excel shortcut keys or keyboard shortcuts may be the key or combination of keys, after using them Excel allows users to access a particular feature, or perform a command quickly to customize the Excel activity. Every Excel user should know about Excel Ctrl Shortcut keys, Excel Alt Shortcut keys.
TABLE OF CONTENTS:
ToggleII. WHAT ARE THE BENEFITS OF EXCEL CTRL SHORTCUTS?
➢ Ctrl keyboard shortcuts allow us to perform many commonly used commands very easily.
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.
➢ Ctrl shortcut keys quickly perform to manage a range of cells in a worksheet or between worksheets.
For example, we can easily cut (Ctrl+X), copy (Ctrl+C), paste (Ctrl+V) of a range of cells. We can insert a row or column (Ctrl++) or delete (Ctrl+-) easily.
Similarly, we can move one worksheet (tab) to another worksheet (tab) by using Excel Ctrl shortcuts Ctrl+Page Down (move to the right side) and Ctrl+Page Up (Move to the left side).
The main motto of using Excel Ctrl shortcuts is to customize the Excel activity rapidly other than using a mouse input device.
III. MAJOR TYPES OF EXCEL CTRL SHORTCUTS / CTRL KEYBOARD SHORTCUTS
There are six types of Excel CTRL shortcuts as follows:
(A) TYPE 1: EXCEL CTRL SHORTCUTS WITH ALPHABET KEYS
• Ctrl+A / Ctrl+Shift+* (Asterisk) ➪ Select All
One-time press to select the entire range of active cells in a dataset, 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlA-1.png)
• Ctrl+B / Ctrl+2 ➪ Apply or remove the Bold formatting
Equivalent to Home ⇨ Font ⇨ B (Bold)
![CtrlB or Ctrl2](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlB-or-Ctrl2.png)
• 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlD.png)
• Ctrl+E ➪ Flash Fill
Equivalent to Home ⇨ Editing ⇨ Fill ⇨ Flash Fill
⇒ FAQs: What is the function of excel CTRL E?
![CTRL+E](https://advanceexcelforum.com/wp-content/uploads/2019/08/CTRLE.png)
• 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/CTRLF.png)
• 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/CTRLG.png)
• 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?
Step-1: Select the range and open the Find and Replace dialog box by using Ctrl+H
Step-2: Type hyphen “–” in the “Find what” box and place an asterisk “*” in the “Replace with” box and press the ‘Replace All‘ button.
■ Note: We had detail explained on the Find and Replace in a separate tutorial. Request you read this tutorial: 07 Points Guided You How to Find And Replace in Excel?
• Ctrl+I / Ctrl+3 ➪ Apply or remove the Italic formatting.
Equivalent to Home ⇨ Font ⇨ I (Italic)
![Ctrl+I or Ctrl+3](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlI-or-Ctrl3.png)
• Ctrl+K ➪ Insert Hyperlink
Equivalent to Insert ⇨ Links ⇨ Hyperlink
⇒ FAQs: What is the hyperlink shortcut key?
![Ctrl+K](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlK.png)
• 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 dataset 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+Shift+L / Alt+D+F+F (Sequentially press 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 selecting the entire dataset: first select the heading by Shift+Spacebar ⇨ then extend the selection downward till the end of the dataset 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlShiftL-or-AltDFF.png)
• 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/CTRLN.png)
• Ctrl+O / Ctrl+F12 ➪ Open the Save Workbook
Equivalent to File ⇨ Open
![CTRL+O](https://advanceexcelforum.com/wp-content/uploads/2019/08/CTRLO.png)
• 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlF2-or-CtrlP.png)
• 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/CTRLR.png)
• 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlU-or-Ctrl4.png)
• Ctrl+V ➪ Paste the selection
Equivalent to Home ⇨ Clipboard ⇨ Paste
⇒ FAQs: What is the shortcut key for paste?
Example 1: Ctrl+C (Copy) ⇨ Ctrl+V (Paste)
![CTRL+C AND CTRL+V](https://advanceexcelforum.com/wp-content/uploads/2019/08/CTRLC-AND-CTRLV.png)
Example 2: Ctrl+X (Cut) ⇨ Ctrl+V (Paste)
• Ctrl+W ➪ Close only the current workbook
Equivalent to File ⇨ Close
• Ctrl+F4 ➪ Close all the workbooks
Note: If there are a number of workbooks open for working purposes, it is always good practice to close them one by one by pressing 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 us to close all the workbooks at a time. If the files are saved, close them at a time. Otherwise, for unsaved workbooks, by default open the Save As option in each case.
⇒ FAQs: What is the shortcut key to close a window?
• Ctrl+X ➪ Cut the selection
Equivalent to Home ⇨ Clipboard ⇨ Cut
• Ctrl+Y ➪ Redo the last undo
Note: Only activate after undoing 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?
(B) TYPE 2: EXCEL CTRL SHORTCUTS WITH 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/Ctrl1.png)
• 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/Ctrl5.png)
• 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/Ctrl9.png)
• Ctrl+0 ➪ Hide Columns
Note: Selects the entire column(s) want to hide by Ctrl+Spacebar ➪ then apply Ctrl+).
⇒ FAQs: What is an Excel hiding shortcut?
![Ctrl+0](https://advanceexcelforum.com/wp-content/uploads/2019/08/Ctrl0.png)
(C) TYPE 3: EXCEL CTRL SHORTCUTS WITH 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlSemicolon-and-CtrlColon.png)
• Ctrl + ‘ (Single Quotation Mark) ➪ Copy the formula from Cell Above
• Ctrl + ” (Double Quotation Mark) ➪ Copy Value from Cell Above
![Ctrl+'(Single quotation) and Ctrl+](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlSingle-quotation-and-Ctrl-Double-quotation.png)
• 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 + +.
⇒ FAQs: What is the insert row shortcut? What does the insert column excel shortcut? What is the shortcut to add rows in excel?
Example 1: Insert column(s) using by Ctrl+ +
![Insert columns by Ctrl++](https://advanceexcelforum.com/wp-content/uploads/2019/08/Insert-columns-by-Ctrl.png)
Example 2: Insert Row(s) using by Ctrl+ +
![Insert rows by Ctrl++](https://advanceexcelforum.com/wp-content/uploads/2019/08/Insert-rows-by-Ctrl.png)
• 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
⇒ FAQs: What is an excel delete row shortcut?
Example 1: Delete Column(s) using by Ctrl+ –
Example 2: Delete Row(s) using by Ctrl+ –
(D) TYPE 4: EXCEL CTRL SHORTCUTS WITH FUNCTION KEYS
• Ctrl + Esc (Escape) ➪ Show the Windows Start Menu
![Ctrl+Esc](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlEsc.png)
• Ctrl + F1 ➪ Toggles the display of the ribbon for more space
⇒ FAQs: What is the function of CTRL F1?
![Ctrl+Shift+F1](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlShiftF1.png)
• 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
⇒ FAQs: What does the function of CTRL F3 excel?
![Ctrl+F3](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlF3.png)
• Ctrl + Shift + F3 ➪ Create Names from Selection
Equivalent to Formulas ⇨ Defined Names ⇨ Create from Selection
![Ctrl+Shift+F3](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlShiftF3.png)
• Ctrl + F4 ➪ Close all the active/open workbooks
Equivalent to File ⇨ Close
⇒ FAQs: What does the function of CTRL F4 excel?
![Ctrl+F4](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlF4.png)
• Ctrl + F5 ➪ Restore the individual active/open workbook window size
![Ctrl+F5](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlF5.png)
• Ctrl + F6 ➪ Switch to the next workbook
⇒ FAQs: What does the function of CTRL F6 excel?
![Ctrl+F6](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlF6-1024x326.png)
• Ctrl + Shift + F6 ➪ Switch to the previous workbook
![Ctrl+Shift+F6](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlShiftF6-1024x378.png)
• 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
(E) TYPE 5: EXCEL CTRL SHORTCUTS WITH 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/CTRLNAVIGATION-ARROW.png)
• Ctrl + Page Down ➪ Move to the next worksheet
• Ctrl + Page Up ➪ Move to the previous worksheet
![CTRL+PAGE UP, CTRL+PAGE DOWN](https://advanceexcelforum.com/wp-content/uploads/2019/08/CTRLPAGE-UP-CTRLPAGE-DOWN-.png)
• Ctrl + Shift + Page Down ➪ Select the current and the next worksheet in a workbook
![CTRL+SHIFT+PAGE DOWN](https://advanceexcelforum.com/wp-content/uploads/2019/08/CTRLSHIFTPAGE-DOWN.png)
• Ctrl + Shift + Page Up ➪ Select the current and the previous worksheet in a workbook
![CTRL+SHIFT+PAGE UP](https://advanceexcelforum.com/wp-content/uploads/2019/08/CTRLSHIFTPAGE-UP.png)
• 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](https://advanceexcelforum.com/wp-content/uploads/2019/08/SHIFTPAGE-DOWN-SHIFTPAGE-UP.png)
• Ctrl + Home ➪ Move to the first cell (A1) from any cell in the worksheet
![CTRL+HOME](https://advanceexcelforum.com/wp-content/uploads/2019/08/CTRLHOME.png)
• 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)
(F) TYPE 6: EXCEL CTRL SHORTCUTS WITH SHIFT KEY & SYMBOL KEYS
• Ctrl + Shift + ~ (Tilde) ➪ Apply the General Number Format
![Excel Shortcut Ctrl+Shift+~](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlShift-5.png)
• Ctrl + Shift + ! ➪ Apply the Comma Format with two decimal places
Equivalent to Home ⇨ Number ⇨ , (Comma Style) icon
![Excel Shortcut Ctrl+Shift+!](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlShift.png)
• Ctrl + Shift + # ➪ Apply the Date Format (DD-MMM-YY)
![Excel Shortcut Ctrl+Shift+#](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlShift-1.png)
• Ctrl + Shift + @ ➪ Apply the Time Format (hour, minute, a.m./p.m.)
![Excel Shortcut Ctrl+Shift+@](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlShift@.png)
• Ctrl + Shift + $ ➪ Apply the Currency format with two decimal places
Equivalent to Home ⇨ Number ⇨ $ (Accounting Number Format) icon
![Excel Shortcut Ctrl+Shift+$](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlShift-2.png)
• Ctrl + Shift + % ➪ Apply the Percent Format with no decimal places
Equivalent to Home ⇨ Number ⇨ % (Percent Style) icon
![Excel Shortcut Ctrl+Shift+%](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlShift-3.png)
• Ctrl + Shift + & (Ampersand) ➪ Apply Outside Borders to a range selection
Equivalent to Home ⇨ Borders drop-down under ‘Font’ group ⇨ Outside Borders
![Excel Shortcut Ctrl+Shift+&](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlShift-4.png)
• Ctrl + Shift + _ (Underscore) ➪ Remove all Borders for the range selection
Equivalent to Home ⇨ Borders drop-down under ‘Font’ group ⇨ No Border
![Excel Shortcut Ctrl+Shift+_](https://advanceexcelforum.com/wp-content/uploads/2019/08/CtrlShift_.png)
![AEF_192by192](https://advanceexcelforum.com/wp-content/uploads/2020/10/AEF_192by192.png)
Premium Courses on ed2go
Premium Courses on FutureLearn Limited
Premium Courses on Coursera
Premium Courses on Udemy
![Read-More-5](https://advanceexcelforum.com/wp-content/uploads/2019/08/Read-More-5.png)
30+ BEST ADVANCE EXCEL COURSES | By Coursera, Udemy |
36+ BEST ADVANCED EXCEL COURSE ONLINE | By ed2go |
10 Examples of Text to Columns || How to Split Cells/Columns in Excel
04 Best Ways: How to Transpose Data in Excel
How to use VLOOKUP Function in Excel || Must know Do OR Dont’s ||
03 Best Ways: Excel REVERSE VLOOKUP | VLOOKUP to the left |
03 Best Ways: EXCEL DOUBLE VLOOKUP/ IFERROR VLOOKUP/ NESTED VLOOKUP
04 Simple to Advanced Methods: How to Filter in Excel?
Thanks for your interest joining to Advance Excel Forum community.
Something went wrong.
![](http://advanceexcelforum.com/wp-content/uploads/2020/09/Advance-Excel-Forum_140-by-101.png)
Join Our Community List
Subscribe to our mailing list and get interesting stuff and updates to your email inbox.
* VERIFY & CONFIRM YOUR EMAIL * We respect your privacy and take protecting it seriously*.