Find, Replace, Go To, AutoSum and Fill Down Shortcuts in Excel for Mac

Quick answer: In Excel for Mac, Find is Ctrl+F (or Shift+F5), Replace is Ctrl+H (or Cmd+Shift+H), Go To is Ctrl+G (or F5), AutoSum is Shift+Cmd+T, Fill Down is Cmd+D and Fill Right is Cmd+R.

These are the everyday commands Windows users reach for first. Several keep Control on a Mac, so they are easy to get wrong if you assume Ctrl always becomes Command.

The shortcuts

TaskMacWindows
FindCtrl+F or Shift+F5Ctrl+F
ReplaceCtrl+H or Cmd+Shift+HCtrl+H
Go ToCtrl+G or F5Ctrl+G or F5
AutoSumShift+Cmd+TAlt+=
Fill downCmd+D or Ctrl+DCtrl+D
Fill rightCmd+R or Ctrl+RCtrl+R
Enter the current dateCtrl+;Ctrl+;
Enter the current timeCmd+;Ctrl+Shift+;
Insert a new sheetShift+F11Shift+F11

The combinations are from Microsoft's Excel for Mac shortcut list. Function keys may need Fn; see Function Keys in Excel for Mac: The Fn Setting and the F-Key Shortcuts That Matter.

Find and Replace

Press Ctrl+F or Shift+F5 to open the Find dialog. With a cell selected, Cmd+F searches the sheet. Ctrl+H or Cmd+Shift+H opens Replace. Choose Options in the dialog to search by formulas or values, and to match case or whole cells.

Go To

Ctrl+G or F5 opens Go To. Type a cell address such as B200, or choose Special to jump to blanks, formulas or constants.

AutoSum

Select the cell under your numbers and press Shift+Cmd+T. Press Return to accept the suggested range.

Fill Down and Fill Right

Select the source cell and the cells below it, then press Cmd+D. For fill right, select across and press Cmd+R. Both copy the first cell's content and formatting. For fill by dragging, see How to Use Fill Handle in Excel on Mac Using Keyboard?.

More everyday commands from the same list

Microsoft's Excel for Mac list also covers several commands people look for next:

  • F12: display the Save As dialog box. Option+F2 opens the Save dialog box.

  • Cmd+F12: display the Open dialog box.

  • Shift+F11: insert a new sheet.

  • F7: check spelling.

  • Shift+F2: insert or edit a cell note.

  • Cmd+Shift+F2: insert or reply to a threaded comment.

  • Cmd+F3: open the Define Name dialog box.

Function keys may need Fn depending on your keyboard setting.

Making Find and Replace safer

Replace works across whatever you have selected, so how you start matters. If you select a range first, Excel limits the search to that range. If you select a single cell, it searches the whole sheet. Review the matches with Find All before you click Replace All, and use the Options button to match case or search whole cells only so you do not change more than you meant to.

Wildcards work in Find: a question mark matches any single character, an asterisk matches any run of characters, and a tilde in front of either one finds the character itself.

Go To Special: the part people miss

In the Go To dialog, the Special button lets you select cells by type, such as blanks, formulas or constants. It is a quick way to find every gap in a column without clicking each cell.

Formatting commands

Microsoft does not list a default shortcut for Format Painter on Mac. Use the Home tab, or copy and then use Cmd+Ctrl+V and choose Formats. See Paste Values Shortcut in Excel for Mac (Plus Formulas, Formats and Transpose).

What are the Undo and Redo shortcuts in Excel for Mac?

Undo is Command+Z in Excel for Mac and Redo is Command+Y or Shift+Command+Z; Excel keeps a limited history, and closing the workbook clears the Undo list.

Press Command+Z repeatedly to step back through recent actions one at a time. The dropdown beside the Undo button in the toolbar jumps back several steps at once, which is faster after a run of edits. Excel keeps a limited history (Microsoft documents 100 actions), and undoing then making a new edit removes Redo.

On Windows, Ctrl+Z undoes and Ctrl+Y redoes. Ctrl+Y and F4 also repeat the last action on Windows, which is a separate job from redo on a Mac and depends on your function-key setting; see Why Doesn't F4 Work in Excel on Mac?.

What can Excel not undo?

Closing the workbook clears the Undo list, running a macro can clear it, and deleting a sheet cannot be undone, so save a dated copy with Shift+Command+S before large changes.

Actions that are not edits, such as switching sheets, are not on the Undo list. If a mistake cannot be undone, do not save yet: close the workbook without saving and reopen it, check Browse Version History for files in OneDrive or SharePoint, look for AutoRecover after a crash, or restore from Time Machine for local files.

Why is Undo greyed out in Excel for Mac?

Undo is greyed out when the file was just opened, a macro ran and cleared the list, or the workbook is in Protected View; click Enable Editing and make a change.

While typing in a cell, Command+Z undoes the typing inside that cell, and Esc cancels the edit entirely. After Return is pressed, the whole entry becomes a single step on the Undo list.

FAQs

What is the shortcut for Find and Replace in Excel on Mac?

Ctrl+H or Cmd+Shift+H for Replace, and Ctrl+F or Shift+F5 for Find.

What is the AutoSum shortcut on Mac?

Shift+Cmd+T.

Is there a Mac shortcut for the current date?

Ctrl+; enters the date, and Cmd+; enters the time.

How do I replace text in only part of the sheet?

Select that range first, then open Replace with Ctrl+H or Cmd+Shift+H. Excel limits the search to the selection.

What is the shortcut for Save As on a Mac?

F12 opens the Save As dialog box. Add Fn if your function keys are not standard.

What is the redo shortcut in Excel for Mac?

Command+Y or Shift+Command+Z redoes the last undone action in Excel for Mac; either works, and Redo is available only until a new edit is made after undoing.

Does saving clear the Undo list in Excel?

Not in current versions of Excel: changes can still be undone after pressing Command+S, so saving is safe mid-task. Closing the workbook does clear the Undo list, so undo before closing.

← 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.