Excel Shortcut Keys: The Complete List for Windows & Mac (2026)
Excel shortcut keys are combinations of keys that run a command instantly, without reaching for the mouse. The most-used Excel shortcuts are Ctrl + C (copy), Ctrl + V (paste), Ctrl + Z (undo), and Ctrl + S (save). On a Mac, these use the Command key instead: Cmd + C, Cmd + V, Cmd + Z, and Cmd + S. Excel has more than 200 shortcuts across both platforms, and learning even 20 of them noticeably speeds up everyday work.
This guide covers 200+ Excel shortcut actions across 18 categories, with Windows and Mac keys side by side verified against Microsoft’s official documentation for Excel 2024 and Microsoft 365. You can also download the full list as a free PDF.
Key Takeaways
- Excel shortcut keys trigger commands using key combinations instead of the mouse.
- The four most-used shortcuts are Copy (Ctrl+C), Paste (Ctrl+V), Undo (Ctrl+Z), and Save (Ctrl+S).
- On Mac, replace Ctrl with Command (Cmd) for most shortcuts but not all; some use Control or Option.
- A plus sign (+) means press keys together; a comma (,) means press them in sequence (e.g. Alt, H, A, C).
- Excel has 200+ shortcuts; knowing 20–30 covers the vast majority of daily tasks.
What Are Excel Shortcut Keys?
Excel shortcut keys are key combinations that perform a command like copying, saving, or formatting without using the mouse or navigating the ribbon. Instead of clicking through menus, you press two or three keys at once and the action happens instantly.
They matter for one simple reason: speed compounds. A single shortcut saves only a second or two, but across hundreds of repeated actions in a workday, that adds up to real time. Keyboard shortcuts also reduce strain from constant mouse use, and for people with mobility or vision needs they are an essential alternative to a touchscreen or mouse.
Excel has more than 200 shortcuts in total (over 400 if you count Windows and Mac versions separately). You do not need to memorize them all. Most people rely on the same 20 to 30 shortcuts for nearly everything, and pick up specialized ones for pivot tables, formulas, or macros only when their work calls for them. The fastest way to learn is to add two or three new shortcuts at a time until they become muscle memory.
How to Read Excel Shortcuts (+ vs , and the Alt Key)
Excel shortcuts use two separators, and the difference matters:
- A plus sign (+) means press the keys at the same time. For example, Ctrl + Shift + L means hold Ctrl, then Shift, then press L, all together, then release.
- A comma (,) means press the keys one after another, in order. For example, Alt, H, A, C means press and release Alt, then H, then A, then C not held down together.
The Alt key and Key Tips (Windows)
On Windows, pressing and releasing the Alt key turns on Key Tips small letters that appear over each ribbon tab and command. Press the letter shown to open that tab, then press the next letter for the command you want. For example, Alt then H opens the Home tab; press H again to open Fill Color. This is why many Windows shortcuts are written as sequences like Alt, H, A, C (Home → Alignment → Center).
Windows vs Mac keys
Most Windows shortcuts that use Ctrl map to Command (Cmd) on a Mac for example, Ctrl+C becomes Cmd+C. But this is not universal: some Mac shortcuts keep the Control key, and Alt on Windows becomes Option on Mac. The tables below show the correct key for each platform, so you do not have to guess.
Most-Used Shortcuts (Essentials)
| Action | Windows | Mac |
|---|---|---|
| Copy | Ctrl + C | Cmd + C |
| Paste | Ctrl + V | Cmd + V |
| Cut | Ctrl + X | Cmd + X |
| Undo | Ctrl + Z | Cmd + Z |
| Redo | Ctrl + Y | Cmd + Y |
| Repeat last action | F4 | Cmd + Y |
| Save | Ctrl + S | Cmd + S |
| Save As | F12 | Cmd + Shift + S |
| Open | Ctrl + O | Cmd + O |
| New workbook | Ctrl + N | Cmd + N |
| Ctrl + P | Cmd + P | |
| Find | Ctrl + F | Cmd + F |
| Find and Replace | Ctrl + H | Ctrl + H |
| Paste Special | Ctrl + Alt + V | Cmd + Option + V |
| Open context (right-click) menu | Shift + F10 | Shift + F10 |
| Open Format Cells dialog | Ctrl + 1 | Cmd + 1 |
File & Workbook Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Create new workbook | Ctrl + N | Cmd + N |
| Open workbook | Ctrl + O | Cmd + O |
| Save workbook | Ctrl + S | Cmd + S |
| Save As | F12 | Cmd + Shift + S |
| Ctrl + P | Cmd + P | |
| Print preview | Ctrl + F2 | Cmd + P |
| Close current workbook | Ctrl + W | Cmd + W |
| Close Excel | Alt + F4 | Cmd + Q |
| Insert new worksheet | Shift + F11 | Shift + F11 |
| Go to next worksheet | Ctrl + Page Down | Ctrl + Page Down |
| Go to previous worksheet | Ctrl + Page Up | Ctrl + Page Up |
| Go to next workbook window | Ctrl + Tab | Cmd + ` |
| Expand or collapse the ribbon | Ctrl + F1 | Cmd + Option + R |
| Toggle full screen | Ctrl + Shift + F1 | Cmd + Ctrl + F |
Navigation Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Move one cell up / down / left / right | Arrow keys | Arrow keys |
| Move to edge of data region | Ctrl + Arrow key | Cmd + Arrow key |
| Move to beginning of row | Home | Home (MacBook: Fn + Left) |
| Move to first cell of worksheet (A1) | Ctrl + Home | Ctrl + Home |
| Move to last used cell | Ctrl + End | Ctrl + End |
| Move one screen down | Page Down | Page Down (MacBook: Fn + Down) |
| Move one screen up | Page Up | Page Up (MacBook: Fn + Up) |
| Move one screen right | Alt + Page Down | Option + Page Down |
| Move one screen left | Alt + Page Up | Option + Page Up |
| Open Go To dialog | Ctrl + G | Ctrl + G |
| Turn End mode on/off | End | – |
Selection Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Select entire worksheet | Ctrl + A | Cmd + A |
| Select entire row | Shift + Spacebar | Shift + Spacebar |
| Select entire column | Ctrl + Spacebar | Ctrl + Spacebar |
| Extend selection by one cell | Shift + Arrow key | Shift + Arrow key |
| Extend selection to last cell | Ctrl + Shift + Arrow key | Cmd + Shift + Arrow key |
| Extend selection to start of worksheet | Ctrl + Shift + Home | Ctrl + Shift + Home |
| Extend selection to last used cell | Ctrl + Shift + End | Ctrl + Shift + End |
| Select current region | Ctrl + Shift + * | Cmd + Shift + * |
| Toggle extend selection mode | F8 | F8 |
| Add non-adjacent cells to selection | Shift + F8 | Shift + F8 |
| Select visible cells only | Alt + ; | – |
| Cancel selection | Esc | Esc |
Data Entry Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Complete entry, move down | Enter | Return |
| Complete entry, move up | Shift + Enter | Shift + Return |
| Complete entry, move right | Tab | Tab |
| Complete entry, move left | Shift + Tab | Shift + Tab |
| Complete entry, stay in same cell | Ctrl + Enter | Ctrl + Return |
| Fill the same data into multiple cells | Ctrl + Enter | Ctrl + Return |
| Insert current date | Ctrl + ; | Ctrl + ; |
| Insert current time | Ctrl + Shift + : | Cmd + ; |
| Fill down from cell above | Ctrl + D | Cmd + D |
| Fill right from cell on left | Ctrl + R | Cmd + R |
| Copy formula from cell above | Ctrl + ‘ | Ctrl + ‘ |
| Copy value from cell above | Ctrl + Shift + “ | Ctrl + Shift + “ |
| Insert hyperlink | Ctrl + K | Cmd + K |
| Flash Fill | Ctrl + E | Ctrl + E |
| Start a new line in the same cell | Alt + Enter | Option + Return |
Cell Editing Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Edit active cell | F2 | F2 |
| Insert or edit a note | Shift + F2 | Shift + F2 |
| Insert or reply to a threaded comment | Ctrl + Shift + F2 | Cmd + Shift + F2 |
| Cancel entry | Esc | Esc |
| Select one character right / left | Shift + Right / Left | Shift + Right / Left |
| Move one word right / left | Ctrl + Right / Left | Option + Right / Left |
| Delete to end of line | Ctrl + Delete | Ctrl + Delete |
| Delete character left of cursor | Backspace | Delete |
| Delete character right of cursor | Delete | Fn + Delete |
Text Formatting Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Bold | Ctrl + B | Cmd + B |
| Italic | Ctrl + I | Cmd + I |
| Underline | Ctrl + U | Cmd + U |
| Strikethrough | Ctrl + 5 | Cmd + Shift + X |
| Open Format Cells dialog | Ctrl + 1 | Cmd + 1 |
| Format Cells with Font tab | Ctrl + Shift + F | – |
| Align center | Alt, H, A, C | Cmd + E |
| Align left | Alt, H, A, L | Cmd + L |
| Increase font size | Alt, H, F, G | Cmd + Shift + > |
| Decrease font size | Alt, H, F, K | Cmd + Shift + < |
Number Formatting Shortcuts
| Action | Windows | Mac |
|---|---|---|
| General format | Ctrl + Shift + ~ | Ctrl + Shift + ~ |
| Currency format | Ctrl + Shift + $ | Ctrl + Shift + $ |
| Percentage format | Ctrl + Shift + % | Ctrl + Shift + % |
| Scientific format | Ctrl + Shift + ^ | Ctrl + Shift + ^ |
| Date format | Ctrl + Shift + # | Ctrl + Shift + # |
| Time format | Ctrl + Shift + @ | Ctrl + Shift + @ |
| Number format (2 decimals) | Ctrl + Shift + ! | Ctrl + Shift + ! |
Cell Borders Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Add outline border | Ctrl + Shift + & | Cmd + Option + 0 |
| Remove borders | Ctrl + Shift + _ | Cmd + Option + – |
| Add/remove border right | Alt, H, B, R | Cmd + Option + Right |
| Add/remove border left | Alt, H, B, L | Cmd + Option + Left |
| Add/remove border top | Alt, H, B, T | Cmd + Option + Up |
| Add/remove border bottom | Alt, H, B, B | Cmd + Option + Down |
Rows, Columns & Grid Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Insert cells, rows, or columns | Ctrl + Shift + + | Ctrl + Shift + = |
| Delete cells, rows, or columns | Ctrl + – | Cmd + – |
| Hide columns | Ctrl + 0 | Cmd + ) |
| Unhide columns | Ctrl + Shift + 0 | Cmd + Shift + ) |
| Hide rows | Ctrl + 9 | Ctrl + 9 |
| Unhide rows | Ctrl + Shift + 9 | Ctrl + Shift + ( |
| Group rows or columns | Alt + Shift + Right | Cmd + Shift + K |
| Ungroup rows or columns | Alt + Shift + Left | Cmd + Shift + J |
| Show/hide outline symbols | Ctrl + 8 | Ctrl + 8 |
| Delete cell contents | Delete | Delete |
Formulas & Functions Shortcuts
| Action | Windows | Mac |
|---|---|---|
| AutoSum | Alt + = | Shift + Cmd + T |
| Toggle formulas on/off | Ctrl + ` | Ctrl + ` |
| Insert function | Shift + F3 | Shift + F3 |
| Insert function arguments | Ctrl + Shift + A | – |
| Enter array formula | Ctrl + Shift + Enter | Ctrl + Shift + Return |
| Calculate all worksheets | F9 | F9 |
| Calculate active worksheet | Shift + F9 | Shift + F9 |
| Toggle absolute/relative reference | F4 | Cmd + T or F4 |
| Define a name | Ctrl + F3 | Cmd + F3 |
| Paste a name into a formula | F3 | – |
| Expand or collapse formula bar | Ctrl + Shift + U | Ctrl + Shift + U |
| Open Power Query Editor | Alt + F12 | Option + F12 |
Filters & Tables Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Toggle AutoFilter | Ctrl + Shift + L | Cmd + Shift + F |
| Activate filter dropdown | Alt + Down Arrow | Option + Down Arrow |
| Insert table | Ctrl + T | Cmd + T |
| Toggle table total row | Ctrl + Shift + T | – |
| Select table column | Ctrl + Spacebar | Ctrl + Spacebar |
| Select table row | Shift + Spacebar | Shift + Spacebar |
Charts & Pivot Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Create embedded chart | Alt + F1 | Option + F1 |
| Create chart in new sheet | F11 | F11 |
| Quick Analysis options | Ctrl + Q | – |
Macros & VBA Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Open Macro dialog | Alt + F8 | Option + F8 |
| Open VBA Editor | Alt + F11 | Option + F11 |
| Open spelling check | F7 | F7 |
| Open thesaurus | Shift + F7 | Shift + F7 |
Ribbon Access Keys (Alt Key Tips)
Press and release Alt to show Key Tips, then press the letter for the tab. On Excel for the web, start with Alt + Windows key.
| Action | Windows |
|---|---|
| Show Key Tips on the ribbon | Alt (or F10) |
| Go to Tell Me / Search field | Alt + Q |
| Open the File menu | Alt + F |
| Open the Home tab | Alt + H |
| Open the Insert tab | Alt + N |
| Open the Page Layout tab | Alt + P |
| Open the Formulas tab | Alt + M |
| Open the Data tab | Alt + A |
| Open the Review tab | Alt + R |
| Open the View tab | Alt + W |
| Switch to Page Layout view | Alt, W, P |
| Switch to Normal view | Alt, W, L |
| Switch to Page Break Preview | Alt, W, I |
Paste Special Options Shortcuts
After copying, press Ctrl + Alt + V (Windows) or Cmd + Option + V (Mac) to open Paste Special, then press the letter for the option.
| Action | Windows | Mac |
|---|---|---|
| Open Paste Special dialog | Ctrl + Alt + V | Cmd + Option + V |
| Paste all contents and formatting | A | A |
| Paste formulas only | F | F |
| Paste values only | V | V |
| Paste formatting only | T | T |
| Paste comments and notes only | C | C |
| Paste data validation only | N | N |
| Paste all without borders | X | X |
| Paste column widths only | W | W |
| Paste formulas and number formats | R | R |
| Paste values and number formats | U | U |
Power Pivot Shortcuts
For the Power Pivot window in Microsoft 365 and Office.
| Action | Windows | Mac |
|---|---|---|
| Open context menu | Shift + F10 | Shift + F10 |
| Select entire table | Ctrl + A | Cmd + A |
| Copy selected data | Ctrl + C | Cmd + C |
| Delete the table | Ctrl + D | Cmd + D |
| Move the table | Ctrl + M | Cmd + M |
| Rename the table | Ctrl + R | Cmd + R |
| Save the file | Ctrl + S | Cmd + S |
| Redo last action | Ctrl + Y | Cmd + Y |
| Undo last action | Ctrl + Z | Cmd + Z |
| Select current column | Ctrl + Spacebar | Ctrl + Spacebar |
| Select current row | Shift + Spacebar | Shift + Spacebar |
| Select to last cell of column | Shift + Page Down | Shift + Page Down |
| Select to first cell of column | Shift + Page Up | Shift + Page Up |
| Move to previous table | Ctrl + Page Up | Ctrl + Page Up |
| Move to next table | Ctrl + Page Down | Ctrl + Page Down |
| Open AutoFilter menu | Alt + Down Arrow | Option + Down Arrow |
| Open Go To dialog | F5 | F5 |
| Recalculate all formulas | F9 | F9 |
Function Keys (Quick Reference)
| Action | Key (Windows/Mac) |
|---|---|
| Help | F1 |
| Edit active cell | F2 |
| Repeat / toggle reference | F4 |
| Go To dialog | F5 |
| Spelling | F7 |
| Calculate workbooks | F9 |
| New chart sheet | F11 |
| Save As | F12 |
Frequently Asked Questions
What is the most used Excel shortcut?
The most used Excel shortcut is Ctrl + C (copy), closely followed by Ctrl + V (paste), Ctrl + Z (undo), and Ctrl + S (save). On a Mac, these are Cmd + C, Cmd + V, Cmd + Z, and Cmd + S. These four cover the majority of everyday actions in Excel.
How many keyboard shortcuts does Excel have?
Excel has more than 200 keyboard shortcuts, and over 400 if you count Windows and Mac versions separately. Most users rely on the same 20 to 30 shortcuts for nearly all of their daily work, and learn specialized ones for pivot tables, formulas, or macros only as needed.
What is the difference between + and , in Excel shortcuts?
A plus sign (+) means press the keys at the same time for example, Ctrl + Shift + L is held together. A comma (,) means press the keys one after another in sequence for example, Alt, H, A, C is pressed and released one key at a time.
Do Excel shortcuts work on Mac?
Yes. Most Excel shortcuts work on Mac, with Ctrl usually replaced by Command (Cmd) and Alt replaced by Option. However, some shortcuts differ for example, AutoSum is Alt + = on Windows but Shift + Cmd + T on Mac. The tables in this guide list the correct key for each platform.
What does Ctrl + Shift + L do in Excel?
Ctrl + Shift + L turns the AutoFilter on or off for your data. When on, filter arrows appear on each column header, letting you sort and filter. On a Mac, the equivalent is Cmd + Shift + F.
How do I create my own keyboard shortcut in Excel?
Excel does not let you reassign built-in shortcuts directly, but you can record a macro and assign it a shortcut key. Go to the View tab, select Macros → Record Macro, enter a shortcut letter in the “Shortcut key” box, perform your actions, then stop recording. On Mac, you can also create custom shortcuts in System Settings.
What is the Alt key used for in Excel?
On Windows, pressing and releasing the Alt key shows Key Tips letters that appear over each ribbon tab and command. Pressing those letters in sequence runs the command, which is why many shortcuts are written as sequences like Alt, H, A, C (Home → Alignment → Center).
Conclusion
You do not need to memorize all 200+ Excel shortcut keys. Start with the 20 most-used shortcuts above, build them into muscle memory, then add category-specific ones formulas, pivot tables, filters as your work demands. Keep this page bookmarked as a reference, or download the free PDF cheat sheet to keep the full list at hand.
READ NEXT:





