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 takes enough time. 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?
I’m glad you asked.
We have compiled a list of 43 keyboard shortcuts for Microsoft Excel. While 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.
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 must hold down the keys Fn before pressing any F keys, unless you have enabled those keys as standard function keys.)
43 Excel Shortcuts You’ll Definitely Want to Bookmark
These simple shortcuts can help you navigate between workbooks, sheets, rows, and columns:
|Scroll up for a selection||Shift + Return (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 the previous workbook window||CTRL + SHIFT + F6 (PC); Command + Shift + F6 (Mac)|
|Switch to the next open worksheet||CTRL + Tab (Mac only)|
|Switch to 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 the selected cell with the contents of the cell above the selected cell||CTRL + d (PC and Mac)|
|Fill the selected cell with the contents of the cell to the left of the selected cell||CTRL + r (PC and Mac)|
Formatting in Excel can be difficult if you don’t know what you’re doing. Here are some shortcuts to help you format your cells easily. To get you started, here’s a prominent formatting shortcut you might not know about:
Excel spotting shortcut
Excel’s dash shortcut will draw a line through the middle of the value or text in a 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 as percentages||CTRL + Shift + % (PC and Mac)|
|Show all values as currency (Note: replace $ with your country’s currency key)||CTRL + Shift + $ (PC and Mac)|
|Display all values in general number format||CTRL + Shift + ~ (PC and Mac)|
|Applies or removes bold formatting to selected cells||CTRL + 2 (PC); Command + b (Mac)|
|Applies or removes italic formatting to selected cells||CTRL + 3 (PC); Command + i (Mac)|
|Hide selected rows||CTRL+9 (PC and Mac)|
|Show selected rows||CTRL + Shift + ( (PC and Mac)|
|Hide selected columns||CTRL + 0 (PC and Mac)|
|Show selected columns||CTRL + Shift + ) (PC and Mac)|
|Insert the current date||CTRL + ; (PC and Mac)|
|Insert the current time||CTRL + SHIFT + : (PC); Command +; (Mac)|
|Insert a hyperlink||CTRL + k (PC); Command + k (Mac)|
|Apply an outline border to the selected cells (see screenshot below)||CTRL + SHIFT + & (PC); Command + Option + 0 (Mac)|
Here are cells with (left) and without (right) a border:
Shortcuts for selecting rows and columns
Save yourself dragging and manually selecting rows and columns with these handy keyboard tricks. To get you started, here are two shortcuts related to featured rows that you may not be aware of:
Excel Row Insert Shortcut
The Insert Row shortcut in Excel will create a new row below a highlighted cell. To insert a new row, highlight a cell or an entire row and press CTRL + Exchange + + to your keyword by literally pressing the plus sign after the Shift. This will open a small options window where you can insert a new row or column.
|Expand the selection one cell up (↑) or down (↓)||Shift + ↑ [or] Shift + ↓ (PC and Mac)|
|Expand the selection to the last non-empty cell||CTRL + SHIFT + ARROW KEY (PC); Command + Shift + Arrow key (Mac)|
|Select the entire column||CTRL+ [spacebar] (PC and Mac)|
|Select the entire row||Maj + [spacebar] (PC and Mac)|
|Select the entire sheet||CTRL + a (PC); Command + a (Mac)|
|Select only the cells visible in the current selection||High +; (PC); Command + Shift + z (Mac)|
Formulas are an important part of every marketer’s Excel toolkit. Here are a few shortcuts that will make you a formula wizard:
|Start a formula (eg “=A4+A5”)||= (ie press the “equals” sign; PC and Mac)|
|Insert the AutoSum formula||Alt + (PC); Command + Shift + t (Mac)|
|Edit the active cell||F2 (PC); CTRL + u (Mac)|
|Shows the Formula Builder after you type a valid function name in a formula||CTRL + a (PC and Mac)|
Here are some more time-saving shortcuts. To get you started, here’s a final highlight shortcut for managing the size of your Excel worksheet:
Excel row delete shortcut
Excel’s delete row shortcut will delete the row below a highlighted cell. To delete this row, highlight a cell or an entire row and press CTRL + – on the keyboard by literally pressing the minus sign after CTRL. This will open a small options window where you can “shift cells up”.
|Save your work as…||Control + Exchange + s (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)|