MY NUMBER 1 RECOMMENDATION TO CREATE FULL TIME INCOME ONLINE: CLICK HERE
Many marketers use Microsoft Excel every day, whether it’s creating a chart, analyzing data, or running a report to present at the next team meeting.
Creating such reports in Excel is time-consuming enough. How can we spend a little less time navigating, designing, 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?
I’m glad you asked.
We have compiled a list of 43 keyboard shortcuts for Microsoft Excel. Although you can do all of these maneuvers manually, knowing these tricks will help you save time so you can focus on the things that really matter.
![Download 10 Excel Templates for Marketers [Free Kit]](https://no-cache.hubspot.com/cta/default/53/9ff7a4fe-5293-496c-acca-566bc6e73f42.png)
All of these shortcuts can be accessed on PC and Mac, so we’ve included both types below where appropriate.
(Note for Mac users: To access F keys (F1–F12), you will have to hold Fn key before pressing any F keys — unless you are enabled these 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:
| Scroll up through the selection | Shift + Enter (PC and Mac) |
| Jump to the top of the column | CTRL + ↑ (PC); Command + ↑ (Mac) |
| Jump to the bottom of the column | CTRL + ↓ (PC); Command + ↓ (Mac) |
| Jump to selection corner (Note: rotate to each corner by repeating this key) | CTRL+. (PC and Mac) |
| Close the active workbook window | CTRL + w (PC); Command + W (Mac) |
| Switch to the 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) |
| Redo the last action | CTRL + y (PC); Command + Y (Mac) |
| Fills the selected cell with the contents of the cell above the selected cell | CTRL + d (PC and Mac) |
| Fills the selected cell with the contents of the cell to the left of the selected cell | CTRL + r (PC and Mac) |
Design shortcuts
Formatting in Excel can be tricky if you don’t know what you’re doing. Here are some shortcuts to help you format cells easily. To get you started, here’s a formatting shortcut you might not have known about:
Excel’s strikethrough shortcut
Excel’s Strikethrough shortcut will strike a line through the middle of the value or text in the highlighted cell. To draw a line through a cell, highlight the cell and press CTRL + 5 on your keyboard.
| Find and replace values | CTRL + F (PC); Command + F (Mac) |
| Show all values in percentage | CTRL + Shift + % (PC and Mac) |
| Show all values as currency (Note: Replace $ with your country’s currency key) | CTRL + Shift + $ (PC and Mac) |
| Show all values in general numeric format | CTRL + Shift + ~ (PC and Mac) |
| Apply or remove bold formatting for selected cells | CTRL + 2 (PC); Command + b (Mac) |
| Apply or remove italic formatting for selected cells | CTRL + 3 (PC); Command + i (Mac) |
| Hide selected rows | CTRL+9 (PC and Mac) |
| Unhide selected rows | CTRL + Shift + ( (PC and Mac) |
| Hide selected columns | CTRL + 0 (PC and Mac) |
| Unhide selected columns | CTRL + Shift + ) (PC and Mac) |
| Enter the current date | CTRL + ; (PC and Mac) |
| Enter the current time | CTRL + Shift + : (PC); Command + ; (Mac) |
| Insert a hyperlink | CTRL + k (PC); Command + k (Mac) |
| Apply border outline to selected cells (see screenshot below) | CTRL + Shift + & (PC); Command + Option + 0 (Mac) |
This is what cells look like with (left) and without (right) a border:
Shortcuts for selecting rows and columns
Save yourself the hassle of manually dragging and selecting rows and columns with these handy keyboard tricks. To get you started, here are two featured bar-related shortcuts you might not have known about:
Excel shortcut for inserting a row
Excel’s Insert Row shortcut will create a new row below the highlighted cell. To insert a new row, highlight a cell or the entire row and press CTRL + Shift + + to your keyword by literally pressing the plus sign after Shift. This will open a small options window where you can insert a new row or column.
| Expand the selection by one cell up (↑) or down (↓) | Shift + ↑ [or] Shift + ↓ (PC and Mac) |
| Expand the selection to the last non-blank cell | CTRL + Shift + Arrow key (PC); Command + Shift + arrow key (Mac) |
| Select the entire column | CTRL+ [spacebar] (PC and Mac) |
| Select the entire row | Shift+ [spacebar] (PC and Mac) |
| Select the entire sheet | CTRL + a (PC); Command + a (Mac) |
| Select only visible cells in the current selection | Alt + ; (PC); Command + Shift + z (Mac) |
Formula shortcuts
Formulas are a big part of every marketer’s Excel toolbox. Here are some shortcuts that will make you a formula wizard:
| Start the formula (eg “=A4+A5”) | = (ie press the “equals” sign; PC and Mac) |
| Insert an AutoSum formula | Alt + (PC); Command + Shift + t (Mac) |
| Edit the active cell | F2 (PC); CTRL + u (Mac) |
| After entering a valid function name in the formula, display the formula builder | CTRL + a (PC and Mac) |
Various shortcuts
Here are some more time-saving shortcuts. To get you started, here’s the latest featured shortcut to manage the size of your Excel worksheet:
Shortcut to delete a row in Excel
Excel’s Delete Row shortcut will delete the row below the highlighted cell. To delete this row, highlight the cell or the entire row and press CTRL + – on the keyboard by literally pressing the minus sign for CTRL. This will open a small options window where you can “move cells up.”
| Save your work as… | Control + Shift + with (PC); Command + Shift + s (Mac) |
| Open the spelling and grammar checker | F7 (PC and Mac) |
| Insert a comment (see screenshot below) | Shift + F2 (PC and Mac) |
MY NUMBER 1 RECOMMENDATION TO CREATE FULL TIME INCOME ONLINE: CLICK HERE