What Are the Hidden Mac Excel Shortcuts?

Quick answer: Beyond the well-known Cmd shortcuts, Mac Excel has a set of lesser-known combinations that even experienced users miss, from Shift+Cmd+Asterisk to select only visible cells to Cmd+Shift+F3 to create names from labels. Every shortcut below is listed in Microsoft's Excel for Mac shortcut list. The Mac Excel Shortcuts app adds shortcuts for commands that have none, such as Remove Duplicates.

Most shortcut lists repeat the same top 20 everyone already knows. This list deliberately skips those. Function-key shortcuts may need Fn depending on your keyboard setting.

1. Cmd+Shift+F3: create names from labels

Select a range whose top row or left column contains labels, press this combination, and Excel opens the Create Names dialog so you can turn those labels into named ranges in one step.

2. Option-drag a cell border: copy without copy and paste

Grab the border of a selected cell or range, not the fill handle, and drag while holding Option. It duplicates the selection to the drop location instead of moving it.

3. Ctrl+Shift+U: expand or collapse the formula bar

Handy for long nested formulas that wrap over several lines.

4. Cmd+( and Cmd+): hide rows and columns

Microsoft lists Cmd+( to hide the selected rows and Cmd+) to hide the selected columns, with Shift added to unhide them. Ctrl works in place of Cmd for each of these.

5. Cmd+= or F9: calculate all open workbooks

A full recalculation across every open file, not just the active sheet. Add Ctrl+Option and F9 to calculate every worksheet in every open workbook.

Opens the Insert Hyperlink dialog for the selected cell.

7. Ctrl+Apostrophe: copy the formula from the cell above

Copies the formula from the cell above the active cell into the cell or the formula bar, which is useful when you are building a column of similar formulas.

8. Ctrl+U: edit with the cursor at the end

Edits the active cell and puts the insertion point at the end of the line, so you can append to a formula without clicking.

9. Shift+Cmd+Asterisk: select only visible cells

If some rows are hidden, this selects only what you can see, so a copy and paste skips the hidden rows.

10. Cmd+A, pressed more than once: grow the selection

The first press selects the current region around the active cell. Press it again to select the whole sheet.

11. Shift+Cmd+Return: enter an array formula

The Mac version of Ctrl+Shift+Enter. Ctrl+Shift+Return also works.

12. Cmd+Option+Return: line break inside a cell

The Mac version of Alt+Enter. Ctrl+Option+Return also works. See Alt+Enter on Mac: New Line and Wrap Text for the wrap text side of it.

Three bonus tips

  • Redo has three shortcuts. Microsoft lists Cmd+Y, Ctrl+Y and Cmd+Shift+Z for Redo, so use whichever your hand prefers.

  • Double-click the fill handle to auto-fill a formula down to the length of the adjacent column, with no dragging.

  • Show formulas: Ctrl+Grave accent (the key above Tab) toggles between cell values and cell formulas.

Hidden tricks that are not keystrokes

Some of the biggest time savers in Excel for Mac are mouse gestures that nobody tells you about:

  • Shift-drag a cell border to insert the selection between other cells instead of overwriting them.

  • Double-click a column border to AutoFit the column to its contents.

  • Option-drag a sheet tab to copy the sheet.

  • ⌘-click several sheet tabs to select sheets that are not next to each other. See the sheet shortcuts guide.

  • Double-click Format Painter to paint several areas, and press Esc to stop.

  • Type a range in the Name Box, such as A1:D200, and press Return to select it instantly.

  • Control-click any cell for the same menu as a right-click.

Why these stay hidden

Most of these fall into two groups: shortcuts that kept Control on Mac when most others moved to Command, and shortcuts for tasks people default to doing with the mouse or the Ribbon and never think to look up.

FAQs

Which Mac Excel shortcut selects only visible cells?

Shift+Cmd+Asterisk. It selects only the cells you can see, skipping rows that are hidden.

What is the Mac shortcut to show formulas in Excel?

Ctrl+Grave accent toggles between showing cell values and cell formulas.

Is there a shortcut for an array formula on Mac?

Yes, Shift+Cmd+Return or Ctrl+Shift+Return.

A one-week practice plan

Trying twelve new shortcuts at once rarely works. Spread them out:

  1. Monday: ⌘K for hyperlinks and ⌘A pressed twice for the whole sheet.

  2. Tuesday: Shift+⌘+Asterisk to select visible cells after filtering.

  3. Wednesday: ⌃U to edit with the cursor at the end of a cell.

  4. Thursday: the Cmd+Shift+F3 create-names routine on a labelled table.

  5. Friday: Option-drag to duplicate a block and ⌘⌥Return for line breaks.

Keep a sticky note of the ones you forget, and drop the ones you never need.

Do these shortcuts work in older versions of Excel for Mac?

Most have existed for years, but check the menu bar in your version. Commands that have a shortcut show it beside the name.

Why do some hidden shortcuts need fn?

Keys such as F9 sit on the function row. Turn on standard function keys or hold fn. The function keys guide explains the setting.

Where can I see the full list?

The Mac Excel shortcut cheat sheet lists 120 commands, and Microsoft publishes its own list on its support site.

← Back to all articles

Mac Excel Shortcuts: Excel shortcuts not working on Mac? Alt E S V, Paste Values, the Windows way. Try it free for 7 days.