Excel Keyboard Shortcuts List
This page contains a list of over 270 Excel shortcuts for both the keyboard & mouse, including shortcuts for the Windows, Mac, and Web versions of Excel. You can download a printable PDF version of the list below.
How to Press the Shortcut Keys
There are two ways to press the shortcut keys depending on the separator character used in the sequence.
+ Plus
The + (plus) between keys means press & hold the keys together in order. For example, to press the shortcut Ctrl+Shift+L to Toggle Filters, you will:
Press & hold Ctrl, then press & hold Shift, then press L. Then release all keys.
, Comma
The , (comma) between keys means press & release each key in order. For example, to press the shortcut Alt,E,S to open Paste Special, you will:
Press & release Alt, then press & release E, then press & release S.
Laptop Keyboards
If you are using a laptop keyboard then you might be limited on the some of the shortcuts you can press. Laptop keyboards tend to have smaller keyboards and don't always contain keys like Page Up, Page Down, Menu, etc.
You might also need to press the Fn (function) key in combination with the function keys F1 to F12. Some laptops have Fn Lock Mode so that you don't have to press Fn with the the function keys.
Checkout our post on the Best Keyboards for Excel Keyboard Shortcuts to learn more.
How to Use & Search This Page
The shortcuts are divided into different sections based categories of where the shortcut is used (cells, worksheets, workbooks, etc.). Some sections have additional sub sections based on different actions/tasks (navigating, writing formulas, formatting, etc.).
The Table of Contents in the right sidebar can be used to navigate to each section of the page. You can also press Ctrl+F to open your browser's Find box in the top-right corner of the browser window. Then type a search to find a specific shortcut you are looking for. You can leave a comment at the bottom of the page with any questions or suggestions.
The shortcuts are divided into different sections based categories of where the shortcut is used (cells, worksheets, workbooks, etc.). Some sections have additional sub sections based on different actions/tasks (navigating, writing formulas, formatting, etc.).
The Table of Contents below can be used to navigate to each section of the page. You can also use your browser's Find box (found in the settings of Chrome and Safari) to find a specific shortcut you are looking for. Please leave a comment at the bottom of the page with any questions or suggestions.
Download the PDF Version
Click the link below to get a free printable PDF version of this page with over 270 Excel Shortcuts.
Excel Shortcuts List.pdf (338 KB)
Cells, Ranges, Rows, & Columns
We spend most of our time working in the Excel grid. Therefore, this section contains the most shortcuts for tasks like navigating & selecting ranges, editing formulas, formatting cells, modifying rows & columns, and more.
The section is broken down into sub sections by task/action to make it easier to navigate and learn the various shortcuts.
Navigating The Grid
These shortcuts will help you navigate around the cells on a worksheet faster. If you ever find yourself spending extra time scrolling a long worksheet with the mouse, then these shortcuts will save a ton of time.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Select the first visible cell in the sheet (or bottom-right of freeze panes) | Ctrl+Home | Fn+Ctrl+← | Ctrl+Home |
| Select the last used cell in the sheet | Ctrl+End | Fn+Ctrl+→ | Ctrl+End |
| Select first cell in the row of the active cell | Home | Fn+← | Home |
| Turn on End Mode (similar to Ctrl+Arrow Keys) | End | Fn+→ | End |
| Select the first/last cell of a region (non-blank cells) moving up | Ctrl+↑ | Ctrl+↑ | Ctrl+↑ |
| Select the first/last cell of a region (non-blank cells) moving right | Ctrl+→ | Ctrl+→ | Ctrl+→ |
| Select the first/last cell of a region (non-blank cells) moving down | Ctrl+↓ | Ctrl+↓ | Ctrl+↓ |
| Select the first/last cell of a region (non-blank cells) moving left | Ctrl+← | Ctrl+← | Ctrl+← |
| Select cell one screen down from the active cell | PgDn | Fn+↓ | PgDn |
| Select cell one screen up from the active cell | PgUp | Fn+↑ | PgUp |
| Select cell one screen to the right of the active cell | Alt+PgDn | Fn+Alt+↓ | |
| Select cell one screen to the left of the active cell | Alt+PgUp | Fn+Alt+↑ | |
| Move one cell up | ↑ | ↑ | ↑ |
| Move one cell right | → | → | → |
| Move one cell down | ↓ | ↓ | ↓ |
| Move one cell left | ← | ← | ← |
| Go back to hyperlink | Ctrl+G,Enter | Ctrl+G,Return | |
| Open the Find window | Ctrl+F | Cmd+F | Ctrl+F |
| Open the Find & Replace window | Ctrl+H | Ctrl+H | Ctrl+H |
| Find next match | Shift+F4 | Cmd+G | Shift+F4 |
| Find previous match | Ctrl+Shift+F4 | Cmd+Shift+G | Ctrl+Shift+F4 |
Writing Formulas
| Begin entering a formula | = OR + | = OR + | = OR + |
| Insert function into formula with autocomplete | Tab | ↓Tab | Tab |
| Edit the active cell | F2 | Ctrl+U | F2 |
| Toggle Enter and Edit modes while editing formula | F2 | Ctrl+U | F2 |
| Exit cell edit mode | Esc | Esc | Esc |
| Toggle absolute and relative references | F4 | Cmd+T | F4 |
| AutoSum | Alt+= | Cmd+Shift+T | Alt+= |
| Open Function Arguments window (when text cursor is inside function) | Ctrl+A | Ctrl+A | |
| Open the Insert Function window | Shift+F3 | Fn+Shift+F3 | Shift+F3 |
| Show Formulas instead of Values in cells (toggle) | Ctrl+` or Ctrl+~ | Ctrl+` | |
| Expand or collapse the formula bar | Ctrl+Shift+U | Ctrl+Shift+U | |
| Calculate worksheets | F9 | Fn+F9 | F9 |
| Calculate active worksheet | Shift+F9 | Fn+Shift+F9 | |
| Calculate entire workbook | Ctrl+Alt+F9 | Ctrl+Shift+Alt+F9 | |
| Insert name into formula | F3 | ||
| Open Name Manager window | Ctrl+F3 | Fn+Ctrl+F3 | |
| Open Create Names From Selection window | Ctrl+Shift+F3 | Fn+Ctrl+Shift+F3 | |
| Set focus on Name Box | Alt+F3 | ||
| Enter array formula | Ctrl+Shift+Enter | Ctrl+Shift+Return | |
| Evaluate selected text in a formula | F9 | Fn+F9 | F9 |
| Insert function arguments | Ctrl+Shift+A | Ctrl+Shift+A | Ctrl+Shift+A |
Entering Data
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Open AutoComplete dropdown list | Alt+↓ | Alt+↓ | Alt+↓ |
| Enter and move to next cell (based on direction set in Excel Options) | Enter | Return | Enter |
| Enter and move to previous cell (based on direction set in Excel Options) | Shift+Enter | Shift+Return | Shift+Enter |
| Enter and move right | Tab | Tab | Tab |
| Enter and move left | Shift+Tab | Shift+Tab | Shift+Tab |
| Insert current date | Ctrl+; | Ctrl+; | Ctrl+; |
| Insert current time | Ctrl+Shift+: | Cmd+; | |
| Copy formula from cell above | Ctrl+' | Ctrl+' | Ctrl+' |
| Fill down from cell above | Ctrl+D | Ctrl+D | |
| Fill right | Ctrl+R | Ctrl+R | |
| Flash fill | Ctrl+E | Ctrl+E | |
| Stay in same cell when editing cell when single cell is selected | Ctrl+Enter | Ctrl+Return | Ctrl+Enter |
| Copy data or formula to all selected cells when editing cell | Ctrl+Enter | Ctrl+Return | Ctrl+Enter |
| Copy value (result of formula) from cell above | Ctrl+Shift+" | Ctrl+Shift+" |
Editing Text
These shortcuts can be used in all areas of Excel where you are editing text. They can also be used in other applications and when writing code or formulas.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Enter a line break (new line) in a cell | Alt+Enter | Ctrl+Alt+Return | Alt+Enter |
| Delete character to the left of cursor | Backspace | Delete | Backspace |
| Delete character to the right of cursor | Delete | Fn+Delete | Delete |
| Delete to end of line | Ctrl+Delete | Ctrl+Delete | Ctrl+Delete |
| Move text cursor one word to the right | Ctrl+→ | Ctrl+→ | Ctrl+→ |
| Move text cursor one word to the left | Ctrl+← | Ctrl+← | Ctrl+← |
| Select one word right | Ctrl+Shift+→ | Ctrl+Shift+→ | Ctrl+Shift+→ |
| Select one word left | Ctrl+Shift+← | Ctrl+Shift+← | Ctrl+Shift+← |
| Select one character right | Shift+→ | Shift+→ | Shift+→ |
| Select one character left | Shift+← | Shift+← | Shift+← |
| Select to beginning of cell | Shift+Home | Fn+Shift+← | Shift+Home |
| Select to end of the text/formula | Shift+End | Fn+Shift+→ | Shift+End |
Number Formatting
These shortcuts allow you to quickly apply number formats to a cell or range. You use the number keys above the letters on the keyboard to press the shortcuts.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Apply General format to selected cells | Ctrl+Shift+~ | Ctrl+Shift+~ | |
| Apply Number format to selected cells | Ctrl+Shift+! | Ctrl+Shift+! | |
| Apply Date format to selected cells | Ctrl+Shift+# | Ctrl+Shift+# | |
| Apply Currency format to selected cells | Ctrl+Shift+$ | Ctrl+Shift+$ | |
| Apply Percent format/style to selected cells | Ctrl+Shift+% | Ctrl+Shift+% | |
| Apply Time format to selected cells | Ctrl+Shift+@ | Ctrl+Shift+@ | |
| Apply Scientific format to selected cells | Ctrl+Shift+^ | Ctrl+Shift+^ | |
| Modify Cell Style of the active cell | Alt+' | Cmd+Shift+L |
Cell & Font Formatting
These are shortcuts for many of the buttons in the Font and Alignment groups on the Home tab of the Ribbon.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Remove indent | Alt,H,5 | Ctrl+Alt+Shift+Tab | |
| Indent | Alt,H,6 | Ctrl+Alt+Tab | |
| Left Align | Alt,H,A,L | Cmd+L | |
| Center Align | Alt,H,A,C | Cmd+E | |
| Right Align | Alt,H,A,R | Cmd+R | |
| Top Align | Alt,H,A,T | ||
| Middle Align | Alt,H,A,M | ||
| Bottom Align | Alt,H,A,B | ||
| Increase Font Size | Alt,H,F,G | Cmd+Shift+> | Ctrl+Shift+> |
| Decrease Font Size | Alt,H,F,K | Cmd+Shift+< | Ctrl+Shift+< |
| Wrap Text | Alt,H,W | ||
| Format Window for cells and objects | Ctrl+1 | Cmd+1 | Ctrl+1 |
| Apply or remove bold formatting | Ctrl+B | Cmd+B | Ctrl+B |
| Apply or remove italic formatting | Ctrl+I | Cmd+I | Ctrl+I |
| Apply or remove underscoring | Ctrl+U | Cmd+U | Ctrl+U |
| Apply or remove strikethrough formatting | Ctrl+5 | Cmd+Shift+X | |
| Display Format Cells with Font tab selected | Ctrl+Shift+F | Ctrl+Shift+F | |
| Insert or edit Cell Note | Shift+F2 | Fn+Shift+F2 | |
| Insert or reply to Cell Comment | Ctrl+Shift+F2 | Fn+Ctrl+Shift+F2 | Shift+F2 |
| Delete comment | Shift+F10,M | ||
| Add hyperlink | Ctrl+K | Cmd+K | Ctrl+K |
Rows & Columns
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Select all cells in worksheet (unless active cell is in a Table) | Ctrl+A | Cmd+A | |
| Select entire row | Shift+Space | Shift+Space | Shift+Space |
| Select entire column | Ctrl+Space | Ctrl+Space | Ctrl+Space |
| Add non-adjacent cells to selection | Ctrl+Click | Cmd+Click | |
| Add adjacent cells to selection | Shift+Click | Shift+Click | |
| Toggle Add or Remove Selection Mode | Shift+F8 | Fn+Shift+F8 | Shift+F8 |
| Same selection in next column | Opt+Tab | ||
| Same selection in previous column | Opt+Shift+Tab | ||
| Move right between non-adjacent selections | Ctrl+Alt+→ | ||
| Move left between non-adjacent selections | Ctrl+Alt+← | ||
| Open Insert window | Ctrl++ | Ctrl++ | |
| Insert rows (with rows selected) | Ctrl++ | Ctrl++ | |
| Insert columns (with columns selected) | Ctrl++ | Ctrl++ | |
| Open Delete window | Ctrl+- | Cmd+- | Ctrl+- |
| Delete rows (with rows selected) | Ctrl+- | Cmd+- | Ctrl+- |
| Delete columns (with columns selected) | Ctrl+- | Cmd+- | Ctrl+- |
| Delete cells (with cells selected) | Ctrl+- | Cmd+- | Ctrl+- |
| AutoFit Column Width | Alt,H,O,I | Alt,H,O,I | |
| AutoFit Row Height | Alt,H,O,A | Alt,H,O,A |
Group & Hide
These shortcuts cover the basics of hiding and unhiding rows & columns. The Group and Outline features in Excel make hiding and unhiding rows & columns fast and easy.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Group rows or columns (with rows/columns selected) | Shift+Alt+→ | Cmd+Shift+K | |
| Ungroup rows or columns (with rows/columns selected) | Shift+Alt+← | Cmd+Shift+J | |
| Open Group window (with cell or range selected) | Shift+Alt+→ | Cmd+Shift+K | |
| Open Ungroup window (with cell or range selected) | Shift+Alt+← | Cmd+Shift+J | |
| Hide or show outline symbols | Ctrl+8 | Ctrl+8 | |
| Hide rows | Ctrl+9 | Ctrl+9 | Ctrl+9 |
| Hide columns | Ctrl+0 | Ctrl+0 | Ctrl+0 |
| Unhide rows | Ctrl+Shift+9 | Ctrl+Shift+9 | Ctrl+Shift+9 |
| Unhide columns | Ctrl+Shift+0 | Ctrl+Shift+0 | Ctrl+Shift+0 |
| Unhide columns (Alternate: Ctrl+Shift+0 does not work on some versions of Windows) | Alt,H,O,U,L |
Active Cell
These shortcuts allow you to change the active cell within a selected range. When you have multiple cells selected you can perform tasks like copying down/right (Ctrl+D or Ctrl+R) from the active cell.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Activate next cell in selected range (based on direction set in Excel Options) | Enter | Return | Enter |
| Activate next cell to right/below in selected range | Tab | Tab | Tab |
| Activate each corner cell in selected range in clockwise direction | Ctrl+. | Ctrl+. | Ctrl+. |
| Activate previous cell in selection (based on direction set in Excel Options) | Shift+Enter | Shift+Return | Shift+Enter |
| Activate previous cell to left/above in selected range | Shift+Tab | Shift+Tab | Shift+Tab |
| Scroll active cell into view | Ctrl+Backspace | Cmd+Delete | Ctrl+Backspace |
| Select single (active) cell when range is selected | Shift+Backspace | Shift+Delete | Shift+Backspace |
Extend Selection
These shortcuts allow you to include more or less cells in the selected range.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Extend selection by one cell up | Shift+↑ | Shift+↑ | |
| Extend selection by one cell right | Shift+→ | Shift+→ | Shift+→ |
| Extend selection by one cell down | Shift+↓ | Shift+↓ | |
| Extend selection by one cell left | Shift+← | Shift+← | Shift+← |
| Extend the selection to the last cell up | Ctrl+Shift+↑ | Ctrl+Shift+↑ | |
| Extend the selection to the last cell right | Ctrl+Shift+→ | Ctrl+Shift+→ | |
| Extend the selection to the last cell down | Ctrl+Shift+↓ | Ctrl+Shift+↓ | |
| Extend the selection to the last cell left | Ctrl+Shift+← | Ctrl+Shift+← | |
| Extend selection to first cell in worksheet | Ctrl+Shift+Home | Fn+Ctrl+Shift+← | Ctrl+Shift+Home |
| Extend selection to last cell in worksheet | Ctrl+Shift+End | Fn+Ctrl+Shift+→ | Ctrl+Shift+End |
| Extend selection right one screen | Shift+Alt+PgDn | Fn+Shift+Alt+↓ | |
| Extend selection left one screen | Shift+Alt+PgUp | Fn+Shift+Alt+↑ | |
| Extend selection to start of row | Shift+Home | Fn+Shift+← | Shift+Home |
| Extend selection down one screen | Shift+PgDn | Fn+Shift+↓ | |
| Extend selection up one screen | Shift+PgUp | Fn+Shift+↑ | |
| Toggle extend selection mode | F8 | Fn+F8 | |
| Select Spill Range | Ctrl+A |
Select Special Cells
Specials Cells are cells with common characteristics like blanks, formulas, numbers, visible cells, etc. Selecting common types of cells can make it easier to then apply formatting or modify them.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Open the Go To window | F5 OR Ctrl+G | Ctrl+G | Ctrl+G |
| Open the Go To Special window | Alt,H,F,D,S OR F5,Alt,S | ||
| Select visible cells only (when range is selected) | Alt+; | Cmd+Shift+Z | |
| Select current region | Ctrl+A | Cmd+A | |
| Select current region around active cell | Ctrl+Shift+8 | Shift+Ctrl+Space | |
| Select current array | Ctrl+/ | Ctrl+/ | |
| Select row differences | Ctrl+ | Ctrl+ | |
| Select column differences | Ctrl+Shift+ | Ctrl+Shift+ | |
| Select direct dependents | Ctrl+] | Ctrl+] | |
| Select direct precedents | Ctrl+[ | Ctrl+[ | |
| Select all precedents | Ctrl+Shift+{ | Ctrl+Shift+{ | |
| Select all dependents | Ctrl+Shift+} | Ctrl+Shift+} | |
| Select cells with comments | Ctrl+Shift+O | Fn+Ctrl+Shift+O |
Copy & Move with the Mouse
These shortcuts use the mouse to move & copy cells. The word "Drag" means to left-click and hold the border of the cell or range, then drag it.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Copy selected range or shape | Ctrl+Drag | Alt+Drag | |
| Insert copy of selected range (moves existing cells) | Ctrl+Shift+Drag | Alt+Shift+Drag | |
| Drag and cut | Drag | Drag | |
| Cut and paste selected range (moves existing cells) | Shift+Drag | Shift+Drag | |
| Move selected range to another worksheet | Alt+Drag | Cmd+Drag |
Zoom & Scroll
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Zoom in | Ctrl+Alt++ | Alt+Cmd++ | Ctrl+Alt++ |
| Zoom out | Ctrl+Alt+- | Alt+Cmd+- | Ctrl+Alt+- |
| Zoom in (with mouse) | Ctrl+Scroll Up | Ctrl+Scroll Up | Ctrl+Scroll Up |
| Zoom out (with mouse) | Ctrl+Scroll Down | Ctrl+Scroll Down | Ctrl+Scroll Down |
| Zoom to Selection | Alt,W,G | ||
| Zoom to Selection | Alt,W,J | ||
| Toggle Scroll Lock on/off | ScrLk | Fn+Shift+F14 | |
| Toggle Gridlines on/off | Alt,W,V,G | ||
| Toggle Freeze Panes on/off | Alt,W,F,F |
Cell Borders
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Add Outside Borders to selected cell/range | Ctrl+Shift+& | Cmd+Alt+0 | Ctrl+Shift+& |
| Remove all borders (apply No Borders) to selection | Ctrl+Shift+_ | Cmd+Alt+_ | |
| Open Border dropdown menu on Home Tab | Alt,H,B | Alt,H,B | |
| Add all borders to cells in selected range | Alt,H,B,A | ||
| Add or remove Bottom Border | Alt,H,B,O | Cmd+Alt+↓ | |
| Add or remove Top Border | Alt,H,B,P | Cmd+Alt+↑ | |
| Add or remove Left Border | Alt,H,B,L | Cmd+Alt+← | |
| Add or remove Right Border | Alt,H,B,R | Cmd+Alt+→ | |
| Open Borders tab in Format Cells window (More Borders) | Alt,H,B,M |
Download the PDF File
Get a printable PDF version of this page with over 270 Excel Shortcuts.
Worksheet Tabs
These shortcuts help you navigate, copy, and perform actions on the sheet tabs in the workbook.
Checkout our Tab Hound Add-in if you want a way to quickly search and jump to the sheets in large workbooks. Tab Hound is packed with productivity features that will save you a ton of time with everyday tasks.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Insert new worksheet | Shift+F11 | Fn+Shift+F11 | Shift+F11 |
| Delete selected worksheets | Alt,E,L | Alt,H,D,S | |
| Rename current worksheet | Alt,O,H,R | ||
| Go to next worksheet | Ctrl+PgDn | Fn+Ctrl+↓ | Ctrl+Alt+PgDn |
| Go to previous worksheet | Ctrl+PgUp | Fn+Ctrl+↑ | Ctrl+Alt+PgUp |
| Select adjacent worksheets | Ctrl+Shift+PgUp/PgDn | ||
| Select adjacent worksheets (mouse) | Shift+Click | Shift+Click | |
| Select non-adjacent worksheets (mouse) | Ctrl+Click | Cmd+Click | |
| Open Move or Copy window for selected sheets | Alt,E,M | ||
| Duplicate worksheet (mouse) | Ctrl+drag | Alt+drag | |
| Protect or Unprotect Sheet | Alt,R,P,S | ||
| Clear print area | Alt,P,R,C | ||
| Set print area | Alt,P,R,S |
Workbooks
These shortcuts help with creating, opening, saving, closing, protecting, and viewing files. Shortcuts for workbook level tasks like Spell Check and Thesaurus are also included.
File Open, Close, Save
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Create new workbook | Ctrl+N | Cmd+N | |
| Open workbook | Ctrl+O | Cmd+O | Ctrl+O |
| Save workbook | Ctrl+S | Cmd+S | |
| Save as | F12 | Cmd+Shift+S | Alt+F2 |
| Close current workbook | Ctrl+F4 OR Ctrl+W | Cmd+W | Ctrl+W |
| Close Excel | Alt+F4 | Cmd+Q |
Workbook Actions & Options
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Undo last action | Ctrl+Z | Cmd+Z | Ctrl+Z |
| Redo last action | Ctrl+Y | Cmd+Y | Ctrl+Y |
| Repeat last action | F4 | Cmd+Y | F4 |
| Open Excel Options window | Alt,F,T | Cmd+, | |
| Open help | F1 | Cmd+/ | |
| Tell Me | Alt+Q | ||
| Open the Control Menu (minimize, maximize, close window) | Alt+Space | ||
| Open Spelling window (Spell Check) | F7 | Fn+F7 | |
| Open Thesaurus dialog box | Shift+F7 | Fn+Shift+F7 | |
| Open Right-click menu | Shift+F10 OR Menu Key | Fn+Shift+F10 | |
| Move to next pane in application window | F6 | Fn+F6 | |
| Move to previous pane | Shift+F6 | Fn+Shift+F6 | |
| Protect and Unprotect Workbook | Alt,R,P,W |
Workbook View Settings
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Minimize current workbook window | Ctrl+F9 | Cmd+M | |
| Maximize or Restore current workbook window (toggle) | Ctrl+F10 | Fn+Ctrl+F10 | |
| Toggle full screen | Ctrl+Shift+F1 | Ctrl+Cmd+F | |
| Go to previous workbook | Ctrl+Shift+Tab | Cmd+Shift+` | |
| Go to next workbook | Ctrl+Tab | Cmd+` | |
| Open current workbook in Desktop Excel Application | Alt+O |
Tables & Filters
Excel Tables are an awesome feature of Excel that can save us a lot of time. Using shortcuts to filter, navigate, and select data can make our jobs even faster.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Insert Table | Ctrl+T | Ctrl+T | Ctrl+L OR Ctrl+Alt+T |
| Insert Table (select style first) | Alt,H,T | ||
| Insert a row above the current row | Alt,H, I, R | Alt,H, I, R | |
| Insert a column to the left of the current column | Alt,H, I, C | Alt,H, I, C | |
| Select Table Body (Press again to include Headers) | Ctrl+A | Cmd+A | |
| Select Table row | Shift+Space | Shift+Space | Shift+Space |
| Select Table column | Ctrl+Space | Ctrl+Space | Ctrl+Space |
| Toggle Autofilter on/off | Ctrl+Shift+L | Cmd+Shift+F | Ctrl+Shift+L |
| Open Filter Dropdown Menu (with header cell selected) | Alt+↓ | Alt+↓ | Alt+↓ |
| Open Filter Dropdown Menu (from any cell in a Table) | Shift+Alt+↓ | Shift+Alt+↓ | Shift+Alt+↓ |
| Toggle Total Row on/off | Ctrl+Shift+T | Cmd+Shift+T | |
| Clear slicer filter (with slicer selected) | Alt+C | Alt+C |
Charts & Shapes
These shortcuts help with creating and formatting charts & shapes.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Create chart or PivotChart on same worksheet | Alt+F1 | Fn+Alt+F1 | Alt+F1 |
| Create chart in new ChartSheet | F11 | Fn+F11 | |
| Open Format Chart Area Task Pane | Ctrl+1 | Cmd+1 | |
| Show or Hide All Field Buttons on PivotChart | Alt,J,T,D,A | ||
| Snap to grid | Alt | Cmd+ | |
| Hide or show objects (shapes, charts, slicers) | Ctrl+6 | Ctrl+6 |
Copy & Paste Objects
Copy & paste is one of the most common tasks we do in Excel. These shortcuts apply to all objects (shapes, charts, slicers), not just cells & ranges.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Copy selected object (cells, range, shape) | Ctrl+C | Cmd+C | Ctrl+C |
| Cut selected object | Ctrl+X | Cmd+X | Ctrl+X |
| Paste content from clipboard | Ctrl+V | Cmd+V | Ctrl+V |
| Open the Paste Special window | Ctrl+Alt+V | Cmd+Ctrl+V | |
| Duplicate selected object (shapes, charts, slicers) | Ctrl+D | Cmd+D | |
| Copy selected objects (mouse) | Ctrl+Drag | Cmd+Drag | |
| Copy selected objects and retain vertical or horizontal alignment (mouse) | Ctrl+Shift+Drag | Cmd+Shift+Drag | |
| Copy selected objects (mouse right-click) | Right-click+Drag | Right-click+Drag | |
| Copy selected objects and retain vertical or horizontal alignment (right-click mouse) | Right-click+Shift+Drag | Right-click+Shift+Drag |
Pivot Tables
We mostly use the mouse to create and modify pivot tables due to their drag & drop functionality. However, there are some great keyboard shortcuts that will save you time when working with pivot tables.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Insert Pivot Table | Alt,N,V | ||
| Refresh Pivot Table or Query | Alt+F5 | Alt+F5 | |
| Refresh All | Ctrl+Alt+F5 | Ctrl+Alt+F5 | |
| Open pivot table wizard | Alt,D,P | Cmd+Alt+P | |
| Select entire pivot table | Ctrl+A | Cmd+A | |
| Group pivot table items | Shift+Alt+→ | Cmd+Shift+K | |
| Ungroup pivot table items | Shift+Alt+← | Cmd+Shift+J | |
| Unhide (clear filter on) pivot table item | Alt,H,S,C | ||
| Filter out (exclude/hide) pivot item | Ctrl+- | Ctrl- | Ctrl+- |
| Open Filter Dropdown Menu in Pivot Table cells | Alt+↓ | Alt+↓ | Alt+↓ |
| Toggle pivot table field checkbox | Space | Space | |
| Insert pivot chart | Alt+F1 | Fn+Alt+F1 | Alt+F1 |
| Create pivot chart on new Chart Sheet | F11 | Fn+F11 |
Ribbon
The Excel Ribbon is the command bar at the top of the application window that contains all the buttons we commonly press to perform actions.
The Ribbon contains various tabs starting with the File and Home tabs. These shortcuts allow you to access the Ribbon tabs and buttons.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Activate Ribbon shortcut keys | Alt OR Shift+F6 | Alt OR Win+Alt | |
| Move to next ribbon control | Tab | Tab | Tab |
| Move through Ribbon tabs and groups | → ← ↑ ↓ | → ← ↑ ↓ | |
| Open dropdown menu of selected button | Alt+↓ | Alt+↓ | |
| Open help window for selected control | F1 | ||
| Expand or collapse ribbon | Ctrl+F1 | Cmd+Alt+R |
Macros & VBA
One of my favorite features of Excel is VBA. VBA is the name of the programming language used to write macros, which help us automate common processes to save even more time. These shortcuts help you access the VB Editor and run macros.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Open the VB Editor window (VBA) | Alt+F11 | Fn+Alt+F11 | |
| Open the Macro window (run or edit macro) | Alt+F8 | Fn+Alt+F8 | |
| Record Macro | Alt,L,R | ||
| Open Excel Add-ins Window | Alt,L,R | ||
| Open COM Add-ins Window | Alt,L,J |
We also have a VBA Shortcuts Guide that contains over 25 keyboard shortcuts for the VB Editor. It includes shortcuts for Windows and Mac.
Navigating Windows & Dialog Boxes
The pop-up windows that we interact with in Excel and Office applications are commonly referred to as Dialog Boxes. For example, pressing Ctrl+1 will open the Format Cells Window (Dialog Box).
The shortcuts in this section cover how to navigate those windows with the keyboard.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Move to next tab | Ctrl+Tab | Ctrl+Tab | |
| Move to previous tab | Ctrl+Shift+Tab | Ctrl+Shift+Tab | |
| Move to next control or button | Tab | Tab | Tab |
| Move to previous control or button | Shift+Tab | Shift+Tab | Shift+Tab |
| Press selected control or button | Enter | Return | Enter |
| Check and uncheck checkboxes | Space | Space | |
| Close the window or dialog box | Esc | Esc | Esc |
Power Query
Power Query is an amazing data automation tool that is now a part of Excel. These shortcuts will help you open the Power Query Editor, navigate the menus and columns, and quickly apply transformations.
Checkout our post & video on a Beginner's Guide to Power Query if you're not using it yet. And here is a video and post on the 15 Shortcuts for Power Query listed below.
Note: Power Query is only available on the Windows Desktop version of Excel at this time.
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Open the Power Query Editor | Alt+F12 or Alt,A,P,L,N | ||
| Press any button in the Power Query Ribbon | Alt, Letter Sequence | ||
| Quick Access Toolbar in Power Query | Alt+Number | ||
| Rename Column | F2 | ||
| Remove Column(s) | Delete | ||
| Undo Last Action | Tab (6 times), Delete | ||
| Select All Columns | Ctrl+A | ||
| Select First Column | Home | ||
| Select Last Column | End | ||
| Select Multiple Adjacent Columns | Shift+→ or ← | ||
| Select Multiple Non-Adjacent Columns | Ctrl+→ or ←, Space | ||
| Open Filter Drop-down Menu | Alt+↓ | ||
| Open Right-click Menus | Menu Key | ||
| Open Table Options Menu | Select First Column,← ,Space | ||
| Select Task Panes & Ribbon | Tab & Shift+Tab | ||
| Close Power Query Window | Alt+F4 | ||
| Close & Load | Alt,F,Enter |
Download the PDF File
Get a printable PDF version of this page with over 270 Excel Shortcuts.
Comments
Please leave a comment below with suggestions for any shortcuts we missed, or ways to improve this page. We will continue to update the page based on your feedback. Thanks!
© 2025 EXCEL CAMPUS. ALL RIGHTS RESERVED.