Did you know there are more than 500+ Excel Shortcut keys? Well, if you don’t believe check out the Excel Shortcut keys list below. The one which is very much familiar with Microsoft Excel will be surprised by the number of shortcuts and tricks Excel provides.

These Excel Shortcut keys and tricks will speed up the work and make things convenient for you. I can guarantee you that it’s worth the time utilized to learn these Shortcut keys of ms excel. Many users do not understand the importance of Excel Shortcuts unless and until they use it. Click here to know more about Google Sheet shortcuts.

Top 20 Microsoft Excel Shortcuts keys you Should know

There are no Microsoft Excel users who would dislike these Excel Shortcut keys. They are the most amazing thing that will happen when you have learned them fully, Check out Top 20 Shortcut keys in Excel.

General - Excel Shortcuts

Action Excel Shortcuts
Open Options Alt, F, T
Open help F1
Undo last action Ctrl + Z
Redo last action Ctrl + Y
Copy selected cells Ctrl + C
Repeat last action F4
Cut selected cells Ctrl + X
Paste content from clipboard Ctrl + V
Paste Special dialog box Ctrl + Alt + V
Find and Replace Ctrl + F
Find and Replace,Replace selected Ctrl + H
Find previous match Ctrl + Shift + F4
Find next match Shift+ F4
Create embedded chart Alt + F1
Create chart in new worksheet F11

File - Excel Shortcuts

Action Excel Shortcuts
Create new Workbook Ctrl + N
Open workbook Ctrl + O
Save workbook Ctrl + S
Save as F12
Print file Ctrl + P
Open print preview window Ctrl + F2
Close current workbook Ctrl + F4
Close Excel Alt + F4

Ribbon - Excel Shortcuts

Action Excel Shortcuts
Expand or collapse ribbon Ctrl + F1
Activate access keys Alt
Move to next ribbon control Tab
Activate or open selected control Space
Confirm control change Enter
Get help on selected control F1

Tables and Data Forms - Excel Shortcuts

Action Excel Shortcuts PDF
Insert table Ctrl + T
Select table row Shift + Space
Select table column Ctrl + Space
Select table Ctrl + A
Toggle table total row Ctrl + Shift + T
Move to the next field which can be edited Tab
Move to the previous field which can be edited Shift + Tab
Move to the first field in the next record Enter
Move to the first field in the previous record Shift + Enter
Move to the same field 10 records forward Page Down
Move to the same field 10 records back Page Up
Move to a new record Ctrl + Page Down
Move to a first record Ctrl + Page Up
Move to the beginning of a field Home
Move to the end of a field End

Filters - Excel Shortcuts

Action Excel Shortcuts
Activate filter Alt + ↓
Toggle Autofilter Ctrl + Shift + L
Clear slicer filter Alt + C
Select the next item in the AutoFilter list
Select the previous item in the AutoFilter list
Close the AutoFilter list for the current column Alt + ↑
Select the first item in the AutoFilter list Home
Select the last item in the AutoFilter list End

Drag and Drop - Excel Shortcuts

Action Excel Shortcuts
Activate filter Alt + ↓
Drag and cut Drag
Drag and Copy Ctrl + Drag
Drag and insert Shift + Drag
Drag and insert copy Ctrl + Shift + Drag
Drag to worksheet Alt + Drag
Drag to duplicate worksheet Ctrl + Drag

Navigation - Excel Shortcuts

Action Excel Shortcuts
Move one cell right
Move one cell left
Move one cell up
Move one cell down
Move one screen right Alt + Page Down
Move one screen left Alt + Page Up
Move one screen up Page Up
Move one screen down Page Down
Move to right edge of data region Ctrl + →
Move to left edge of data region Ctrl + ←
Move to top edge of data region Ctrl + ↑
Move to bottom edge of data region Ctrl + ↓
Move to beginning of row Home
Move to last cell in worksheet Ctrl + End
Move to first cell in worksheet Ctrl + Home
Turn End Mode on End
Go back to hyperlink Ctrl + G + Enter

Active Cell - Excel Shortcuts

Action Excel Shortcuts
Select active cell only Shift + Backspace
Show the active cell on worksheet Ctrl + Backspace
Move active cell clockwise in selection Ctrl + .
Move active cell down in selection Enter
Move active cell up in selection Shift + Enter
Move active cell right in a selection Tab
Move active cell left in a selection Shift + Tab

Selection - Excel Shortcuts

Action Excel Shortcuts
Select entire row Shift + Space
Select entire column Ctrl + Space
Select entire worksheet Ctrl + A
Add adjacent cells to selection Shift + Click
Add non-adjacent cells to selection Ctrl + Click
Move right between non-adjacent selections Ctrl + Alt + →
Move left between non-adjacent selections Ctrl + Alt + ←
Toggle add to selection mode Shift + F8
Cancel selection Esc

Extend Selection - Excel Shortcuts

Action Excel Shortcuts
Extend selection by one cell right Shift + →
Extend selection by one cell left Shift + ←
Extend selection by one cell up Shift + ↑
Extend selection by one cell down Shift + ↓
Extend the selection to the last cell right Ctrl + Shift + →
Extend the selection to the last cell left Ctrl + Shift + ←
Extend the selection to the last cell up Ctrl + Shift + ↑
Extend the selection to the last cell down Ctrl + Shift + ↓
Extend selection up one screen Shift + Page Up
Extend selection down one screen Shift + Page Down
Extend selection right one screen Alt + Shift + Page Down
Extend selection left one screen Alt + Shift + Page Up
Extend selection to start of row Shift + Home
Extend selection to first cell in worksheet Ctrl + Shift + Home
Extend selection to last cell in worksheet Ctrl + Shift + End
Toggle extend selection mode F8

Select Special - Excel Shortcuts

Action Excel Shortcuts
Display Go To dialog box Ctrl + G
Select cells with comments Ctrl + Shift + O
Select current region around active cell Ctrl + Shift + *
Select current region Ctrl + A
Select current array Ctrl + /
Select row differences Ctrl + \
Select column difference Ctrl + Shift + |
Select direct precedents Ctrl + [
Select all precedents Ctrl + Shift + {
Select direct dependents Ctrl + ]
Select all dependents Ctrl + Shift + }
Select visible cells only Alt + ;

Entering Data - Excel Shortcuts

Action Excel Shortcuts
Enter and move down Enter
Enter and move up Shift + Enter
Enter and move right Tab
Enter and move left Shift + Tab
Complete entry and stay in same cell Ctrl + Enter
Enter same data in multiple cells Ctrl + Enter
Insert current date Ctrl + ;
Insert current time Ctrl + Shift + :
Fill down from cell above Ctrl + D
Fill right from cell left Ctrl + R
Copy formula from cell above Ctrl + ‘
Copy value from cell above Ctrl + Shift + “
Add hyperlink Ctrl + K
Display AutoComplete list Alt + ↓
Flash Fill Ctrl + E

Cell Edit Mode - Excel Shortcuts

Action Excel Shortcuts
Edit the active cell F2
Insert or edit comment Shift + F2
Cancel entry Esc
Select one character right Shift + →
Select one character left Shift + ←
Move one word right Ctrl + →
Move one word left Ctrl + ←
Select one word right Ctrl + Shift + →
Select one word left Ctrl + Shift + ←
Select to beginning of cell Shift + Home
Select to end of cell Shift + End
Delete to end of line Ctrl + Delete
Delete character to the left of cursor Backspace
Delete character to the right of cursor Delete
Start a new line in the same cell Alt + Enter

Formatting - Excel Shortcuts

Action Excel Shortcuts PDF
Format anything Ctrl + 1
Display Format cells with font tab selected Ctrl + Shift + F
Apply or remove bold formatting Ctrl + B
Apply or remove italic formatting Ctrl + I
Apply or Remove underscoring Ctrl + U
Apply or remove strike-through formatting Ctrl + 5
Align center Alt, H, A, C
Align left Alt, H, A, L
Align right Alt, H, A, R
Indent Alt, H, 6
Remove indent Alt, H, 5
Increase font size one step Alt, H, FG
Decrease font size one step Alt, H, FK

Number Formatting - Excel Shortcuts

Action Excel Shortcut keys
Apply general format Ctrl + Shift + ~
Apply currency format Ctrl + Shift + $
Apply percentage format Ctrl + Shift + %
Apply scientific format Ctrl + Shift + ^
Apply date format Ctrl + Shift + #
Apply time format Ctrl + Shift + @
Apply number format Ctrl + Shift + !

Cell Borders - Excel Shortcuts

Action Excel Shortcut keys
Add border outline Ctrl + Shift + &
Add or remove border right Alt, H, B, R
Add or remove border left Alt, H, B, L
Add or remove border top Alt, H, B, T
Add or remove border bottom Alt, H, B, B
Add or remove border upward diagonal Alt, H, B, D
Add or remove border horizontal interior Alt, H, B, H
Add or remove border vertical interior Alt, H, B, V
Remove borders Ctrl + Shift + _

Formulas - Excel Shortcuts

Action Excel Shortcut keys
Toggle absolute and relative references F4
Open the Insert function dialog box Shift + F3
Autosum selected cells Alt + =
Toggle formulas on and off Ctrl + ‘
Insert function arguments Ctrl + Shift + A
Enter array formula Ctrl + Shift + Enter
Calculate worksheets F9
Calculate active worksheet Shift + F9
Force calculate all worksheets Ctrl + Alt + F9
Evaluate part of a formula F9
Expand or collapse the formula bar Ctrl + Shift + U
Display function arguments dialog box Ctrl + A
Define name Ctrl + F3
Define name using row and column labels Ctrl + Shift + F3
Paste name into formula F3
Accept function with autocomplete Tab

Grid Operations - Excel Shortcuts

Action Excel Shortcut keys
Display Insert dialog box Ctrl + Shift + +
Insert rows Ctrl + Shift + +
Insert columns Ctrl + Shift + +
Display Delete dialog box Ctrl + –
Delete rows Ctrl + –
Delete columns Ctrl + –
Delete cells Ctrl + –
Delete contents of selected cells Delete
Hide columns Ctrl + 0
Hide rows Ctrl + 9
Unhide rows Ctrl + Shift + 9
Unhide columns Ctrl + Shift + 0
Group rows or columns Alt + Shift + →
Ungroup rows or columns Alt + Shift + ←
Open group dialog box Alt + Shift + →
Open Ungroup dialog box Alt + Shift + ←
Hide or show outline symbols Ctrl + 8
Zoom in Ctrl + Alt + +
Zoom out Ctrl + Alt + –

Workbook - Excel Shortcuts

Action Excel Shortcuts
Insert new worksheet Shift + F11
Go to next worksheet Ctrl + Page Down
Go to previous worksheet Ctrl + Page Up
Move to next pane F6
Move to previous pane Shift + F6
Go to next workbook Ctrl + Tab
Go to previous workbook Ctrl + Shift + Tab
Minimize current workbook window Ctrl + F9
Maximize current workbook window Ctrl + F10
Select adjacent worksheets Shift + Click
Select non-adjacent worksheets Ctrl + Click
Toggle scroll lock Scr Lk
Toggle full screen Ctrl + Shift + F1

Pivot Tables - Excel Shortcuts

Action Excel Shortcut keys
Select entire pivot tables Ctrl + A
Toggle pivot table field checkbox Space
Group pivot table items Alt + Shift + →
Ungroup pivot table items Alt + Shift + ←
Hide pivot table item Ctrl + –
Create pivot chart on same worksheet Alt + F1
Create pivot chart on new worksheet F11
Open pivot table wizard Alt, D, P

Dialog Boxes - Excel Shortcuts

Action Excel Shortcuts
Move to next control Tab
Move to previous control Shift + Tab
Move to next tab Ctrl + Tab
Move to previous tab Ctrl + Shift + Tab
Accept and apply Enter
Check and uncheck box Space
Cancel and close the dialog box Esc

Other - Excel Shortcuts

Action Excel Shortcuts
Open spelling dialog box F7
Open Thesaurus dialog box Shift + F7
Open Macro dialog box Alt + F8
Open VBA Editor Alt + F11
Duplicate object Ctrl + D
Snap to grid Alt
Hide or show objects Ctrl + 6
Display modify cell style dialog box Alt + ‘
Display right click menu Shift + F10
Delete comment Shift + F10, D
Display control menu Alt + Space

All the above ms excel shortcut keys will benefit after you have got a grip or control of it. Excel Shortcuts keys will make every action of your short. Hence learning this Excel Shortcut keys will help you to ease your task, cut down extra efforts, land you more time in prioritizing your work.

Hope you have liked our blog on Excel Shortcut keys. Suggestions are always welcomed for the blog you looking forward to hearing from us. Like our My e-Learning Hub Facebook Page and subscribe to our My e-Learning Hub YouTube Channel. Connect with us and Take your Office Productivity to Next Level.

4 Comments

Leave a comment

Main Office:

Mumbai, India

Contact Us:

[email protected]

MyeLearningHUB © 2019. All rights reserved.