43 Handy Excel Shortcuts You Can’t Live Without

Rate this post


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.

Download 10 Excel templates for marketers [Free Kit]

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

Navigation shortcuts

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)

Format shortcuts

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:

Excel spreadsheet without border outline Excel spreadsheet with a contour border applied around cells

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)

Formula shortcuts

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)

Various shortcuts

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)

Insert a comment in Excel

excel marketing templates

excel templates



Source link

Leave a Comment