Excel Mac Keyboard Shortcuts: Essential Keys and Tips

In Excel for Mac, use Command+C, Command+V, and Command+Z to copy, paste, and undo; use Command+Arrow to move to the edge of a data region, and Command+1 to open Format Cells. The shortcuts below cover everyday editing, navigation, formatting, and formulas, with Windows equivalents where the key difference matters.

How to read Mac shortcut keys

Mac shortcut instructions use names for modifier keys rather than symbols. Command is the ⌘ key, Option is ⌥, and Control is ⌃. The plus sign means to hold the keys together: for Command+C, hold Command and press C. On many Mac keyboards, Option performs the role that Alt performs on Windows, but not every Excel shortcut swaps those keys one-for-one.

Function keys can be a source of confusion. On a MacBook, F1 through F12 may control screen brightness, volume, or other hardware features by default. If Excel needs an F-key command, you may have to hold Fn (or the Globe key) as well, or change the function-key setting in macOS. The exact behavior depends on the keyboard and macOS settings.

Copy, cut, and paste: Command+C, Command+X, Command+V. Windows uses Ctrl+C, Ctrl+X, and Ctrl+V.
Undo and redo: Command+Z and Command+Y. Windows uses Ctrl+Z and Ctrl+Y.
Save and find: Command+S and Command+F. Windows uses Ctrl+S and Ctrl+F.
Open the Format Cells dialog: Command+1. The Windows equivalent is Ctrl+1.

These are Excel desktop shortcuts, not universal Mac shortcuts. An app, a browser, or macOS itself may use the same key combination for another action.

Move around a worksheet faster

For short movements, use the arrow keys to move one cell at a time. To jump across a block of filled cells, press Command with an arrow key. For example, if B2:B50 contains an uninterrupted list, select B2 and press Command+Down to move to the bottom edge of that data region. If there are blank cells within the list, the jump stops at an edge or blank boundary rather than necessarily reaching the last item.

Windows uses Ctrl+Arrow for the comparable jump. On Mac, Command+Left and Command+Right move toward the beginning and end of the current row’s data region. Use Ctrl+Home to go to the start of the worksheet and Ctrl+End to reach the last cell Excel considers used. The latter may be beyond the visible data if cells were previously formatted or edited.

Use Page Up or Page Down to move vertically by a screen. On many MacBook keyboards, use Fn+Up Arrow or Fn+Down Arrow for these keys.
Use Option+Page Up or Option+Page Down to move horizontally by a screen, if your keyboard provides those page keys or their Fn combinations.
Press Ctrl+G to open Go To, then enter a reference such as D25 to jump directly to that cell. Ctrl+G is also the Windows shortcut.
Press Command+F to search the sheet. Use Ctrl+H to open Replace in Excel for Mac; check the dialog before replacing, especially when the workbook has many sheets.

Navigation shortcuts move the active cell; they do not change the worksheet’s contents. If a jump seems to skip rows, look for blank cells, hidden rows, or a discontinuity in the data before assuming Excel has lost information.

Select cells, rows, and columns

Shift combined with an arrow key extends the selection one cell at a time. To select a larger continuous region, click its first cell, then use Command+Shift with an arrow to extend toward the edge of the adjacent data region. This is useful for selecting a column of figures without dragging through dozens of rows. As with navigation, blank cells can affect where the selection ends.

Shift+Space selects the entire row containing the active cell.
Control+Space selects the entire column containing the active cell. On some Macs, Control+Space is also assigned to switching input sources, so macOS may take over the shortcut.
Command+A selects the current data region or, with repeated use, a larger scope such as the full worksheet. What it selects depends on where the active cell is and whether the sheet contains a table or contiguous data.

Windows commonly uses the same Shift+Space and Ctrl+Space combinations for row and column selection. If Control+Space changes your keyboard language instead, adjust the macOS input-source shortcut or use the mouse to select the column header.

Edit cells and repeat common actions

Press F2 to edit the active cell’s contents without replacing them. On a MacBook, Fn+F2 may be needed if the function row is assigned to hardware controls. Press Return to commit an edit, or Escape to cancel the edit and keep the previous value. Double-clicking a cell also starts editing, but F2 can be more precise when you want to change a formula without reaching for the mouse.

When editing a formula, use the arrow keys to move the insertion point or select a cell reference, and take care not to overwrite the formula accidentally. If you begin typing while a cell is selected but not in edit mode, the new text replaces its existing contents. Press F2 first when the goal is to revise only part of the entry.

Command+C, Command+X, and Command+V copy, cut, and paste. Their Windows counterparts use Ctrl instead of Command.
Command+Z undoes the latest action; Command+Y redoes it in Excel for Mac. Undo history is limited, and some operations cannot be reversed.
Control+D fills down from the cell above into the selected cells. Control+R fills right from the cell to the left. These shortcuts are also used in Windows Excel.
To add a line break inside a cell while editing, press Control+Option+Return. In Windows Excel, the comparable shortcut is Alt+Enter.

Filling down copies the source cell’s contents or pattern into the selected range, so check whether the source is a value, formula, or formatting before applying it. For a formula, relative references may adjust as Excel fills the cells.

Format numbers and text with fewer clicks

Command+1 opens the Format Cells dialog, where you can choose categories such as Number, Date, Currency, or Percentage and adjust alignment, borders, and other cell settings. The Windows equivalent is Ctrl+1. This dialog is useful when a ribbon button does not provide the precise number of decimal places or display format you need.

Command+B toggles bold, Command+I toggles italic, and Command+U toggles underline. Windows uses Ctrl+B, Ctrl+I, and Ctrl+U.
Use Command+1 when you need more control than a quick ribbon button provides, such as setting a specific decimal count or choosing a date display.
Formatting changes how a value appears; it does not necessarily change the underlying value. A date formatted differently is still stored as a date serial value in Excel.

Shortcuts are most useful when you know the intended result. For example, if a column of decimal values should display as percentages, applying a percentage format changes their display scale. Confirm the values are already stored as proportions—such as 0.25 for 25%—before formatting, or the displayed result may be far larger than intended.

Work with formulas and calculation

When entering a formula, start with an equals sign just as you would on Windows. For example, type =SUM(B2:B10) in a cell to add the values in B2 through B10. Press Return to enter it. Excel for Mac supports the same formula syntax and worksheet functions as current Windows Excel for Microsoft 365 in most everyday cases, although some features and rollout timing can differ.

Use Command+F to find a value in a worksheet, then review the selected match before editing it. Search can locate text or numbers, but results depend on the Find options, including whether Excel searches within formulas or displayed values. If a formula looks correct but returns an unexpected answer, inspect the referenced cells and the calculation settings rather than relying only on the displayed result.

Shortcuts do not replace formula references or correct calculation logic. For instance, fill-down can efficiently copy a formula, but relative references shift as the formula moves. If a reference must remain fixed, add dollar signs to it, such as $B$2, before filling. On Mac, Excel’s formula editing behavior is broadly familiar to Windows users; a keyboard layout or function-key setting is more likely to cause a shortcut difference than the formula itself.

Excel for Mac and Windows: what changes

The main difference is usually the modifier key. In many common shortcuts, Mac Excel uses Command where Windows Excel uses Ctrl: copy is Command+C versus Ctrl+C, save is Command+S versus Ctrl+S, and Format Cells is Command+1 versus Ctrl+1. However, some Mac Excel commands use Control, so do not mechanically replace every Windows Ctrl with Command.

Navigation is another notable difference: Command+Arrow moves to the edge of a data region on Mac, while Ctrl+Arrow does so in Windows. In contrast, F2 for editing a cell, Ctrl+G for Go To, and Control+D for fill down are examples that can use the same named keys on both platforms. The physical keyboard may still make a shortcut feel different, especially when an F-key requires Fn.

Excel for the web adds another complication because it runs in a browser. Browser shortcuts can overlap with Excel commands, and the web app may display a different shortcut for an action. If a key combination opens a browser feature or does nothing, check Excel’s in-app shortcut help and use the ribbon command as a fallback. A shortcut listed for desktop Excel is not guaranteed to work identically in the web version.

When a Mac shortcut does not work

Start by confirming that Excel has focus and that you are in the desktop app rather than a browser tab. Then check whether a function key needs Fn, whether macOS has assigned the same combination to a system feature, and whether the active cell is being edited. For example, Command+Arrow behaves differently from an arrow key alone, while F2 may be intercepted by a MacBook’s hardware controls.

Try the menu command or ribbon button. If it works there, the issue is likely a key conflict or keyboard setting rather than the Excel feature.
Check for a macOS conflict, especially with Control+Space, media keys, and shortcuts used to change input sources or switch apps.
Look at Excel’s displayed menus and help for the version installed. Microsoft can update Microsoft 365, and shortcut availability can vary by release, keyboard layout, or region.
On a non-US keyboard, punctuation and symbol shortcuts may require different physical keys. Use the key labels shown by your keyboard layout rather than assuming the US layout.

macOS can assign a keyboard shortcut to a specific menu command through its app-shortcut settings, but this is not a universal way to remap every Excel action. The menu title must match the command, and a custom assignment can conflict with another shortcut. If you customize one, test it in a copy of an important workbook and keep a note of the original command.

Frequently Asked Questions

What is the shortcut for copy and paste in Excel on a Mac?
Use Command+C to copy, Command+X to cut, and Command+V to paste. Windows Excel uses Ctrl with the same letters. If you only want to paste values or formatting, use Excel’s Paste options rather than assuming the standard paste shortcut will apply a special paste mode.

How do I select an entire column in Excel for Mac?
Press Control+Space while a cell in that column is active. If macOS switches input sources instead, use the column header or change the conflicting macOS keyboard shortcut. Shift+Space selects the active row.

How do I jump to the last used cell?
Press Ctrl+End in Excel for Mac. The last used cell may be farther down or to the right than your visible data if the sheet contains old formatting or previously edited cells. Use Ctrl+Home to return to the start of the worksheet.

Why does F2 not edit a cell on my Mac?
Your keyboard may use the function row for brightness or media controls. Try Fn+F2, or check the macOS setting that controls how the function keys behave. You can also double-click the cell to edit it.

Are Excel Mac shortcuts the same as Windows shortcuts?
Many commands are equivalent, but the modifier often changes: Command on Mac commonly corresponds to Ctrl on Windows. Some Excel shortcuts use Control on Mac too, and the function row and macOS system shortcuts introduce additional differences. Check the command in your installed Excel version if a shortcut fails.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.