200+ Excel Keyboard shortcuts

Gyansetu Team Business/Data Analytics

Do you find yourself spending too much time clicking through Excel’s menus and ribbons? Well, there’s a faster way to navigate through excel keyboard shortcuts Excel has over 200 keyboard shortcuts that can help you streamline your work and increase your productivity.

With these Excel Keyboard shortcuts, you can quickly perform basic navigation tasks, as well as complex calculations and data analysis. So, if you’re looking to boost your Excel skills and speed up your work, it’s time to learn some Excel keyboard shortcuts. 

Workbook Related Shortcuts

Function Windows Shortcut Mac Shortcut
Create a new blank Workbook Ctrl + N ⌘ + N
Opens the Print Preview Window Ctrl + F2 ⌘ + P
Saves the Workbook with its current file name, location, and file type Ctrl + S ⌘ + S
Displays the Open Dialog box to Open/Find a file Ctrl + O ⌘ + O
Opens the Save As dialog box F12 ⌘ + ⇧ + S
Maximize or Restore Selected Workbook Window Ctrl + F10
Switch to the Previous Workbook Ctrl + Shift + Tab
Switch to the Next Workbook Ctrl + Tab
Minimize Workbook Ctrl + F9

 

Excel Cell Editing Shortcut

 

Function Shortcut
Select one Word on the Left of the Cursor Ctrl Shift ←
Delete One Character on the Left of the Cursor Backspace
Select one Word on the Right of the Cursor Ctrl Shift →
Select One Character on the Left of the Cursor SHIFT ←
Delete One Character on the Right of the Cursor Delete
Jump one Word on the Right of the Cursor Ctrl →
Edit Active Cell F2
Delete to the End of the line (from the cursor) Ctrl + Delete
Select One Character on the Right of the Cursor SHIFT →
Start a New Line in the Same Cell ALT + ENTER
Cancel Entry Esc

 

Hide/Unhide (Rows, Columns, Objects) Shortcuts

Function Windows Shortcut
Hide Selected Rows Ctrl + 9
Hide Selected Columns Ctrl + 0
Unhide Hidden Rows in Selection Ctrl + Shift + 9
Unhide Hidden Columns in Selection Ctrl + Shift + 0
Show/Hide Objects Ctrl + 6

 

Navigation Shortcuts in Excel

Function Shortcut
Go to the First Cell in the Current Region Ctrl + Home
Move One Screen to the Right Alt + PageDown
Move to the Bottom-right used Cell in the Worksheet Ctrl + End
Move to the Right Edge of the Data Region Ctrl →
Down One Screen PageDown
Move One Cell to the Left
Move to the Bottom edge of the data region Ctrl ↓
Move to the Previous Worksheet Ctrl + PageUp
Move One Cell Up
Move to Next Worksheet Ctrl + PageDown
Move to the Beginning of the Row Home
Move One Cell Down
Up One Screen PageUp
Move One Screen to the Left Alt + PageUp
Move One Cell to the Right
Move to the Top Edge of Data Region Ctrl ↑

 

General Excel Keyboard Shortcuts

Function Shortcut
Display the Print Menu Ctrl + P
Turn On End Mode End
Activate Filter (when the cell with filter is selected) Alt + ↓
Spell Check F7
Calculate Active Worksheet Shift + F9
Display Go To Dialog Box Ctrl + G
Undo Ctrl + Z
Repeats the Last Action F4
Apply Data Filter Ctrl + Shift + L
Display Go To Dialog Box F5
Opens Help F1
Recalculate All Workbooks F9
Repeats the last command or action Ctrl + Y

 

Cut, Copy, and Paste Shortcuts in Excel

Function Shortcut
Copy Selected Cells Ctrl + C
Display Paste Special Dialog Box Ctrl + Alt + V
Paste Content from the Clipboard Ctrl + V
Copy Formula from the Cell Above Ctrl + ‘
Copy Value from the Cell Above Ctrl + SHIFT + ‘
Cut Selected Cells Ctrl + X

 

Extending the Selection Shortcuts

Function Windows Shortcut
Extend Selection to the Right by One Cell Shift + →
Extend Selection to the Left by One Cell Shift + ←
Extend Selection Upwards by One Cell Shift + ↑
Extend Selection Downwards by One Cell Shift + ↓
Extend the Selection to the Right till the Last Cell Ctrl + Shift + →
Extend the Selection to the Left till the Last Cell Ctrl + Shift + ←
Extend the Selection Upwards to the Last Cell Ctrl + Shift + ↑
Extend Selection Upwards by One Screen Shift + PageUp
Extend Selection Downwards by One Screen Shift + PageDown
Extend Selection to the Right by One Screen ALT + Shift + PageUp
Extend Selection to the Left by One Screen ALT + Shift + PageDown
Extend Selection to the Start of the Row Shift + Home
Extend Selection to First Cell in the Worksheet Ctrl + Shift + Home
Extend Selection to the Last Cell in the Worksheet Ctrl + Shift + End
Toggle Extend Selection Mode F8

 

Data Entry Shortcuts in Excel

Function Shortcut
Fill Down Ctrl + D
Insert Current Date Ctrl + ;
Enter and Move Left Shift + Tab
Display AutoComplete list Alt + ↓
Fill Right Ctrl + R
Cancel Cell Entry ESC
Enter and Move Down Enter
Enter and Remain on the Same Cell Control + Enter
Enter and Move right Tab
Enter and Move Up Shift + Enter
Start a New Line in the Same Cell Alt + Enter
Enter Same Data in All Selected Cells Control + Enter
Insert Current Time Ctrl + Shift + ;

 

Clear Shortcuts in Excel

Function Windows Shortcut
Clear Everything Alt + H + E + A
Clear Formats Only Alt + H + E + F
Clear Content Only Alt + H + E + C
Clear Hyperlinks Only Alt + H + E + L
Clear Comments Only Alt + H + E + M

 

Conditional Formatting Shortcuts

Function Windows Shortcut
Open Conditional Formatting Dialog Box Alt O D
Clear Conditional from Selected Cells Alt H L C S
Clear Conditional from the Entire Worksheet Alt H L C E

 

Selection Shortcuts in Excel

Function Windows Shortcut
Select All Cells that Contain Comments Ctrl + Shift + O
Select Row Differences Ctrl +
Select Current Region Around the Active Cell Ctrl + Shift + *
Select Direct Precedents Ctrl + [
Select Direct Dependents Ctrl + ]
Select Visible Cells in the Current Region Alt + ;
Select Entire Row Shift + Space
Select Entire Column Ctrl + Space
Select the Current Region / Select All Ctrl + A
Select all Dependents Ctrl + Shift + }
Select all Precedents Ctrl + Shift + {
Select Column Differences Ctrl + Shift + |

Alignment Shortcuts

Function Windows Shortcut
Align Content to the Left of the Cell Alt + H + A + L
Align Content to the Right of the Cell Alt + H + A + R
Align Content to the Center of the Cell Alt + H + A + C
Align Content to the Middle of the Cell Alt + H + A + M

Insert Shortcuts

Function Windows Shortcut
Insert New Line in the Same Cell Alt + Enter
Insert New Worksheet Shift + F11
Insert Row/Cell (shows a dialog box) Ctrl + Shift + =
Insert Current Date Ctrl + ;
Insert Current Time Ctrl + Shift + ;
Insert Table Ctrl + T
Insert Hyperlink Ctrl + K
Insert Argument Names into Formula Ctrl + Shift + A
Insert/Edit Cell Comment Shift + F2
Delete Row/Cell (shows the dialog box) Ctrl –

 

Formatting Shortcuts in Excel

 

Function Windows Shortcut
Remove Indent Alt H 5
Displays the Format Style Dialog Box Alt + ‘
Apply the Percentage Format with No Decimal Places Ctrl + Shift + %
Displays the Font Dialog Box Shift + Ctrl + F
Apply the Date format with the Day, Month, and Year Ctrl + Shift + #
Apply the General Number Format Ctrl + Shift + ~
Apply the Number format with Two Decimal Places, Thousands Separator, and a Minus Sign for Negative Values Ctrl + Shift + !
Apply Strikethrough Format Ctrl + 5
Underline Text Ctrl + U
Insert New Worksheet Shift + F11
Apply the Currency Format with Two Decimal Places Ctrl + Shift + $
Place outline Border around the Selected Cells Ctrl + Shift + 7
Make Text Bold Ctrl + B
Make Text Italics Ctrl + I
Remove Outline Border Ctrl + Shift + _
Increase Font Size by One Step Alt H F G
Insert/Edit Cell Comment Shift + F2
Apply Indent Alt H 6
Decrease Font Size by One Step Alt H F K
Insert Current Time Ctrl + Shift + ;
Insert Table Ctrl + T
Insert New Line in the Same Cell Alt + Enter
Insert Current Date Ctrl + ;
Insert Hyperlink Ctrl + K
Delete Row/Cell (shows the dialog box) Ctrl –
Insert Row/Cell (shows a dialog box) Ctrl + Shift + =

Named Ranges Shortcuts

Function Windows Shortcut
Get a List of All Defined Named Ranges F3
Create Named Range from Selection Ctrl + Shift + F3
Define Name Dialog Box Ctrl + F3

 

Excel Formula-Related Shortcuts

Function Shortcut
Insert Autosum Formula Alt + =
Toggle Value/Formula display Ctrl + `
Display the Insert Function Dialog Box Shift + F3
Evaluate Part of the Formula F9
Expand/Collapse Formula Bar Ctrl + Shift + U
Select All Cells Directly or Indirectly Referenced by Formulas Ctrl + [
Select Cells that Contain Formulas that Directly or Indirectly Ref… Ctrl + ]
Enter a Formula as an Array Formula Ctrl + Shift + Enter
While Typing a Formula, Switches Cell Reference from Absolute to R… F4
Rechecks dependent formulas and then calculates all cells in all t… Ctrl + Alt + Shift + F9
Select the Array Containing the Active Cell Ctrl + /

 

Find and Replace Shortcuts

Function Windows Shortcut
Display Find and Replace Dialog Box (Find Selected) Ctrl + F
Display Find and Replace Dialog Box (Replace Selected) Ctrl + H
Find Next Match Shift + F4
Find the Previous Match Ctrl + Shift + F4

Drag (Mouse) Shortcuts

Function Windows Shortcut
Drag and Copy the selected cells Ctrl + Drag
Drag and Cut the selected cells Drag
Duplicate Worksheet Ctrl + Drag
Switch Position of Cells/Rows/Columns Shift + Drag

Pivot Table Shortcuts

Function Shortcut
Select Entire Pivot Table (excluding Report Filters) Ctrl + A
Open Pivot Table Wizard Alt + D + P
Display Insert Pivot Table Dialog Box Alt + N + V
Select the Next Item in PivotTable Field List or Items List
Select a Previous Item in PivotTable Field List or Items List
Select Last Visible Item in List End
Select First Visible Item in List Home
Open Field List for Active Cell Alt + ↓
Add/Remove Checkmark for Selected Field in PivotTable Field List Space
Hide Selected Item or Field Ctrl + –
Group Selected Pivot Table Items Alt + Shift + →
UnGroup Pivot Table Items Alt + Shift + ←
Opens Calculated Field dialog box (when the data field is selected) Shift + Ctrl + =
Opens Calculated Item Dialog box (when field heading cell is Selected) Shift + Ctrl + =

Charting Shortcuts

Function Windows Shortcut
Inserts Chart in the Worksheet (using the selected data) Alt + F1
Inserts a ChartSheet with a Chart (using the selected data) F11

 

VBA Shortcuts

Function Windows Shortcut
Opes the VBA Editor and also switches between Excel Worksheet and the VBA editor Alt + F11
Open VB Help F1
View Object Browser F2
View Properties F4
View Code window F7
View Immediate window Ctrl + G
View Shortcut Menu Shift + F10
Run a Sub/UserForm F5
Step Into the code F8
Step Over Shift + F8
Step Out Ctrl + Shift + F8
Run to Cursor Ctrl + F8
Toggle Breakpoint F9
Clear All Breakpoints Ctrl + F9
Close VBA Editor and Return to the Excel Worksheet Alt + Q

 

Others Shortcuts

Function Windows Shortcut
Move Window Ctrl + F7
Resize Window Ctrl + F8
Restore Window Size Ctrl + F5
Next Pane F6
Previous Pane F8
Display Shortcut Menu Shift + F6
Next Window Ctrl + F6
Extend Mode Shift + F10
Turns On the Add to Selection Mode Shift + F8

CONCLUSION

So, Excel keyboard shortcuts can be a game-changer for anyone who uses Excel on a regular basis. With over 200 excel keyboard shortcuts available, you can quickly navigate through menus and ribbons, perform calculations, and analyse data with ease.

By mastering these excel keyboard shortcuts, you can save yourself a lot of time and increase your productivity in Excel. So, if you’re looking to improve your Excel skills, take the time to learn some of these excel keyboard shortcuts. You’ll be surprised at how much faster and more efficient you can be in Excel!yes 

Gyansetu Team

Leave a Comment

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

Categories
Web Development/ Languages
Industrial Training in Gurgaon – Job Ready in 6 weeks
328 reviews
Next Batch - 5 Jun, 2024
6 months Online/ Offline
Summer Training in Gurgaon – Job ready in 6 weeks
328 reviews
Next Batch - 5 Jun, 2024
6 months Online/ Offline
Data Structures and Algorithms Certification Program
328 reviews
Next Batch - 5 Jun, 2024
6 months Online/ Offline
Java Spring5 (Boot and Micro Services) Training in Gurgaon
236 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
C/C++ Programming Training in Gurgaon
428 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Teach your Kids to Code | Python for Elementary Students
678 reviews
Next Batch - 5 Jun, 2024
2 months Online/ Offline
Java 8 Frameworks Training courses-Spring | Hibernate | Webservices
317 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Java Training in Gurgaon | Core and Advanced Java Programming Course
495 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Python Language Framework Django Training in Gurgaon,Delhi
435 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Dot NET MVC Training in Gurgaon
258 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Dot Net Core Training in Gurgaon
308 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Android Training in Gurgaon | Mobile App Development Training
283 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Industrial Training in Gurgaon – Job Ready in 6 weeks
328 reviews
Next Batch - 5 Jun, 2024
6 months Online/ Offline
Summer Training in Gurgaon – Job ready in 6 weeks
328 reviews
Next Batch - 5 Jun, 2024
6 months Online/ Offline
Data Structures and Algorithms Certification Program
328 reviews
Next Batch - 5 Jun, 2024
6 months Online/ Offline
Java Spring5 (Boot and Micro Services) Training in Gurgaon
236 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
C/C++ Programming Training in Gurgaon
428 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Teach your Kids to Code | Python for Elementary Students
678 reviews
Next Batch - 5 Jun, 2024
2 months Online/ Offline
Java 8 Frameworks Training courses-Spring | Hibernate | Webservices
317 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Java Training in Gurgaon | Core and Advanced Java Programming Course
495 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Python Language Framework Django Training in Gurgaon,Delhi
435 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Dot NET MVC Training in Gurgaon
258 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Dot Net Core Training in Gurgaon
308 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Android Training in Gurgaon | Mobile App Development Training
283 reviews
Next Batch - 5 Jun, 2024
3 months Online/ Offline
Drop us a Query
+91-9999201478

Available 24x7 for your queries

Please enable JavaScript in your browser to complete this form.