Excel Shortcuts Cheat Sheet
Over 100 Excel keyboard shortcuts that actually save time, grouped by what you are doing, with the Windows and Mac keys side by side. Read it here, or grab the printable PDF below and keep it next to your keyboard.
The shortcuts, by what you are doing
Navigation
| What it does | Windows | Mac |
|---|---|---|
| Jump to the edge of your data | Ctrl + Arrow | Cmd + Arrow |
| Go back to cell A1 | Ctrl + Home | Fn + Ctrl + Left |
| Jump to the last used cell | Ctrl + End | Fn + Ctrl + Right |
| Move to the start of the row | Home | Fn + Left |
| Move one screen down | Page Down | Fn + Down |
| Move one screen right | Alt + Page Down | Fn + Option + Down |
| Open the Go To box | Ctrl + G | Ctrl + G |
| Move to the next worksheet | Ctrl + Page Down | Option + Right |
| Move to the previous worksheet | Ctrl + Page Up | Option + Left |
| Switch between open workbooks | Ctrl + Tab | Cmd + ` |
| Move around inside a selection | Tab / Shift + Tab | Tab / Shift + Tab |
Selection
| What it does | Windows | Mac |
|---|---|---|
| Extend the selection to the edge of the data | Ctrl + Shift + Arrow | Cmd + Shift + Arrow |
| Extend the selection one cell | Shift + Arrow | Shift + Arrow |
| Select the current region, press again for the whole sheet | Ctrl + A | Cmd + A |
| Select the whole row | Shift + Space | Shift + Space |
| Select the whole column | Ctrl + Space | Ctrl + Space |
| Select the entire worksheet | Ctrl + Shift + Space | Cmd + A |
| Select to the last used cell | Ctrl + Shift + End | Fn + Ctrl + Shift + Right |
| Select back to cell A1 | Ctrl + Shift + Home | Fn + Ctrl + Shift + Left |
| Extend the selection one screen | Shift + Page Down | Fn + Shift + Down |
| Add non-adjacent cells to a selection | Ctrl + click | Cmd + click |
| Select only the visible cells | Alt + ; | Home, Find and Select, Go To Special |
| Select the whole array the cell belongs to | Ctrl + / | Ctrl + / |
Editing
| What it does | Windows | Mac |
|---|---|---|
| Edit the active cell in place | F2 | Ctrl + U |
| Undo | Ctrl + Z | Cmd + Z |
| Redo | Ctrl + Y | Cmd + Y |
| Copy | Ctrl + C | Cmd + C |
| Cut | Ctrl + X | Cmd + X |
| Paste | Ctrl + V | Cmd + V |
| Paste Special (values, formats, or formulas only) | Ctrl + Alt + V | Ctrl + Cmd + V |
| Fill down from the cell above | Ctrl + D | Cmd + D |
| Fill right from the cell to the left | Ctrl + R | Cmd + R |
| Fill every selected cell with one entry | Ctrl + Enter | Ctrl + Return |
| Start a new line inside a cell | Alt + Enter | Ctrl + Option + Return |
| Insert today's date | Ctrl + ; | Ctrl + ; |
| Insert the current time | Ctrl + Shift + : | Cmd + ; |
| Repeat the last action | F4 | Cmd + Y |
| Flash Fill the rest of the column from your pattern | Ctrl + E | Ctrl + E |
| Clear the contents of the selection | Delete | Delete |
| Cancel what you are typing | Esc | Esc |
Formatting
| What it does | Windows | Mac |
|---|---|---|
| Bold | Ctrl + B | Cmd + B |
| Italic | Ctrl + I | Cmd + I |
| Underline | Ctrl + U | Cmd + U |
| Strikethrough | Ctrl + 5 | Cmd + Shift + X |
| Open the Format Cells dialog | Ctrl + 1 | Cmd + 1 |
| Apply the General number format | Ctrl + Shift + ~ | Ctrl + Shift + ~ |
| Apply currency format | Ctrl + Shift + $ | Ctrl + Shift + $ |
| Apply percent format | Ctrl + Shift + % | Ctrl + Shift + % |
| Apply comma format with two decimals | Ctrl + Shift + ! | Ctrl + Shift + ! |
| Apply date format | Ctrl + Shift + # | Ctrl + Shift + # |
| Apply time format | Ctrl + Shift + @ | Ctrl + Shift + @ |
| Apply scientific format | Ctrl + Shift + ^ | Ctrl + Shift + ^ |
| Add an outline border to the selection | Ctrl + Shift + & | Cmd + Option + 0 |
| Remove all borders | Ctrl + Shift + _ | Cmd + Option + - |
| Fill cells with color | Alt + H, H | Home, Fill Color |
| Open the conditional formatting menu | Alt + H, L | Home, Conditional Formatting |
Formulas & auditing
| What it does | Windows | Mac |
|---|---|---|
| AutoSum the cells above or to the left | Alt + = | Cmd + Shift + T |
| Lock a reference, cycling $A$1, A$1, $A1, A1 | F4 | Cmd + T |
| Show every formula on the sheet | Ctrl + ` | Ctrl + ` |
| Recalculate the whole workbook | F9 | Fn + F9 |
| Recalculate the active sheet only | Shift + F9 | Fn + Shift + F9 |
| Open the Insert Function wizard | Shift + F3 | Fn + Shift + F3 |
| Paste a defined name into a formula | F3 | Fn + F3 |
| Open the Name Manager | Ctrl + F3 | Fn + Ctrl + F3 |
| Enter a legacy array formula | Ctrl + Shift + Enter | Ctrl + Shift + Return |
| Expand or collapse the formula bar | Ctrl + Shift + U | Ctrl + Shift + U |
| Evaluate one piece of a formula while editing | Select it, then F9 | Select it, then Fn + F9 |
| Accept a function from autocomplete | Tab | Tab |
| Trace precedents (which cells feed this one) | Alt + M, P | Formulas, Trace Precedents |
| Trace dependents (what depends on this cell) | Alt + M, D | Formulas, Trace Dependents |
| Copy the formula above exactly, no reference shift | Ctrl + ' | Ctrl + ' |
Rows & columns
| What it does | Windows | Mac |
|---|---|---|
| Insert rows, columns, or cells | Ctrl + Shift + + | Cmd + Shift + + |
| Delete rows, columns, or cells | Ctrl + - | Cmd + - |
| Hide the selected rows | Ctrl + 9 | Ctrl + 9 |
| Hide the selected columns | Ctrl + 0 | Ctrl + 0 |
| Unhide rows | Ctrl + Shift + 9 | Ctrl + Shift + 9 |
| Unhide columns | Ctrl + Shift + 0 | Ctrl + Shift + 0 |
| Group rows or columns | Alt + Shift + Right | Cmd + Shift + K |
| Ungroup rows or columns | Alt + Shift + Left | Cmd + Shift + J |
| Autofit column width | Alt + H, O, I | Format, Column, Autofit |
| Autofit row height | Alt + H, O, A | Format, Row, Autofit |
| Show or hide the outline symbols | Ctrl + 8 | Ctrl + 8 |
Workbook & sheets
| What it does | Windows | Mac |
|---|---|---|
| New workbook | Ctrl + N | Cmd + N |
| Open a workbook | Ctrl + O | Cmd + O |
| Save | Ctrl + S | Cmd + S |
| Save As | F12 | Cmd + Shift + S |
Ctrl + P | Cmd + P | |
| Close the workbook | Ctrl + W | Cmd + W |
| Find | Ctrl + F | Cmd + F |
| Find and replace | Ctrl + H | Ctrl + H |
| Insert a new worksheet | Shift + F11 | Fn + Shift + F11 |
| Rename the active sheet | Alt + H, O, R | Double click the sheet tab |
| Freeze panes | Alt + W, F, F | View, Freeze Panes |
| Zoom in or out | Ctrl + scroll | Cmd + scroll |
Data (filter, sort, clean)
| What it does | Windows | Mac |
|---|---|---|
| Turn filters on or off | Ctrl + Shift + L | Cmd + Shift + F |
| Open the filter menu on the active header | Alt + Down | Option + Down |
| Clear every filter on the sheet | Alt + A, C | Data, Clear |
| Open the Sort dialog | Alt + A, S, S | Data, Sort |
| Turn a range into a table | Ctrl + T | Cmd + T |
| Insert a PivotTable | Alt + N, V | Insert, PivotTable |
| Add a drop-down list | Alt + A, V, V | Data, Validation |
| Remove duplicate rows | Alt + A, M | Data, Remove Duplicates |
| Split text into columns | Alt + A, E | Data, Text to Columns |
| Open the Quick Analysis menu | Ctrl + Q | Not available on Mac |
| Insert a chart on a new sheet | F11 | Fn + F11 |
Get the printable PDF
We will email you the Excel Shortcuts Cheat Sheet as a printable PDF, yours to keep. No cost, and you can unsubscribe any time.
How to use this cheat sheet
Do not try to memorize all of them. Pick the five that match the thing you do most, tape them to the side of your monitor, and use them for a week until your hands stop thinking about it. Most people get the biggest win from four keys: Ctrl + Arrow to move, Ctrl + Shift + Arrow to select, Alt + = to sum, and Ctrl + 1 to format.
The Windows keys are the default. On a Mac, Ctrl usually becomes Cmd, Alt becomes Option, and the function keys often need Fn. Where the Mac key is genuinely different, it is spelled out in the Mac column. A handful of Windows ribbon sequences, like Alt + H, H, have no Mac equivalent, so the menu path is listed instead. If you want the longer walkthrough with screenshots, read our guide to Excel keyboard shortcuts.
Go deeper
Excel Cheat Sheet
The full Excel reference: formulas, shortcuts, formatting, and data tools in one place.
Open the cheat sheetExcel Formulas Cheat Sheet
The formulas worth knowing, with plain-English explanations and copy-ready syntax.
See the formulasExcel Lookup Functions Cheat Sheet
VLOOKUP, XLOOKUP, INDEX and MATCH, and when to reach for each one.
See the lookupsGoogle Sheets Formulas Cheat Sheet
The same firepower on the Google side, including the formulas Excel does not have.
See the Sheets formulasQuestions people ask
What are the most useful Excel keyboard shortcuts?
The four that pay for themselves fastest are Ctrl + Arrow to jump to the edge of your data, Ctrl + Shift + Arrow to select to that edge, Alt + = to AutoSum, and Ctrl + 1 to open Format Cells. After those, learn Ctrl + D to fill down, F4 to lock a reference, and Ctrl + Shift + L to toggle filters. Those seven cover most of the clicking a typical spreadsheet user does in a day.
Do Excel shortcuts work the same on Mac?
Mostly, with three swaps. Ctrl usually becomes Cmd, Alt becomes Option, and the function keys often need the Fn key, so Ctrl + Home on Windows is Fn + Ctrl + Left on a Mac. Number formatting shortcuts like Ctrl + Shift + $ stay the same on both. The Alt-key ribbon sequences, such as Alt + H, H for fill color, are Windows only, so use the menu path on a Mac.
Do these Excel shortcuts work in Google Sheets?
Many do. Ctrl + Arrow, Ctrl + Shift + Arrow, Ctrl + B, Ctrl + Z, Ctrl + D, and Ctrl + Shift + L all behave the same way in Google Sheets. The ones that do not carry over are the Excel-specific ribbon sequences (anything starting with Alt + H or Alt + A) and a few dialog shortcuts like Ctrl + 1. If you live in Sheets, start with our Google Sheets formulas cheat sheet.
How do I show all the formulas in a sheet at once?
Press Ctrl + ` (the backtick key, above Tab on most keyboards). That flips the sheet from showing results to showing the formulas behind them, which is the fastest way to audit someone else's workbook. Press it again to flip back. Nothing is changed by toggling it, it is only a view. There is a step-by-step version in our guide to showing formulas in Excel.
Want the templates, not just the shortcuts
Simple Sheets has 100+ done-for-you Excel and Google Sheets templates. Budgets, trackers, dashboards, and more. Skip the build and start from a finished file.
Browse the templatesMore free stuff: free calculators and cheat sheets and free Excel templates.
