43 Handy Excel Shortcuts You Can't Live Without
By kvolovich@hubspot.com (Kristina Volovich)
![Download 10 Excel Templates for Marketers [Free Kit]](https://no-cache.hubspot.com/cta/default/53/9ff7a4fe-5293-496c-acca-566bc6e73f42.png)
Many marketers use Microsoft Excel every day, whether it’s to create a chart, analyze data, or run a report to present at the next team meeting.
Creating reports like these in Excel is time-consuming enough. How can we spend a little less time navigating, formatting, selecting, and entering formulas for our data? Wouldn’t it be great if there were keyboard shortcuts that could help us get our work done faster?
So glad you asked.
We’ve put together a list of 43 keyboard shortcuts for Microsoft Excel. Although you can do all of these maneuvers manually, knowing these tricks will help save you time so you can focus on the stuff that really matters.
All of these shortcuts can be accessed on PC and Mac, so we’ve included both types below where applicable.
(Note for Mac users: To access the F keys (F1–F12), you’ll have to hold the Fn key before pressing any F key — unless you’ve enabled those keys as standard function keys.)
43 Excel Shortcuts You’ll Definitely Want to Bookmark
Navigation Shortcuts
These simple shortcuts can help you navigate between workbooks, sheets, rows and columns:
| Move up through a selection | Shift + Enter (PC and Mac) |
| Jump to the top of a column | CTRL + ↑ (PC); Command + ↑ (Mac) |
| Jump to the bottom of a column | CTRL + ↓ (PC); Command + ↓ (Mac) |
| Jump to the corner of a selection (Note: Rotate to each corner by repeating this keystroke) | CTRL + . (PC and Mac) |
| Close the active workbook window | CTRL + w (PC); Command + W (Mac) |
| Switch to previous workbook window | CTRL + Shift + F6 (PC); Command + Shift + F6 (Mac) |
| Switch to the next open worksheet | CTRL + Tab (Mac only) |
| Switch to the previous open worksheet (Mac) | CTRL + Shift + Tab (Mac only) |
| Start a new chart sheet | F11 (PC and Mac) |
| Insert a new sheet | Shift + F11 (PC and Mac) |
| Repeat the last action | CTRL + y (PC); Command + Y (Mac) |
| Fill selected cell with the content in the cell above selected cell |
