TipsJun 10, 20261 min read

5 Excel Shortcuts Every Mac User Should Memorize

Quick answer: The five Excel shortcuts Windows switchers miss most are Paste Special values, Paste Special formats, AutoSum, a new line in a cell and AutoFit column width. Excel for Mac has native versions of most of them, and the Mac Excel Shortcuts app lets you keep typing the Windows versions you already know.

If you spent years on Windows before switching to a Mac, the hardest habit to break isn't the dock or the missing right-click menu, it's Excel. Your fingers already know Alt+E+S+V or Alt+=. Mac Excel Shortcuts app lets you keep using them, unchanged.

1. Paste Special (Alt+E, S, V)

Paste just the value from a copied cell, formulas and formatting left behind. Essential when pulling numbers out of a templated report.

2. Paste Special: Formats Only (Alt+E, S, T)

Copy the look of a cell, borders, fill, number format, without touching what's underneath it. Great for quickly matching styles across a sheet.

3. AutoSum (Alt+=)

Select a range and drop in a SUM formula instantly. No typing, no mouse.

4. New Line in Cell (Alt+Enter)

Wrap text inside a single cell without spilling into the next one, useful for multi-line notes and addresses.

5. AutoFit Column Width (Alt+H, O, I)

Resize every selected column to fit its contents in one shortcut, no more dragging column borders by hand.

All five run natively through macOS Accessibility and Input Monitoring permissions, nothing is emulated, and nothing leaves your device.

Without the app: the native Mac versions

If you would rather learn the Mac way, each of these five has a native equivalent, apart from the last one:

  1. Paste Special, Values: press Control+Command+V, press V, then Return.

  2. Paste Special, Formats only: press Control+Command+V and choose Formats in the dialog.

  3. AutoSum: Shift+Command+T.

  4. New line in a cell: Command+Option+Return or Control+Option+Return.

  5. AutoFit column width: no default shortcut. Use the Home tab's Format menu, or double-click the border between two column headings.

What each one saves you

  • Paste Values lets you freeze a calculated column before you send a file, so the recipient sees numbers rather than formulas that break when the source changes.

  • Formats only copies the look of one cell or range to another without touching what is inside. It is the quick way to match a style across a sheet.

  • AutoSum inserts a SUM formula and selects the range for you, so adding a column takes one shortcut and one confirmation.

  • A new line in a cell keeps an address or a note in one cell instead of spilling across several. Excel turns on Wrap Text for you when you do it.

  • AutoFit resizes columns to their content, which is the clean-up step after pasting wide data.

Common mistakes with these five

  • Pasting values over the wrong range. Check that the destination is selected before confirming, because pasting values cannot be undone by re-pasting formulas.

  • Forgetting that AutoSum guesses the range. Look at the highlighted range before you press Return, especially when there are blank cells above.

  • Typing a new line and not seeing it. Wrap Text must be on for the line break to show. Excel turns it on for you, but a fixed row height can still hide the second line.

  • AutoFit on merged cells. AutoFit ignores merged cells, so unmerge or resize them by hand.

  • Using Formats only on the wrong source. Copy the cell with the exact formatting you want, not the one next to it.

A 10-minute practice drill

Open a blank workbook and do this once a day for a week:

  1. Type a few numbers in a column and AutoSum them.

  2. Copy the total and paste its value into another cell.

  3. Copy a formatted header and paste formats only onto a second header.

  4. Type a two-line address in one cell.

  5. Paste a long sentence into a narrow column and AutoFit it.

After a week, the five become automatic.

How to make them stick

Pick one shortcut and use it for a full day before adding the next. Start with Paste Values, because it replaces a long chain of mouse clicks, then add AutoSum and AutoFit, which are the two you will use after every import.

The next five to learn

Once these are automatic, add five more:

  • Format Cells: ⌘1

  • Insert today's date: ⌃;

  • Toggle absolute reference: ⌘T

  • Save As: ⇧⌘S

  • Edit the active cell: ⌃U

For more, see what are the hidden Mac Excel shortcuts and the Mac Excel shortcut cheat sheet.

FAQs

Do these five shortcuts work without the app?

Four of them have native Mac equivalents, listed above. AutoFit column width does not have a default keyboard shortcut.

Which one should I learn first?

Paste Values. It replaces the longest chain of clicks and you will use it in almost every workbook.

Can I use these shortcuts in Numbers or Google Sheets?

Copy and paste work everywhere, but Paste Special, AutoSum and AutoFit shortcuts are specific to Excel.

Why does my Windows muscle memory fail on a Mac?

Excel for Mac has no Alt-key ribbon sequences, so shortcuts such as Alt+E, S, V do nothing natively. Read what replaces ribbon access keys for the background.

Do I need to remember all five?

No. Start with Paste Values and AutoSum, which cover the largest share of daily work.

What if the shortcuts stop working?

Work through why Excel shortcuts stop working after a macOS update.

Related Articles

Save and Save As Shortcuts in Excel for Mac (⌘S, ⇧⌘S and F12)Save is ⌘S and Save As is ⇧⌘S in Excel for Mac, with F12 as the Windows-style alternative. Here is how each works, how AutoSave changes things, and how to save as CSV UTF-8 or PDF.Undo and Redo Shortcuts in Excel for Mac (⌘Z, ⌘Y and ⇧⌘Z)Undo is ⌘Z in Excel for Mac. Redo is ⌘Y or ⇧⌘Z. Here is what each does, what cannot be undone, and what to do when Undo is greyed out.Insert the Current Date and Time in Excel for Mac (Shortcuts and Formulas)On a Mac, Ctrl+; inserts today's date and ⌘; inserts the current time. Here is how to insert both, when to use TODAY() and NOW() instead, and the common mix-up.

← Back to all articles