Below is the list of Excel keyboard shortcuts that you can use in your day-to-day activities in Excel to make your work faster. If you are navigating through sheets, formatting cells, or complex calculations, these shortcuts will save you much time and reduce your efforts.
How to Use Shortcut Keys
If you notice the shortcuts below, you will see that there are two types of separators. One is a plus sign and another is a comma separator.
- The plus (+) separator indicates that you should press all the shortcut keys together. For example, Ctrl + N means pressing and holding both Ctrl and N simultaneously on your keyboard.
- The comma (,) separator indicates you should press each key one after the other by releasing each key before pressing the next. For example, Alt, H, B, A means pressing the Alt key, then H, then B and finally A in sequence.
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Creates a new blank workbook | Ctrl + N | ⌘ + N |
| Open the dialog box to find a file | Ctrl + O | ⌘ + O |
| Save the active workbook | Ctrl + S | ⌘ + S |
| Save As dialog box | F12 | ⌘ + Shift + S |
| Display the Print Preview window | Ctrl + F2 | ⌘ + P |
| Maximize or restore the current workbook | Ctrl + F10 | fn + ⌃ + F10 |
| Minimize Workbook | Ctrl + F9 | ⌘ + M |
| Switch to the Next Workbook | Ctrl + Tab | ⌘ + Option + → |
| Switch to the Previous Workbook | Ctrl + Shift + Tab | ⌘ + Shift + ` |
| Close Current Workbook | Alt + F4 | ⌘ + W |
Excel Cell Editing Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Edit the content of the active cell | F2 | Ctrl + U |
| Start a new line within the same cell | Alt + ENTER | Option + Return |
| Select the cell to the right | SHIFT + → | Shift + → |
| Select the cell to the left | SHIFT + ← | Shift + ← |
| Navigate the cursor to the right | Ctrl + → | Option + → |
| Navigate the cursor to the left | Ctrl + ← | Option + ← |
| Select all cells to the right with values | Ctrl + SHIFT + → | Option + Shift + → |
| Select all cells to the left with values | Ctrl + SHIFT + ← | Option + Shift + ← |
| Delete the character to the left | Backspace | Delete |
| Delete the character to the right | Delete | Delete |
| Delete the word to the right of the cursor | Ctrl + Delete | Fn + Option + Delete |
| Cancel the current cell entry | Esc | Esc |
Navigation Shortcuts in Excel
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Move Up One Cell | ↑ | ↑ |
| Move Down One Cell | ↓ | ↓ |
| Move Right One Cell | → | → |
| Move Left One Cell | ← | ← |
| Scroll down one screen | PageDown | Fn + ↓ |
| Scroll up one screen | PageUp | Fn + ↑ |
| Move one screen to the right | Alt + PageDown | Option + Fn + ↓ |
| Move one screen to the left | Alt + PageUp | Option + Fn + ↑ |
| Go toward the Right of the Data | Ctrl + → | ⌘ + → |
| Go towards the Left of the Data | Ctrl + ← | ⌘ + ← |
| Go towards the Bottom of the Data | Ctrl + ↓ | ⌘ + ↓ |
| Go towards the Top of the Data | Ctrl + ↑ | ⌘ + ↑ |
| Move to the last used cell at bottom right | Ctrl + End | ⌘ + End |
| Go to the First Cell in the Current Region | Ctrl + Home | ⌘ + ↑ |
| Move to the Beginning of the Row | Home | ⌘ + ← |
| Switch to the Next Worksheet | Ctrl + PageDown | ⌘ + Fn + ↓ |
| Switch to the Previous Worksheet | Ctrl + PageUp | ⌘ + Fn + ↑ |
General Excel Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Open the Help window | F1 | ⌘ + Shift + / |
| Repeat the last action | Ctrl + Y or F4 | ⌘ + Y |
| Undo the last command or action | Ctrl + Z | ⌘ + Z |
| Spelling Check | F7 | ⌘ + Shift + ; |
| Apply a data filter | Ctrl + Shift + L | ⌘ + Shift + L |
| Activate filter dropdown (when the cell with filter is selected) | Alt + ↓ | ⌥ + ↓ |
| Display the Go To dialog box | Ctrl + G | Fn + F5 |
| Recalculate all open workbooks | F9 | ⌘ + = |
| Calculate the active worksheet | Shift + F9 | ⌘ + Shift + = |
| Open the Print menu | Ctrl + P | ⌘ + P |
| Turn on End mode | End | Fn + Right Arrow |
Cut, Copy, and Paste Shortcuts in Excel
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Copy the values from selected cells | Ctrl + C | ⌘ + C |
| Cut the values from selected cells | Ctrl + X | ⌘ + X |
| Paste copied content from the clipboard | Ctrl + V | ⌘ + V |
| Copy the formula from the cell above | Ctrl + ‘ | ⌘ + Shift + ‘ |
| Copy the value from above cell | Ctrl + Shift + ‘ | ⌘ + Option + ‘ |
| Show the Paste Special dialog box | Ctrl + Alt + V | ⌘ + Option + V |
Data Entry Shortcuts in Excel
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Move to the next cell below | Enter | Enter |
| Enter data and stay in the same cell | Ctrl + Enter | ⌘ + Enter |
| Move to the previous cell | Shift + Enter | Shift + Enter |
| Move to the right cell | Tab | Tab |
| Move to the left cell | Shift + Tab | Shift + Tab |
| Enter the same data in all selected cells | Ctrl + Enter | ⌘ + Enter |
| Display the AutoComplete list | Alt + ↓ | ⌥ + ↓ |
| Fill down in the column with the selected cells | Ctrl + D | ⌘ + D |
| Fill right in the row with the selected cells | Ctrl + R | ⌘ + R |
| Insert the current date | Ctrl + ; | ⌘ + ; |
| Insert the current time | Ctrl + Shift + ; | ⌘ + Shift + ; |
| Start a new line within the same cell | Alt + Enter | Option + Return |
| Cancel the current cell entry | Esc | Esc |
Clear Shortcuts in Excel
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Clear all content, formatting, and comments | Alt, H, E, A | ⌘, Option, E, A |
| Clear only the cell formatting | Alt, H, E, F | ⌘, Option, E, F |
| Clear only the cell content | Alt, H, E, C | ⌘, Option, E, C |
| Clear only hyperlinks from selected cells | Alt, H, E, L | ⌘, Option, E, L |
| Clear only comments from selected cells | Alt, H, E, M | ⌘, Option, E, M |
Selection Shortcuts in Excel
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Select Everything in the Sheet | Ctrl + A | ⌘ + A |
| Select Only Visible Cells in the Current Region | Alt + ; | ⌥ + ; |
| Select the Data Region Around the Active Cell | Ctrl + Shift + * | ⌘ + Shift + * |
| Select the Whole Row | Shift + Space | Shift + Space |
| Select the Whole Column | Ctrl + Space | ⌘ + Space |
| Select All Cells which has Comments | Ctrl + Shift + O | ⌘ + Shift + O |
| Select Cells with Row Differences | Ctrl + \ | ⌘ + \ |
| Select Cells with Column Differences | Ctrl + Shift + [ | ⌘ + Shift + [ |
| Select All Cells Referenced by the Formula | Ctrl + Shift + { | ⌘ + Shift + { |
| Select All Cells Dependent on the Formula | Ctrl + Shift + } | ⌘ + Shift + } |
Extending the Selection Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Extend selection to the right by one cell | Shift + → | Shift + → |
| Extend selection to the left by one cell | Shift + ← | Shift + ← |
| Extend selection upwards by one cell | Shift + ↑ | Shift + ↑ |
| Extend selection downwards by one cell | Shift + ↓ | Shift + ↓ |
| Extend selection to the right till the last cell | Ctrl + Shift + → | ⌘ + Shift + → |
| Extend selection to the left till the last cell | Ctrl + Shift + ← | ⌘ + Shift + ← |
| Extend selection upwards to the last cell | Ctrl + Shift + ↑ | ⌘ + Shift + ↑ |
| Extend selection to the above by one screen | Shift + PageUp | Shift + Fn + ↑ |
| Extend selection to the below by one screen | Shift + PageDown | Shift + Fn + ↓ |
| Extend selection to the right by one screen | Alt + Shift + PageUp | Option + Shift + Fn + → |
| Extend selection to the left by one screen | Alt + Shift + PageDown | Option + Shift + Fn + ← |
| Extend selection to the start of the row | Shift + Home | Shift + ⌘ + ← |
| Extend selection to the first cell in the worksheet | Ctrl + Shift + Home | ⌘ + Shift + ↑ + ← |
| Extend selection to the last cell in the worksheet | Ctrl + Shift + End | ⌘ + Shift + ↓ + → |
| Toggle extend selection mode | F8 | F8 |
Alignment Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Align content to the center of the cell | Alt, H, A, C | ⌘, Option, C |
| Align content to the left of the cell | Alt, H, A, L | ⌘, Option, L |
| Align content to the right of the cell | Alt, H, A, R | ⌘, Option, R |
| Align content to the middle of the cell | Alt, H, A, M | ⌘, Option, M |
Hide/Unhide (Rows, Columns, Objects) Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Hide selected rows in selection | Ctrl + 9 | ⌘ + Option + 9 |
| Hide selected columns in selection | Ctrl + 0 | ⌘ + Option + 0 |
| Unhide hidden rows in selection | Ctrl + Shift + 9 | ⌘ + Option + Shift + 9 |
| Unhide hidden columns in selection | Ctrl + Shift + 0 | ⌘ + Option + Shift + 0 |
| Show/hide objects | Ctrl + 6 | ⌘ + 6 |
Insert Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Add a New Line Within the Same Cell | Alt + Enter | Option + Return |
| Insert a New Worksheet | Shift + F11 | Shift + Fn + F11 |
| Insert Row or Cell (Opens Dialog Box) | Ctrl + Shift + = | ⌘ + Shift + = |
| Insert the Current Date | Ctrl + ; | ⌘ + ; |
| Insert the Current Time | Ctrl + Shift + ; | ⌘ + Shift + ; |
| Insert a Table | Ctrl + T | ⌘ + T |
| Add a Hyperlink | Ctrl + K | ⌘ + K |
| Insert Function Arguments into Formula | Ctrl + Shift + A | ⌘ + Shift + A |
| Add/Edit a Cell Comment | Shift + F2 | Shift + Fn + F2 |
| Delete Row or Cell (Opens Dialog Box) | Ctrl + – | ⌘ + – |
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Bold Text | Ctrl + B | ⌘ + B |
| Italicize Text | Ctrl + I | ⌘ + I |
| Add Outline Border Around Selected Cells | Ctrl + Shift + 7 | ⌘ + Option + 0 |
| Remove Outline Border | Ctrl + Shift + _ | ⌘ + Option + – |
| Underline Text | Ctrl + U | ⌘ + U |
| Apply Strikethrough to Text | Ctrl + 5 | ⌘ + Shift + X |
| Increase Text Indentation | Alt, H, 6 | ⌘ + Option + Command + 6 |
| Decrease Text Indentation | Alt, H, 5 | ⌘ + Option + Command + 5 |
| Increase Font Size by One Step | Alt, H, F, G | ⌘ + Option + Shift + > |
| Decrease Font Size by One Step | Alt, H, F, K | ⌘ + Option + Shift + < |
| Format Numbers with Two Decimal Places and Commas for Thousands | Ctrl + Shift + ! | ⌘ + Shift + ! |
| Set Date Format with Day, Month, and Year | Ctrl + Shift + # | ⌘ + Shift + # |
| Apply Currency Format with Two Decimal Points | Ctrl + Shift + $ | ⌘ + Shift + $ |
| Format as Percentage Without Decimal Points | Ctrl + Shift + % | ⌘ + Shift + % |
| Format Time Displaying Hours, Minutes, and AM/PM | Ctrl + Shift + @ | ⌘ + Shift + @ |
| Apply General Number Formatting | Ctrl + Shift + ~ | ⌘ + Shift + ~ |
| Use Scientific Notation for Numbers | Ctrl + Shift + ^ | ⌘ + Shift + ^ |
| Open the Format Style Dialog Box | Alt + ‘ | ⌘ + Option + ‘ |
| Open the Format Cells Dialog Box | Ctrl + 1 | ⌘ + 1 |
| Open Font Formatting Options | Shift + Ctrl + F | ⌘ + Shift + F |
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Insert Autosum formula | Alt + = | ⌘ + Shift + T |
| Switch cell reference from absolute to relative in formula | F4 | ⌘ + T |
| Toggle the Visibility of the Formula Bar | Ctrl + Shift + U | ⌘ + Option + U |
| Launch the function wizard or dialog box | Shift + F3 | Shift + Fn + F3 |
| Enter a formula as an array formula | Ctrl + Shift + Enter | ⌘ + Shift + Enter |
| Evaluate part of the formula | F9 | Fn + F9 |
| Select the array containing the active cell | Ctrl + / | ⌘ + / |
| Select All Cells Referenced by Formulas | Ctrl + [ | ⌘ + [ |
| Highlight All Cells Referenced by the Formula in the Active cell | Ctrl + ] | ⌘ + ] |
| Toggle value/formula display | Ctrl + ` | ⌘ + ` |
| Recheck dependent formulas and calculate all cells in all open workbooks | Ctrl + Alt + Shift + F9 | ⌘ + Option + Shift + F9 |
Find and Replace Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Display Find Dialog box | Ctrl + F | ⌘ + F |
| Display Replace Dialog box | Ctrl + H | ⌘ + H |
| Find next match | Shift + F4 | Shift + ⌘ + G |
| Find the previous match | Ctrl + Shift + F4 | ⌘ + Shift + ⌘ + G |
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Open Conditional Formatting dialog box | Alt, O, D | ⌘ + Option + D |
| Remove Conditional Formatting from Selected Cells | Alt, H, L, C, S | ⌘ + Option + Command + C |
| Remove Conditional Formatting from the Entire Worksheet | Alt, H, L, C, E | ⌘ + Option + Command + E |
Charting Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Insert chart in the worksheet (using selected data) | Alt + F1 | ⌘ + Option + F1 |
| Insert a ChartSheet with a chart (using selected data) | F11 | ⌘ + Option + F11 |
Drag (Mouse) Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Drag and copy the selected cells | Ctrl + Drag | ⌘ + Drag |
| Drag and cut the selected cells | Drag | Drag |
| Duplicate worksheet | Ctrl + Drag | ⌘ + Drag |
| Switch position of cells/rows/columns | Shift + Drag | Shift + Drag |
Named Ranges Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Get a list of all defined named ranges | F3 | ⌘ + F3 |
| Create named range from selection | Ctrl + Shift + F3 | ⌘ + Shift + F3 |
| Define Name dialog box | Ctrl + F3 | ⌘ + F3 |
Pivot Table Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Display Insert Pivot Table dialog box | Alt, N, V | ⌘ + Option + V |
| Open Pivot Table Wizard | Alt, D, P | ⌘ + Option + P |
| Select entire Pivot Table (excluding Report Filters) | Ctrl + A | ⌘ + A |
| Add/remove checkmark for selected field in PivotTable Field List | Space | Space |
| Group selected Pivot Table items | Alt + Shift + → | ⌘ + Option + → |
| UnGroup Pivot Table items | Alt + Shift + ← | ⌘ + Option + ← |
| Select the next item in PivotTable Field List or Items List | ↓ | ↓ |
| Select the previous item in PivotTable Field List or Items List | ↑ | ↑ |
| Select last visible item in list | End | End |
| Select first visible item in list | Home | Home |
| Open Field List for active cell | Alt + ↓ | ⌘ + ↓ |
| Hide selected item or field | Ctrl + – | ⌘ + – |
| Opens Calculated Field dialog box (when the data field is selected) | Shift + Ctrl + = | Shift + ⌘ + = |
| Opens Calculated Item dialog box (when field heading cell is selected) | Shift + Ctrl + = | Shift + ⌘ + = |
Others Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Restore Window to Its Original Size | Ctrl + F5 | ⌘ + F5 |
| Move the Active Window | Ctrl + F7 | ⌘ + F7 |
| Resize the Active Window | Ctrl + F8 | ⌘ + F8 |
| Switch to the Previous Window | Ctrl + Shift + F6 | ⌘ + Shift + F6 |
| Navigate to the Next Pane | F6 | ⌘ + F6 |
| Navigate to the Previous Pane | F8 | ⌘ + F8 |
| Enable Extend Selection Mode | Shift + F10 | Shift + F10 |
| Open Context Menu | Shift + F6 | Shift + F6 |
| Activate Add to Selection Mode | Shift + F8 | Shift + F8 |
VBA Shortcuts
| Description | Windows Shortcut | Mac Shortcut |
|---|
| Opens the VBA editor and switches between Excel Worksheet and the VBA editor | Alt + F11 | ⌘ + Option + F11 |
| Open VB Help | F1 | F1 |
| View Object Browser | F2 | F2 |
| View Properties | F4 | F4 |
| View Code window | F7 | F7 |
| View Immediate window | Ctrl + G | ⌘ + Option + G |
| View Shortcut Menu | Shift + F10 | Shift + F10 |
| Run a Sub/UserForm | F5 | F5 |
| Step Into the code | F8 | F8 |
| Step Over | Shift + F8 | Shift + F8 |
| Step Out | Ctrl + Shift + F8 | ⌘ + Shift + F8 |
| Run to Cursor | Ctrl + F8 | ⌘ + F8 |
| Toggle Breakpoint | F9 | F9 |
| Clear All Breakpoints | Ctrl + F9 | ⌘ + Option + F9 |
| Close VBA Editor and return to the Excel Worksheet | Alt + Q | ⌘ + Q |
