Excel Shortcuts Cheat Sheet: 228 Keyboard Shortcuts for Windows and Mac
Keyboard shortcuts are one of those Excel skills that save you time every single day. Once your hands stay on the keyboard, you stop hunting for buttons on the ribbon, and the work moves faster.
On this page, I have listed more than 200 Excel keyboard shortcuts, grouped by the task you want to do, with the Windows and Mac keys side by side. They work in Excel for Microsoft 365 and Excel 2016 to 2024 on Windows, and in Excel for Microsoft 365, 2024 and 2021 on a Mac. Where a shortcut needs Microsoft 365, I have marked it. You can also download the full list as a free printable PDF.
How to read the keys: a plus sign (+) means press the keys together, and a comma means press them one after another (for example, Alt, H, A, C). On a Mac laptop, you may need to hold Fn to use F1 to F12. A dash (—) means there is no standard shortcut for it on that platform.
Free PDF cheat sheet: all the shortcuts on this page, Windows and Mac, on a printable sheet.
Top 10 Excel Shortcuts to Learn First
If you are just starting, learn these ten first. They cover most of what you do in Excel every day.
Action | Windows | Mac |
|---|---|---|
Copy and paste | Ctrl + C, Ctrl + V | Cmd + C, Cmd + V |
Undo and redo | Ctrl + Z or Ctrl + Y | Cmd + Z or Cmd + Y |
Jump to the edge of the data | Ctrl + Arrow key | Cmd + Arrow key |
Select to the edge of the data | Ctrl + Shift + Arrow key | Cmd + Shift + Arrow key |
Select the entire column or row | Ctrl + Space or Shift + Space | Control + Space or Shift + Space |
Open Format Cells | Ctrl + 1 | Cmd + 1 |
Edit the active cell | F2 | F2 or Control + U |
Lock a cell reference in a formula | F4 | Cmd + T or F4 |
Insert AutoSum | Alt + = | Cmd + Shift + T |
Turn filters on or off | Ctrl + Shift + L | Cmd + Shift + F |
Workbook and Worksheet Shortcuts
These shortcuts help you open, save, close and move between workbooks and worksheets.
Action | Windows | Mac |
|---|---|---|
Create a new workbook | Ctrl + N | Cmd + N |
Open a workbook | Ctrl + O | Cmd + O |
Save the workbook | Ctrl + S | Cmd + S |
F12 | Cmd + Shift + S | |
Ctrl + P | Cmd + P | |
Ctrl + W or Ctrl + F4 | Cmd + W | |
Close Excel | Alt + F4 | Cmd + Q |
Shift + F11 or Alt + Shift + F1 | Shift + F11 | |
Ctrl + Page Down | Control + Page Down or Option + → | |
Go to the previous worksheet | Ctrl + Page Up | Control + Page Up or Option + ← |
Switch to the next open workbook | Ctrl + Tab | Cmd + ` |
Switch to the previous open workbook | Ctrl + Shift + Tab | Cmd + Shift + ` |
Minimize the workbook window | Ctrl + F9 | Cmd + M |
Maximize or restore the workbook window | Ctrl + F10 | Control + F10 |
Ctrl + Shift + F1 | Control + Cmd + F | |
Show or hide the ribbon | Ctrl + F1 | Cmd + Option + R |
Open Excel Options (Preferences on Mac) | Alt, F, T | Cmd + , |
Open Help | F1 | Cmd + / |
Move to the next pane (sheet, ribbon, task pane) | F6 | F6 |
Move to the previous pane | Shift + F6 | Shift + F6 |
Navigation Shortcuts
Use these to move around a sheet without the mouse. Ctrl + Arrow key is the one I use the most: it jumps to the last filled cell in that direction.
Action | Windows | Mac |
|---|---|---|
Move one cell up, down, left or right | Arrow keys | Arrow keys |
Move to the edge of the current data region | Ctrl + Arrow key | Cmd + Arrow key |
Move one screen down | Page Down | Fn + ↓ |
Move one screen up | Page Up | Fn + ↑ |
Move one screen right | Alt + Page Down | Fn + Option + ↓ |
Move one screen left | Alt + Page Up | Fn + Option + ↑ |
Move to the beginning of the row | Home | Fn + ← |
Move to cell A1 | Ctrl + Home | Fn + Control + ← |
Move to the last used cell | Ctrl + End | Fn + Control + → |
Turn End mode on or off | End | Fn + → |
Open the Go To dialog | Ctrl + G or F5 | Control + G |
Move one cell right (or to the next unlocked cell on a protected sheet) | Tab | Tab |
Move one cell left | Shift + Tab | Shift + Tab |
Scroll back to the active cell | Ctrl + Backspace | Control + Delete |
Open a data validation or AutoComplete list | Alt + ↓ | Option + ↓ |
Ctrl + Alt + = | Cmd + Option + + | |
Zoom out | Ctrl + Alt + - | Cmd + Option + - |
Selection Shortcuts
Selecting a range with the keyboard is faster and more exact than dragging the mouse, especially on large data.
Action | Windows | Mac |
|---|---|---|
Shift + Space | Shift + Space | |
Select the entire column | Ctrl + Space | Control + Space |
Select the current region, then the whole sheet | Ctrl + A | Cmd + A |
Select the current region around the active cell | Ctrl + Shift + * | Control + Shift + Space |
Extend the selection by one cell | Shift + Arrow key | Shift + Arrow key |
Extend the selection to the last non-blank cell | Ctrl + Shift + Arrow key | Cmd + Shift + Arrow key |
Extend the selection down one screen | Shift + Page Down | Fn + Shift + ↓ |
Extend the selection up one screen | Shift + Page Up | Fn + Shift + ↑ |
Extend the selection right one screen | Alt + Shift + Page Down | Fn + Shift + Option + ↓ |
Extend the selection left one screen | Alt + Shift + Page Up | Fn + Shift + Option + ↑ |
Extend the selection to the start of the row | Shift + Home | Fn + Shift + ← |
Extend the selection to cell A1 | Ctrl + Shift + Home | Fn + Control + Shift + ← |
Extend the selection to the last used cell | Ctrl + Shift + End | Fn + Control + Shift + → |
Turn Extend mode on or off | F8 | F8 |
Add more cells to the selection with the arrow keys | Shift + F8 | Shift + F8 |
Add adjacent cells with the mouse | Shift + click | Shift + click |
Add non-adjacent cells with the mouse | Ctrl + click | Cmd + click |
Select only the active cell | Shift + Backspace | Shift + Delete |
Move the active cell to the next corner of the selection | Ctrl + . | Control + . |
Move to the next non-adjacent selection | Ctrl + Alt + → | Control + Option + → |
Move to the previous non-adjacent selection | Ctrl + Alt + ← | Control + Option + ← |
Select the same range in the next column | — | Option + Tab |
Data Entry and Cell Editing Shortcuts
These shortcuts help you type, fill and edit data. Ctrl + Enter is worth remembering: type a value, press it, and Excel fills every selected cell with that value.
Action | Windows | Mac |
|---|---|---|
F2 | F2 or Control + U | |
Cancel the entry | Esc | Esc |
Complete the entry and move down | Enter | Return |
Complete the entry and move up | Shift + Enter | Shift + Return |
Fill the selected cells with the current entry | Ctrl + Enter | Control + Return |
Start a new line in the same cell | Alt + Enter | Control + Option + Return |
Insert today's date | Ctrl + ; | Control + ; |
Insert the current time | Ctrl + Shift + : | Cmd + ; |
Ctrl + D | Control + D | |
Fill right from the cell on the left | Ctrl + R | Control + R |
Copy the formula from the cell above | Ctrl + ' | Control + ' |
Copy the value from the cell above | Ctrl + Shift + " | Control + Shift + " |
Flash Fill | Ctrl + E | Control + E |
Ctrl + K | Cmd + K | |
Shift + F2 | Shift + F2 | |
Insert a threaded comment | Ctrl + Shift + F2 | Cmd + Shift + F2 |
Check spelling | F7 | F7 |
Open the Thesaurus | Shift + F7 | Shift + F7 |
Move one word left or right (while editing) | Ctrl + ← or Ctrl + → | Control + ← or Control + → |
Select one word left or right (while editing) | Ctrl + Shift + ← or Ctrl + Shift + → | Control + Shift + ← or Control + Shift + → |
Select to the start of the cell text | Shift + Home | Fn + Shift + ← |
Select to the end of the cell text | Shift + End | Fn + Shift + → |
Delete from the cursor to the end of the line | Ctrl + Delete | Fn + Control + Delete |
Delete the character to the left of the cursor | Backspace | Delete |
Delete the character to the right of the cursor | Delete | Fn + Delete |
Copy, Paste, Undo and Find Shortcuts
The basics you use all day, plus Paste Special.
Action | Windows | Mac |
|---|---|---|
Ctrl + C | Cmd + C | |
Ctrl + X | Cmd + X | |
Paste | Ctrl + V | Cmd + V |
Open Paste Special | Ctrl + Alt + V | Cmd + Control + V |
Paste values (or match destination formatting) Microsoft 365 | Ctrl + Shift + V | Cmd + Control + V, then choose Values |
Ctrl + Z | Cmd + Z | |
Redo | Ctrl + Y | Cmd + Y or Cmd + Shift + Z |
Repeat the last action | F4 or Ctrl + Y | Cmd + Y |
Find | Ctrl + F | Cmd + F |
Ctrl + H | Control + H | |
Find the next match (dialog closed) | Shift + F4 | Cmd + G |
Find the previous match (dialog closed) | Ctrl + Shift + F4 | Cmd + Shift + G |
Delete | Delete |
After you open Paste Special with Ctrl + Alt + V on Windows, press one of these letters and then Enter:
Paste | Press |
|---|---|
All | A |
Formulas | F |
Values | V |
Formats | T |
Comments and notes | C |
Validation | N |
All using source theme | H |
All except borders | X |
Column widths | W |
Formulas and number formats | R |
Values and number formats | U |
Formatting Shortcuts
Use these to format text and align cells. On Windows, the ribbon shortcuts (like Alt, H, A, C) are pressed one key after another.
Action | Windows | Mac |
|---|---|---|
Ctrl + 1 | Cmd + 1 | |
Open Format Cells with the Font tab selected | Ctrl + Shift + F | Control + Shift + F |
Bold | Ctrl + B or Ctrl + 2 | Cmd + B |
Italic | Ctrl + I or Ctrl + 3 | Cmd + I |
Underline | Ctrl + U or Ctrl + 4 | Cmd + U |
Ctrl + 5 | Cmd + Shift + X | |
Alt, H, A, C | Cmd + E | |
Align left | Alt, H, A, L | Cmd + L |
Align right | Alt, H, A, R | Cmd + R |
Alt, H, 6 | Control + Option + Tab | |
Decrease the indent | Alt, H, 5 | Control + Option + Shift + Tab |
Increase the font size | Alt, H, F, G | Cmd + Shift + > |
Decrease the font size | Alt, H, F, K | Cmd + Shift + |
Alt, H, H | — | |
Open the borders menu | Alt, H, B | — |
Open the Style dialog | Alt + ' | Cmd + Shift + L |
Number Format Shortcuts
Each of these applies a number format to the selected cells in one go. On a Mac, they use Control, not Cmd.
Action | Windows | Mac |
|---|---|---|
General format | Ctrl + Shift + ~ | Control + Shift + ~ |
Number format (two decimals, thousands separator) | Ctrl + Shift + ! | Control + Shift + ! |
Ctrl + Shift + $ | Control + Shift + $ | |
Ctrl + Shift + % | Control + Shift + % | |
Scientific format (two decimals) | Ctrl + Shift + ^ | Control + Shift + ^ |
Date format (day, month, year) | Ctrl + Shift + # | Control + Shift + # |
Time format (hour, minute, AM/PM) | Ctrl + Shift + @ | Control + Shift + @ |
Border Shortcuts
The first two work directly on the sheet. On Windows, the single-letter shortcuts work inside the Border tab of the Format Cells dialog (Ctrl + 1). On a Mac, the arrow shortcuts work directly on the sheet.
Action | Windows | Mac |
|---|---|---|
Ctrl + Shift + & | Cmd + Option + 0 | |
Remove all borders | Ctrl + Shift + _ | Cmd + Option + _ |
Add or remove the right border | Alt + R | Cmd + Option + → |
Add or remove the left border | Alt + L | Cmd + Option + ← |
Add or remove the top border | Alt + T | Cmd + Option + ↑ |
Add or remove the bottom border | Alt + B | Cmd + Option + ↓ |
Add or remove the diagonal border | Alt + D | — |
Add or remove the inside horizontal border | Alt + H | — |
Add or remove the inside vertical border | Alt + V | — |
Row, Column and Cell Shortcuts
Insert, delete, hide and group rows and columns with these.
Action | Windows | Mac |
|---|---|---|
Ctrl + Shift + + | Control + Shift + = | |
Ctrl + - | Control + - | |
Hide the selected rows | Ctrl + 9 | Control + 9 |
Hide the selected columns | Ctrl + 0 | Control + 0 |
Unhide rows | Ctrl + Shift + 9 | Control + Shift + 9 |
Ctrl + Shift + 0 | Control + Shift + 0 | |
Alt + Shift + → | Cmd + Shift + K | |
Ungroup rows or columns | Alt + Shift + ← | Cmd + Shift + J |
Show or hide the outline symbols | Ctrl + 8 | Control + 8 |
Delete the selected column (ribbon) | Alt, H, D, C | — |
Formula Shortcuts
These shortcuts help you write, check and calculate formulas. In Microsoft 365, Excel 2024 and Excel 2021, you don't need Ctrl + Shift + Enter for array formulas anymore. Press Enter, and the result spills on its own.
Action | Windows | Mac |
|---|---|---|
Alt + = | Cmd + Shift + T | |
F4 | Cmd + T or F4 | |
Open Insert Function | Shift + F3 | Shift + F3 |
Open Function Arguments (after typing a function name) | Ctrl + A | Control + A |
Insert argument names and parentheses | Ctrl + Shift + A | Control + Shift + A |
Accept the function AutoComplete suggests | Tab | Tab |
Ctrl + ` | Control + ` | |
Calculate all open workbooks | F9 | F9 |
Calculate the active sheet | Shift + F9 | Shift + F9 |
Force a full calculation of all sheets | Ctrl + Alt + F9 | — |
Evaluate the selected part of a formula | F9 (while editing) | F9 (while editing) |
Expand or collapse the formula bar | Ctrl + Shift + U | Control + Shift + U |
Open Name Manager | Ctrl + F3 | Control + F3 |
Create names from row and column labels | Ctrl + Shift + F3 | Control + Shift + F3 |
Paste a name into a formula | F3 | F3 |
Define a name (ribbon) | Alt, M, M, D | — |
Enter a legacy array formula | Ctrl + Shift + Enter | Control + Shift + Return |
Go To Special Shortcuts
These select special cells in one go, like the cells a formula depends on or only the visible cells after you hide rows. Alt + ; is the one to remember when you copy filtered data.
Action | Windows | Mac |
|---|---|---|
Select cells with comments | Ctrl + Shift + O | Fn + Control + Shift + O |
Select the current array | Ctrl + / | Control + / |
Select row differences | Ctrl + | Control + |
Select column differences | Ctrl + Shift + | | Control + Shift + | |
Select direct precedents | Ctrl + [ | Control + [ |
Select all precedents | Ctrl + Shift + { | Control + Shift + { |
Select direct dependents | Ctrl + ] | Control + ] |
Select all dependents | Ctrl + Shift + } | Control + Shift + } |
Select visible cells only | Alt + ; | Cmd + Shift + Z |
Table, Filter and Pivot Table Shortcuts
Shortcuts for Excel tables, filters, Power Query and pivot tables.
Action | Windows | Mac |
|---|---|---|
Create a table | Ctrl + T or Ctrl + L | Control + T |
Ctrl + Shift + L | Cmd + Shift + F | |
Open the filter menu (on a header cell) | Alt + ↓ | Option + ↓ |
Add or remove the table total row | Ctrl + Shift + T | Control + Shift + T |
Clear a slicer filter | Alt + C | Option + C |
Open the Custom Sort dialog | Alt, H, S, U | Cmd + Shift + R |
Refresh all data connections | Ctrl + Alt + F5 | — |
Open the Power Query Editor | Alt + F12 | Option + F12 |
Select the entire pivot table | Ctrl + A (inside it) | Cmd + A (inside it) |
Group pivot table items | Alt + Shift + → | Cmd + Shift + K |
Ungroup pivot table items | Alt + Shift + ← | Cmd + Shift + J |
Hide the selected pivot table item | Ctrl + - | Control + - |
Check or uncheck a field in the field list | Space | Space |
Open the PivotTable wizard | Alt, D, P | Cmd + Option + P |
Ribbon Shortcuts with the Alt Key (KeyTips)
Almost every command on the ribbon has a keyboard path, even when it has no Ctrl shortcut. Press Alt, and Excel shows a letter on each ribbon tab. These letters are called KeyTips.

Press the letter of a tab, and Excel shows the KeyTips for every command on that tab. Then press the letters one after another. For example, Alt, H, A, C centers the text in the selected cells.

Action | Windows |
|---|---|
Show KeyTips | Alt or F10 |
Go to the Search box | Alt + Q |
Open the File tab | 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 Normal view | Alt, W, L |
Switch to Page Layout view | Alt, W, P |
Switch to Page Break Preview | Alt, W, I |
Show the tooltip for the selected ribbon command | Ctrl + Shift + F10 |
Move between groups on the ribbon | Ctrl + ← or Ctrl + → |
Open Paste Special with the old Excel 2003 menu keys | Alt, E, S |
KeyTips are now in Excel for Microsoft 365 on a Mac too. Turn them on from Excel > Preferences, and then press Option to show them.
Function Key Shortcuts (F1 to F12)
Here is what each function key does on its own and with Shift, Ctrl and Alt in Excel for Windows. For the Mac keys, use the tables above.
Key | Alone | With Shift | With Ctrl | With Alt |
|---|---|---|---|---|
F1 | Open Help | Show or hide the ribbon | Create a chart | |
F2 | Edit the active cell | Insert or edit a note | Edit in the formula bar | |
F3 | Paste a name | Open Insert Function | Open Name Manager | Go to the Name Box |
F4 | Repeat the last action, or switch references | Find the next match | Close the workbook window | Close Excel |
F5 | Open Go To | Restore the window size | ||
F6 | Move to the next pane | Move to the previous pane | Switch to the next workbook window | |
F7 | Check spelling | Open the Thesaurus | Move the window | |
F8 | Turn Extend mode on or off | Add to the selection | Resize the window | Open the Macro dialog |
F9 | Calculate all open workbooks | Calculate the active sheet | Minimize the window | |
F10 | Turn KeyTips on or off | Open the right-click menu | Maximize or restore the window | |
F11 | Create a chart on a new sheet | Insert a new worksheet | Open the VBA Editor | |
F12 | Open Save As | Open the Power Query Editor |
Other Useful Shortcuts
Drag-and-drop tricks, charts, macros, objects and dialog boxes.
Action | Windows | Mac |
|---|---|---|
Copy cells by dragging | Ctrl + drag | Option + drag |
Move and insert cells by dragging | Shift + drag | Shift + drag |
Insert a copy of cells by dragging | Ctrl + Shift + drag | Option + Shift + drag |
Drag cells to another sheet | Alt + drag | Cmd + drag |
Duplicate a worksheet | Ctrl + drag the sheet tab | Option + drag the sheet tab |
Create a chart of the selected data | Alt + F1 | Option + F1 |
Create a chart on a new sheet | F11 | F11 |
Show Quick Analysis | Ctrl + Q | — |
Open the Macro dialog | Alt + F8 | Option + F8 |
Open the VBA Editor | Alt + F11 | Option + F11 |
Open the right-click menu | Shift + F10 | Shift + F10 |
Hide or show objects | Ctrl + 6 | Control + 6 |
Duplicate the selected object | Ctrl + D | Cmd + D |
Snap an object to the grid while dragging | Alt + drag | Cmd + drag |
Turn Scroll Lock on or off | ScrLk | Shift + F14 |
Open the Excel window menu | Alt + Space | — |
Dialog box: move to the next option | Tab | Tab |
Dialog box: move to the previous option | Shift + Tab | Shift + Tab |
Dialog box: move to the next tab | Ctrl + Tab | Control + Tab |
Dialog box: move to the previous tab | Ctrl + Shift + Tab | Control + Shift + Tab |
Dialog box: check or uncheck a box | Space | Space |
Dialog box: close without changes | Esc | Esc |
Less-Known Excel Shortcuts
These five don't get much attention, but I use them all the time.
- Ctrl + Q: opens Quick Analysis for the selected data, so you can add formatting, charts, totals or a table in two clicks.
- Ctrl + `: shows the formulas in every cell instead of their results. Press it again to switch back.
- Ctrl + ; and Ctrl + Shift + :: insert today's date and the current time as fixed values that don't change later.
- Shift + F3: opens the Insert Function dialog, where you can search for a function and fill in its arguments.
- Ctrl + Shift + O: selects every cell on the sheet that has a comment.
More Excel Keyboard Shortcuts
I have also written a separate tutorial for many of these shortcuts, with steps and examples:
- Absolute Reference
- Add Column
- Add Comments
- Add Indent
- Add New Sheet
- Align Center
- Apply Border
- Apply-Remove Filter
- Auto Fit
- AutoSum
- Check Mark
- Clear Contents
- Close
- Copy and Paste
- Currency Format
- Cut and Paste
- Delete Cell
- Delete Row(s)
- Delete Sheet
- Drag Down
- Edit Cell
- Fill Color
- Find & Replace
- Format Painter
- Freeze Pane
- Full Screen
- Group
- Hyperlink
- Insert Cell
- Insert Row(s)
- Lock Cells
- Merge-Unmerge Cells
- Open Format Cells
- Paste Values
- Percentage Format
- Print Preview
- Save As
- Select Row
- Show Formulas
- Strikethrough
- Subscript
- Superscript
- Switch Tabs (Worksheets)
- Transpose
- Undo – Redo
- Unhide Columns
- Wrap Text
- Zoom In – Zoom Out
Frequently Asked Questions
What does F4 do in Excel?
F4 has two jobs. When you are not editing a cell, it repeats your last action, like applying the same fill color to another cell. When you are editing a formula and the cursor is on a cell reference, it switches the reference from A1 to $A$1, A$1, $A1 and back to A1. On a Mac, press Cmd + T to switch references (F4 also works in Excel for Microsoft 365) and Cmd + Y to repeat the last action.
Do Windows Excel shortcuts work on a Mac?
Many of them do when you press Cmd in place of Ctrl, like Cmd + C, Cmd + V, Cmd + S and Cmd + B. But a lot of them are different. For example, turning filters on and off is Cmd + Shift + F on a Mac, and the number format shortcuts use Control, not Cmd. That's why every table on this page has a separate Mac column. On a MacBook, you may also need to hold Fn for the F1 to F12 keys.
How can I find the shortcut for any Excel command?
On Windows, press Alt, and Excel shows a KeyTip letter on every ribbon tab. Press a tab's letter to see the KeyTips for its commands. You can also hover the mouse over a ribbon button: when the command has a shortcut, the ScreenTip shows it next to the command name.
Can I create my own keyboard shortcut in Excel?
Yes. On Windows, add the command to the Quick Access Toolbar. Excel gives the first nine buttons on it the shortcuts Alt + 1 to Alt + 9, in the order they appear. For a macro, open Alt + F8, select the macro, click Options and set a Ctrl shortcut. On a Mac, go to Tools > Customize Keyboard, select the command and press the keys you want to use.
Why is my Excel shortcut not working?
Most of the time, it's one of three things. First of all, on many laptops the F1 to F12 keys control things like brightness and volume, so hold Fn with them (or turn on Fn Lock if your keyboard has one). After that, check whether another app or the system uses the same keys. For example, on a Mac Control + Space switches the input source by default, so it won't select a column until you change that in System Settings > Keyboard > Keyboard Shortcuts. In the end, the shortcuts on this page are for the US keyboard layout, and some keys sit in different places on other layouts.