Free · Printable · Save as PDF
Excel Shortcut Cheat Sheet
A list of the most-used Excel shortcuts for Windows and Mac. Print this page as it is, or download the PDF with the button below.
Which one to use
- For keeping it on your desk and checking it at a glance.
- For a second screen or as a wallpaper.
Choose the key labels to print
Choose Windows or Mac with the tabs below before printing.
One A4 page · Free · No sign-up
Download the Excel shortcut cheat sheet (PDF)
A one-page A4 PDF. The surest option if you want to print it and keep it on your desk.
You can also print straight from the page. Use this PDF if you want it to fit on one sheet.
Excel shortcut cheat sheet (Windows)
| Action | Keys |
|---|---|
| Copy | Ctrl + C |
| Cut | Ctrl + X |
| Paste | Ctrl + V |
| Paste Special | Ctrl + Alt + V |
| Fill Down | Ctrl + D |
| Fill Right | Ctrl + R |
| Flash Fill | Ctrl + E |
| Select Current Region or Entire Sheet | Ctrl + A |
| Move to Edge of Data | Ctrl + Up |
| Select to Edge of Data | Ctrl + Shift + Up |
| Select Entire Column | Ctrl + Space |
| Select Entire Row | Shift + Space |
| Move to Next Sheet | Ctrl + PageDown |
| Move to Previous Sheet | Ctrl + PageUp |
| Extend Selection to Next Sheet | Ctrl + Shift + PageDown |
| Extend Selection to Previous Sheet | Ctrl + Shift + PageUp |
| Go To | F5 |
| Find | Ctrl + F |
| Replace | Ctrl + H |
| Move Up Within Selection | Shift + Enter |
| Move Left Within Selection | Shift + Tab |
| Go to A1 | Ctrl + Home |
| Go to Last Row and Column Cell | Ctrl + End |
| Extend Selection to A1 | Ctrl + Shift + Home |
| Extend Selection to Last Used Cell | Ctrl + Shift + End |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y |
| Insert Current Date | Ctrl + ; |
| Edit Cell | F2 |
| Clear Cell Contents | Delete |
| AutoSum | Alt + = |
| New Line in Cell | Alt + Enter |
| Insert/Edit Comment | Shift + F2 |
| Repeat Last Action | F4 |
| Insert Hyperlink | Ctrl + K |
| Insert Current Time | Ctrl + : |
| Action | Keys |
|---|---|
| Copy Formula from Cell Above | Ctrl + ' |
| Toggle Formula View | Ctrl + ` |
| Toggle Reference Type | F4 |
| Bold | Ctrl + B |
| Italic | Ctrl + I |
| Underline | Ctrl + U |
| Format Cells Dialog | Ctrl + 1 |
| Apply Comma Style | Ctrl + Shift + 1 |
| Copy Value from Cell Above | Ctrl + Shift + 2 |
| Apply Date Format | Ctrl + Shift + 3 |
| Apply Currency Format | Ctrl + Shift + 4 |
| Apply Percentage Format | Ctrl + Shift + 5 |
| Apply Outside Border | Ctrl + Shift + 6 |
| Insert Function | Shift + F3 |
| New Workbook | Ctrl + N |
| Open Workbook | Ctrl + O |
| Save | Ctrl + S |
| Save As | F12 |
| Ctrl + P | |
| Close Workbook | Ctrl + W |
| Insert New Worksheet | Shift + F11 |
| Insert Cells/Rows/Columns | Ctrl + Shift + + |
| Delete Cells/Rows/Columns | Ctrl + - |
| Hide Row | Ctrl + 9 |
| Hide Column | Ctrl + 0 |
| Unhide Row | Ctrl + Shift + 9 |
| Unhide Column | Ctrl + Shift + 0 |
| Toggle AutoFilter | Ctrl + Shift + L |
| Create Table | Ctrl + T |
| Open Filter Menu | Alt + Down |
| Select Visible Cells Only | Alt + ; |
| Recalculate Workbook | F9 |
| Recalculate Sheet | Shift + F9 |
| Refresh All | Ctrl + Alt + F5 |
| Create Embedded Chart | Alt + F1 |
Excel shortcut cheat sheet (Mac)
| Action | Keys |
|---|---|
| Copy | Cmd + C |
| Cut | Cmd + X |
| Paste | Cmd + V |
| Paste Special | Cmd + Option + V |
| Fill Down | Cmd + D |
| Fill Right | Cmd + R |
| Flash Fill | Cmd + E |
| Select Current Region or Entire Sheet | Cmd + A |
| Move to Edge of Data | Cmd + Up |
| Select to Edge of Data | Cmd + Shift + Up |
| Select Entire Column | Cmd + Space |
| Select Entire Row | Shift + Space |
| Move to Next Sheet | Cmd + PageDown |
| Move to Previous Sheet | Cmd + PageUp |
| Extend Selection to Next Sheet | Cmd + Shift + PageDown |
| Extend Selection to Previous Sheet | Cmd + Shift + PageUp |
| Go To | F5 |
| Find | Cmd + F |
| Replace | Cmd + H |
| Move Up Within Selection | Shift + Enter |
| Move Left Within Selection | Shift + Tab |
| Go to A1 | Fn + Left |
| Go to Last Row and Column Cell | Fn + Right |
| Extend Selection to A1 | Fn + Shift + Left |
| Extend Selection to Last Used Cell | Fn + Shift + Right |
| Undo | Cmd + Z |
| Redo | Cmd + Y |
| Insert Current Date | Cmd + ; |
| Edit Cell | F2 |
| Clear Cell Contents | Delete |
| AutoSum | Cmd + Shift + T |
| New Line in Cell | Ctrl + Option + Enter |
| Insert/Edit Comment | Shift + F2 |
| Repeat Last Action | F4 |
| Insert Hyperlink | Cmd + K |
| Action | Keys |
|---|---|
| Insert Current Time | Cmd + Shift + ; |
| Copy Formula from Cell Above | Cmd + ' |
| Toggle Formula View | Cmd + ` |
| Toggle Reference Type | F4 |
| Bold | Cmd + B |
| Italic | Cmd + I |
| Underline | Cmd + U |
| Format Cells Dialog | Cmd + 1 |
| Apply Comma Style | Cmd + Shift + 1 |
| Copy Value from Cell Above | Cmd + Shift + 2 |
| Apply Date Format | Cmd + Shift + 3 |
| Apply Currency Format | Cmd + Shift + 4 |
| Apply Percentage Format | Cmd + Shift + 5 |
| Apply Outside Border | Cmd + Shift + 6 |
| Insert Function | Shift + F3 |
| New Workbook | Cmd + N |
| Open Workbook | Cmd + O |
| Save | Cmd + S |
| Save As | F12 |
| Cmd + P | |
| Close Workbook | Cmd + W |
| Insert New Worksheet | Shift + F11 |
| Insert Cells/Rows/Columns | Cmd + Shift + + |
| Delete Cells/Rows/Columns | Cmd + - |
| Hide Row | Cmd + 9 |
| Hide Column | Cmd + 0 |
| Unhide Row | Cmd + Shift + 9 |
| Unhide Column | Cmd + Shift + 0 |
| Toggle AutoFilter | Cmd + Shift + L |
| Create Table | Cmd + T |
| Open Filter Menu | Option + Down |
| Select Visible Cells Only | Cmd + Shift + Z |
| Recalculate Workbook | F9 |
| Recalculate Sheet | Shift + F9 |
| Refresh All | Cmd + Option + F5 |
Alt techniques
| Action | Alt sequence |
|---|---|
| Paste Values | Alt, E, S, V, Enter |
| Paste Formulas | Alt, E, S, F, Enter |
| Paste Formats | Alt, E, S, T, Enter |
| AutoFit Column Width | Alt, H, O, I |
| AutoFit Row Height | Alt, H, O, A |
| Apply All Borders | Alt, H, B, A |
| Top and Thick Bottom Border | Alt, H, B, C |
| Action | Alt sequence |
|---|---|
| Freeze Panes | Alt, W, F, F |
| View Excel Side by Side | Alt, W, N -> Win+Left / Win+Right |
| Insert Row | Alt, I, R |
| Insert Column | Alt, I, C |
| Group Rows or Columns | Alt, D, G, G |
| Ungroup Rows or Columns | Alt, D, G, U |
Alt sequences operate the ribbon in Excel for Windows only; Excel for Mac has no equivalent. They are left out while Mac labels are selected.
SIMULATION
Practice the shortcuts you use at work
Once you have learned them from the sheet, try them for real in a virtual Excel and finish everyday tasks with the keyboard alone.