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 |
You can learn also: 150+ Google Sheets Shortcuts – Download Google Sheets Shortcuts PDF
File 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 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 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 |
Excel Filters 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 |
You can learn also: Searching for a list of Excel Alternatives? Check out Top 10 Free Excel Alternatives along with benefits.
Drag and Drop 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 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 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 |
Excel Selection 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 |
You can learn also: Learn Everything about Google Sheets and Top 10 Google Sheets Formulas.
Extend Selection – 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 + ; |
You can learn also: Top 20 Interview Questions and Answers – Interview Questions
Shortcuts for Entering Data
| 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 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 + ! |
You can learn also: The 15 Most Useful Google Sheets Formulas – Spreadsheets Formulas
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 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 |
Read more
69 Adobe Photoshop Shortcuts you need to know
20 Time-saving Shortcuts for Microsoft OneNote
150+ Windows keyboard Shortcuts to boost your productivity
Top 15 Tips & Tricks of Google Sheets
Technical Analysis vs Fundamental Analysis – Difference
All the above ms excel shortcut keys will benefit after you have got a grip or control of it. Excel Shortcuts PDF will make every action of your short. Hence learning this Excel Shortcut keys in 2021 is a must as it 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 MS Excel Shortcuts Keys PDF 2020 & 2021. Suggestions are always welcomed for the blog you looking forward to hearing from us. Connect with us and Take your Office Productivity & Efficiency to Next Level!
