Excel Mac Shortcut Keys: Essential Commands and Tips

Excel for Mac shortcut keys combine the Command (⌘), Option (⌥), Control (⌃), and Shift (⇧) keys with letters, arrows, or function keys. Start with ⌘+C to copy, ⌘+V to paste, ⌘+Z to undo, ⌘+S to save, and ⌘+F to find; these cover many everyday tasks. The exact key may differ from Excel for Windows, so use the Mac equivalents below rather than assuming a Windows shortcut will work.

How Mac Excel shortcuts differ from Windows

The biggest change is the modifier key: many Windows shortcuts use Ctrl, while their Mac counterparts use Command. For example, copying is Ctrl+C on Windows and ⌘+C on Mac. Option and Control also appear in Mac shortcuts, and they are not interchangeable with Command. On a Mac keyboard, the Command key is usually marked ⌘, Option is marked ⌥, and Control is marked ⌃.

Excel for Microsoft 365 on Mac shares many commands with the Windows edition, but not every shortcut maps one-to-one. Menu commands and shortcuts can also vary with Excel version, keyboard layout, and macOS settings. If a key combination below does not work, check the relevant menu for the command or search Excel Help for its current shortcut.

Command: Commonly replaces Ctrl for actions such as copy, paste, save, and find.
Option: Used in some Excel-specific combinations, including certain formula and function-key shortcuts.
Control: Still has its own uses in Excel; do not automatically replace every Windows Ctrl with Command.
Fn or Globe: May be needed to send a function-key command such as F2 from a Mac laptop keyboard.

Shortcut behavior can also depend on the keyboard language and whether another macOS app has claimed the same combination. These are practical reasons to verify a shortcut in the version of Excel you use, especially before relying on it during a timed or repetitive task.

Everyday shortcuts for files and editing

These basic commands are useful whether you are entering a few values or working in a large workbook. They are also among the easiest to remember because the Mac versions use familiar Command-key combinations.

⌘+N: Create a new workbook.
⌘+O: Open a workbook.
⌘+S: Save the current workbook. Save regularly, particularly before a major edit.
⌘+P: Open the print interface.
⌘+C, ⌘+X, and ⌘+V: Copy, cut, and paste the current selection.
⌘+Z: Undo the most recent action. Press it again to undo earlier actions where available.
⌘+Y: Redo an action that was undone, when redo is available.
⌘+F: Find text or values in the workbook.

Copying and pasting cells can carry more than their displayed values: formatting, formulas, and other cell properties may come along too. If you need only the result of a formula, use Excel’s Paste Special options after copying rather than assuming ordinary paste will remove the formula. The Paste Special interface is also a useful alternative when a remembered shortcut differs across versions.

Moving around a worksheet

Keyboard navigation is most useful when a sheet has more rows or columns than fit on screen. In Excel for Mac, Command plus an arrow key moves toward the edge of the current data region in that direction. For example, from a filled cell in a continuous column, ⌘+↓ moves toward the last filled cell in that contiguous region. A blank cell or a gap can change where the movement stops, so this is not always the same as jumping to the final row of the worksheet.

To select cells while moving, hold Shift as well. For instance, ⇧+⌘+↓ extends the selection from the active cell toward the edge of the current data region below it. This is handy for selecting a block of adjacent entries, but inspect the highlighted range before formatting or deleting anything. A blank row in the middle of a dataset can make a selection end sooner than expected.

For a small, precise move, use the arrow keys to change the active cell one cell at a time. You can also click the Name Box beside the formula bar and type a cell address such as D250 to go directly to that location. The Name Box is a dependable alternative when function-key behavior or large-range navigation is inconvenient.

Entering, editing, and formatting cells

When a cell is selected, start typing to enter a value or formula. Press Return to commit the entry. To edit the contents of the selected cell rather than replace them, use F2; on some Mac keyboards you may need to press Fn+F2 or Globe+F2. Double-clicking the cell or editing in the formula bar are mouse-based alternatives.

⌘+1: Open the Format Cells dialog, where you can adjust number formats, alignment, fonts, borders, and other cell formatting.
⌘+B: Toggle bold formatting for the selection.
⌘+I: Toggle italic formatting.
⌘+U: Toggle underline formatting.
⌘+D: Fill down, copying the top cell’s contents or formula into the selected cells below it.
⌘+R: Fill right, copying the leftmost cell’s contents or formula across the selected cells.

Fill Down is useful for extending a formula through a column. For example, if C2 contains a formula and C2:C20 is selected, ⌘+D fills the selection downward using the top cell as the source. Check relative and absolute references before filling: a reference such as A2 normally changes as it is copied, whereas $A$2 stays fixed.

Finding data and working with formulas

Use ⌘+F to locate a word, number, or other value in a workbook. Search is particularly useful before editing a large sheet, but take care to distinguish a displayed result from the underlying formula or value. A cell may display a rounded number even though Excel stores more decimal places, for example.

For a simple total, enter a SUM formula directly or use Excel’s AutoSum command. With expense amounts in B2:B6, the formula =SUM(B2:B6) returns their total. If those cells contain 12, 18, 9, 15, and 6, the result is 60. The formula uses Excel’s standard comma argument separator where a function has multiple arguments; this particular SUM range requires no comma.

AutoSum can suggest a nearby range, but always confirm the highlighted cells before accepting the result. A blank cell or an unrelated number next to the data can affect the suggested range. If you need to inspect how a value is calculated, select the cell and look at the formula bar; this can help explain why a formula result changes after editing its inputs.

Function keys and Mac keyboard settings

Many Mac laptops treat the top row as brightness, volume, and other hardware controls by default. Excel shortcuts that require F2 or another function key may therefore need Fn or the Globe key held down. If you frequently use function-key commands, macOS keyboard settings may let you use F1, F2, and the other function keys as standard keys instead; the exact settings wording and location can vary by macOS release and keyboard.

There is no need to change system settings just to edit a cell. Try Fn+F2 first, or use a double-click or the formula bar. If a shortcut appears to trigger a Mac feature rather than Excel, check whether it includes a function key and whether macOS or another application uses the same combination.

External keyboards can label modifier keys differently or place them in a different physical order. Focus on the symbols and key names, not only their position. If you use a non-Apple keyboard, its Windows and Alt labels may correspond to different Mac modifiers depending on the keyboard and its configuration.

Common shortcut problems and safe habits

A shortcut that works in one context may do something different in another. For example, the active cell, an open dialog, or text-editing mode can affect what Excel does when you press a key combination. If nothing happens, first click a worksheet cell and try again. If the result is unexpected, undo immediately with ⌘+Z when the action is undoable.

Check the selection: A formatting or fill shortcut may affect every selected cell, not just the active one.
Watch for blank rows or columns: They can stop navigation or range selection at a data-region boundary.
Confirm before destructive edits: Shortcuts for cut, paste, or deletion can change a large selection quickly.
Save important work: Use ⌘+S before a batch of edits or after a significant change.
Use menus when uncertain: A visible menu command makes the intended action clearer than guessing a Windows combination.

Undo is helpful, but it is not a substitute for a saved copy. Some operations cannot be undone, and actions in connected files or external systems may not be recoverable from Excel’s undo history. When experimenting with unfamiliar commands on an important workbook, duplicate the file first.

Mac and Windows shortcut comparisons

For common file and editing tasks, the simplest comparison is to substitute Command for Ctrl: Windows Ctrl+C is Mac ⌘+C, and Windows Ctrl+S is Mac ⌘+S. That pattern is useful, but it is not a universal conversion rule. Excel’s navigation, function-key, and ribbon-related shortcuts can differ more substantially, and a Windows instruction that uses Alt may not have a direct Mac equivalent.

If a colleague shares a Windows shortcut, look up the command by name in Excel for Mac instead of mechanically changing the modifier. For instance, a Windows instruction may describe a command using a key that is absent or behaves differently on a Mac keyboard. The ribbon or menu can provide the command even when the keystroke is different. This is especially important for workbooks used by people on both platforms: the workbook data and formulas may be shared, while keyboard habits remain platform-specific.

Frequently Asked Questions

What is the shortcut for copy and paste in Excel on a Mac?
Use ⌘+C to copy and ⌘+V to paste. To cut rather than copy, use ⌘+X. These are the standard Mac equivalents of the common Windows Ctrl combinations.

How do I undo or redo in Excel for Mac?
Use ⌘+Z to undo and ⌘+Y to redo when the action can be redone. Some operations are not included in Excel’s undo history, so save important work before making substantial changes.

How do I edit the active cell with a Mac keyboard?
Press F2. On a Mac laptop, you may need Fn+F2 or Globe+F2 if the function row controls hardware features. Double-clicking the cell or using the formula bar is another option.

Why do Windows Excel shortcuts not work on my Mac?
Windows and Mac use different modifier keys and sometimes different combinations. Many common Ctrl shortcuts use Command on Mac, but not all shortcuts follow that pattern. Search for the command in Excel’s menus or Help if a conversion does not work.

What is the shortcut to select data to the end of a column?
From a cell in a continuous data region, press ⌘+↓ to move toward its lower edge. To select cells while moving, use ⇧+⌘+↓. Blank cells can stop the movement, so check the selected range before applying changes.

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.