MS Excel Shortcuts Keys, when starting with Microsoft Excel, knowing a few ms excel shortcuts keys will reduce your work time and make it easier to work on Excel. Using the mouse to do all the tasks reduces your productivity. Here are the most used Excel shortcuts to use when you just begin working with Microsoft Excel.
![220+ Excel Shortcuts Keys for Windows & Mac | Excel Shortcuts [Updated] (1)](https://i0.wp.com/yodalearning.com/wp-content/uploads/e-book-cover-mockup-template-over-transparent-background-a9862.png "220+ Excel Shortcuts Keys for Windows & Mac | Excel Shortcuts [Updated] (1)")
PDF GUIDE BOOKS
- Download Excel Shortcuts for Windows & Mac
- Basic to Advanced Excel Formulas PDF Guide
This Book will help you to get Excel Skills & Boost your career.
These MS Excel Keyboard shortcuts for beginner works with all versions of MS Excel 2003, MS Excel 2007, MS Excel 2010, MS Excel 2013, MS Excel 2016, MS Excel 2019 & Office 365. In this blog, you will learn how to use basic excel shortcuts.
File Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Create new workbook | CTRL + N | ⌘ + N |
| Open workbook | CTRL O | ⌘ O |
| Save workbook | CTRL S | ⌘ S |
| Save as | F12 | ⌘ ⇧ S |
| Print Excel sheet | CTRL P | ⌘ P |
| Open print preview window | CTRL F2 | |
| Close current window | CTRL W | ⌘ W |
| Close Excel | ALT F4 | ⌘ Q |
Ribbon Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Expand or collapse | CTRL F1 | ⌘ ⌥ R |
| Excel hot keys | ALT | |
| Move to Next Ribbon Control | TAB | TAB |
| Move to a previous button | SHIFT TAB | SPACE |
| Accept and Confirm | ENTER | RETURN |
| Get help | F1 | |
Active Cell Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Select active cell only | SHIFT BACKSPACE | ⇧ DELETE |
| Show active cell on a worksheet | CTRL BACKSPACE | ⌘ DELETE |
| Move active cell clockwise in selection | CTRL . | ⌃ . |
| Move active cell down in selection | ENTER | RETURN |
| Move active cell up in selection | SHIFT ENTER | ⇧ RETURN |
| Move active cell Right in a selection | TAB | TAB |
| Move active cell Left in a selection | SHIFT TAB | ⇧ TAB |
PDF GUIDE BOOKS
- Download Excel Shortcuts for Windows & Mac
- Basic to Advanced Excel Formulas PDF Guide
This Book will help you to get Excel Skills & Boost your career.
General Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Open Help | F1 | ⌘ / |
| Undo last action | CTRL Z | ⌘ Z |
| Redo last action | CTRL Y | ⌘ Y |
| Copy selected cells | CTRL C | ⌘ C |
| Repeat last action | F4 | ⌘ Y |
| Cut selected cells | CTRL X | ⌘ X |
| Paste content from clipboard | CTRL V | ⌘ V |
| Display Paste Special | ALT E S | ⌘ ^ V |
| Display Find and Replace | CTRL F | ⌘ F |
| Find with Replace selected | CTRL H | ^ H |
| Find previous match | CTRL SHIFT F4 | ⌘ ⇧ G |
| Find next match | SHIFT F4 | ⌘ G |
| Create Embedded Chart | ALT F1 | Fn ⌥ F1 |
| Create chart in new worksheet | F11 | Fn F11 |
| Toggle auto filter | CTRL SHIFT L | ⌘ ⇧ F |
| Activate filter Dropdown | ALT ↓ | ⌥ ↓ |
| Insert table | CTRL T | ^ T |
| Select table row | SHIFT SPACE | ⇧ SPACE |
| Select table column | CTRL SPACE | ^ SPACE |
| Select table | CTRL A | ⌘ A |
Selection Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Select entire row | SHIFT SPACE | ⇧ SPACE |
| Select entire column | CTRL SPACE | ^ SPACE |
| Select entire worksheet | CTRL A | ⌘ A |
| Toggle add to selection mode | SHIFT F8 | Fn ⇧ F8 |
| Cancel selection | ESC | ESC |
Navigation Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Move one cell right | → | → |
| Move one cell left | ← | ← |
| Move one cell up | ↑ | ↑ |
| Move one cell down | ↓ | ↓ |
| Move one screen Right | ALT Pg Dn | Fn ⌥ ↓ |
| Move one screen left | ALT Pg Up | Fn ⌥ ↑ |
| Move one screen up | Pg Up | Fn ↑ |
| Move one screen down | Pg Dn | Fn ↓ |
| 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 | Fn ← |
| Move to last cell in worksheet | CTRL END | Fn ^ → |
| Move to first cell in worksheet | CTRL HOME | Fn ^ ← |
| Turn End mode on | END | Fn → |
PDF GUIDE BOOKS
- Download Excel Shortcuts for Windows & Mac
- Basic to Advanced Excel Formulas PDF Guide
This Book will help you to get Excel Skills & Boost your career.
Number Formatting Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| 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 ! | ^ ⇧ ! |
Extend Selection Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| ES by One Cell Right | SHIFT → | ⇧ → |
| ES by One Cell Left | SHIFT ← | ⇧ ← |
| ES by One cell Up | SHIFT ↑ | ⇧ ↑ |
| ES by One Cell Down | SHIFT ↓ | ⇧ ↓ |
| ES to the last Cell Right | CTRL SHIFT → | ^ ⇧ → |
| ES to the last Cell Left | CTRL SHIFT ← | ^ ⇧ ← |
| ES to the last Cell Up | CTRL SHIFT ↑ | ^ ⇧ ↑ |
| ES to the Last Cell Down | CTRL SHIFT ↓ | ^ ⇧ ↓ |
| ES Up One Screen | SHIFT Pg Up | Fn ⇧ ↑ |
| ES Down One Screen | SHIFT Pg Dn | Fn ⇧ ↓ |
| ES Right One Screen | ALT SHIFT Pg Dn | Fn ⇧ ⌥ ↓ |
| ES Left One Screen | ALT SHIFT Pg Up | Fn ⇧ ⌥ ↑ |
| ES to Start of Row | SHIFT HOME | Fn ⇧ ← |
| ES to the First Cell in the worksheet | CTRL SHIFT HOME | Fn ^ ⇧ ← |
| ES to the last cell in the Worksheet | CTRL SHIFT END | Fn ^ ⇧ → |
| Toggle ES Mode | F8 | Fn F8 |
Cell Edit Mode Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Display ‘Go To’ Dialog Box | CTRL G | ^ G |
| Select Row Differences | CTRL \ | ^ \ |
| Select Column Differences | CTRL SHIFT | | ^ ⇧ | |
| Select Cells with Comments | CTRL SHIFT O | Fn ^ ⇧ O |
| Select Current Region | CTRL A | ⌘ A |
| Select Current Array | CTRL / | ^ / |
| Select Direct Precedents | CTRL [ | ^ [ |
| Select All Precedents | CTRL SHIFT { | ^ ⇧ { |
| Select Direct Dependents | CTRL ] | ^ ] |
| Select All Dependents | CTRL SHIFT } | ^ ⇧ } |
| Select Visible Cells Only | ALT ; | ⌘ ⇧ Z |
Entering Data Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Enter and Move down | ENTER | RETURN |
| Enter and Move up | SHIFT ENTER | ⇧ RETURN |
| Enter and Move right | TAB | TAB |
| Enter and Move left | SHIFT TAB | ⇧ TAB |
| Enter same data in multiple cells | CTRL ENTER | ^ RETURN |
| Insert Current Date | CTRL ; | ^ ; |
| Insert current time | CTRL SHIFT : | ⌘ ; |
| Fill down from cell above | CTRL D | ^ D |
| Fill right from cell left | CTRL R | ^ R |
| Copy formulas from cell above | CTRL ‘ | ^ ‘ |
| Copy value from cell above | CTRL SHIFT “ | ^ ⇧ “ |
| Add Hyperlink | CTRL K | ⌘ K |
| Display auto complete list | ALT ↓ | ⌥ ↓ |
| Flash Fill | CTRL E | |
Formatting Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Format (almost) anything | CTRL 1 | ⌘ 1 |
| Display format cells font tab | CTRL SHIFT F | ^ ⇧ F |
| Apply or Remove bold formatting | CTRL B | ⌘ B |
| Apply or Remove italic formatting | CTRL I | ⌘ I |
| Apply or Remove Underscoring | CTRL U | ⌘ U |
| Toggle strike through formatting | CTRL 5 | ⌘ ⇧ X |
| Align Center | ALT H A C | ⌘ E |
| Align Left | ALT H A L | ⌘ L |
| Align Right | ALT H A R | ⌘ R |
| Indent | ALT H 6 | ^ ⌥ TAB |
| Remove Indent | ALT H 5 | ^ ⌥ ⇧ TAB |
| Increase font size one step | ALT H FG | ⌘ ⇧ > |
| Decrease font size one step | ALT H FK | ⌘ ⇧ < |
Borders Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Add Border Outline | CTRL SHIFT & | ⌘ ⌥ 0 |
| Add OR Remove Border Right | ALT R | ⌘ ⌥ → |
| Add OR Remove Border Left | ALT L | ⌘ ⌥ ← |
| Add OR Remove Border Top | ALT T | ⌘ ⌥ ↑ |
| Add OR Remove Border Bottom | ALT B | ⌘ ⌥ ↓ |
| Add OR Remove Border Upward Diagonal | ALT D | |
| Add OR Remove Border Horizontal Interior | ALT H | |
| Remove Borders | CTRL SHIFT _ | ⌘ ⌥ _ |
Dialog Boxes Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Move to Next Control | TAB | TAB |
| Cancel and close the dialog box | ESC | ESC |
| Toggle between open books | CTRL TAB | ⇧ TAB |
| Move to previous tab | CTRL SHIFT TAB | ^ ⇧ TAB |
| Accept and apply | ENTER | RETURN |
| Check and Uncheck box | SPACE | SPACE |
Formulas Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Toggle Absolute & Relative references | F4 | ⌘ T |
| Open Insert function dialog | SHIFT F3 | Fn ⇧ F3 |
| AutoSum selected cells | ALT = | ⌘ ⇧ T |
| Toggle formulas on and off | CTRL ‘ | ^ ‘ |
| Enter Array formula | CTRL SHIFT ENTER | ^ ⇧ RETURN |
| Calculate worksheets | F9 | Fn F9 |
| Calculate active worksheet | SHIFT F9 | Fn ⇧ F9 |
| Force calculate all worksheets | CTRL ALT F9 | |
| Evaluate part of a formula | F9 | Fn F9 |
| Expand/Collapse formula bar | CTRL SHIFT U | ^ ⇧ U |
| Display function arguments dialog box | CTRL A | ^ A |
| Define name | CTRL F3 | Fn ^ F3 |
| Define names form lables | CTRL SHIFT F3 | Fn ^ ⇧ F3 |
| Paste name into formula | F3 | |
Pivot Table Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Select entire pivot table | CTRL A | ⌘ A |
| Toggle pivot table field checkbox | SPACE | SPACE |
| Group pivot table items | ALT SHIFT → | ⌘ ⇧ K |
| Ungroup pivot table items | ALT SHIFT ← | ⌘ ⇧ J |
| Hide pivot table item | CTRL – | ⌘ – |
| Create pivot chart on same worksheet | ALT F1 | |
| Open pivot table wizard | ALT D P | ⌘ ⌥ P |
| Insert calculated field | CTRL SHIFT + | |
| Create pivot chart on new worksheet | F11 | Fn F11 |
Grid Operations Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| 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 | Fn DELETE |
| Hide columns | CTRL 0 | ^ 0 |
| Hide rows | CTRL 9 | ^ 9 |
| Unhide rows | CTRL SHIFT 9 | ^ ⇧ 9 |
| Unhide columns | CTRL SHIFT 0 | ^ ⇧ 0 |
| Group rows or columns | ALT SHIFT → | ⌘ ⇧ K |
| Ungroup rows or columns | ALT SHIFT ← | ⌘ ⇧ J |
| Open group dialog box | ALT SHIFT → | ⌘ ⇧ K |
| Open ungroup dialog box | ALT SHIFT ← | ⌘ ⇧ J |
| Hide or show outline symbols | CTRL 8 | ^ 8 |
Workbook Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Insert new worksheet | SHIFT F11 | Fn ⇧ F11 |
| Go to next worksheet | CTRL Pg Dn | Fn ^ ↓ |
| Go to previous worksheet | CTRL Pg Up | Fn ^ ↑ |
| Move to next pane | F6 | Fn F6 |
| Move to previous pane | SHIFT F6 | Fn ⇧ F6 |
| Go to next workbook | CTRL TAB | ^ TAB |
| Go to previous workbook | CTRL SHIFT TAB | ^ ⇧ TAB |
| Minimize current workbook window | CTRL F9 | ⌘ M |
| Maximize current workbook window | CTRL F10 | Fn ^ F10 |
| Toggle scroll lock | SCROLL LOCK | Fn ⇧ F14 |
Others Excel Shortcuts
| Descriptions | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
| Open spelling dialog box | F7 | Fn F7 |
| Open thesaurus dialog box | SHIFT F7 | Fn ⇧ F7 |
| Open macro dialog box | ALT F8 | Fn ⌥ F8 |
| Open VBA editor | ALT F11 | Fn ⌥ F11 |
| Duplicate object | CTRL D | ⌘ D |
| Snap to grid | ALT | ⌘ |
| Hide or show objects | CTRL 6 | ^ 6 |
| Display modify cell style | ALT ‘ | ⌘ ⇧ L |
| Display shortcuts menu | SHIFT F10 | Fn ⇧ F10 |
| Display control menu | ALT SPACE | ? |
Creating Reports in Excel is time-consuming but we do haveShortcuts in Excel using which we will save time in navigation, formatting, selecting, and entering Formulas for our Data. You can also learn more tricks inExcel Dashboard Course
What do you think about the idea of Excel Shortcutshere?
What if theExcel Shortcutscan ease out these tasks?
Definitely, it can.
I don’t think there is any Excel User, who vigorously uses Excel and will dislike the idea of Using Excel Shortcut keys.
This will not only save your time but also save you from the extra efforts and pain that you put into using Excel while you deal with heaps of Data.
PDF GUIDE BOOKS
- Download Excel Shortcuts for Windows & Mac
- Basic to Advanced Excel Formulas PDF Guide
This Book will help you to get Excel Skills & Boost your career.
FAQs
To insert Time in Excel, follow the steps:
- Select the Tab in which you wish to insert the time
- Press Ctrl + Shift + ; (semicolon)
- The current time will be inserted
To insert Date in Excel, follow the steps:
- Select the Tab in which you wish to insert the date
- Press Ctrl + ; (semicolon)
- The current date will be inserted
Ctrl + F is used to search in Excel
To assign your own shortcuts in Excel, follow the steps:
- Click on File > Options tab
- Click on Customize Ribbon
- Select Customize option at the bottom of the Customize ribbon dialog box
- In the Save Changes box, select the document for which you want to customize
- In categories box, select the category or the command
- Select New Shortcut Key Box, assign the shortcut of your choice
- Select assign and the changes will be made.
Ctrl + Shift + ~ is the shortcut for general format cells in Excel.
Ctrl + S is the key to save in excel.
How to open a new sheet in excel?
Use Ctrl+ N keys to open new sheet in excel