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
| Task | Mac | Windows |
|---|---|---|
| Find | Ctrl+F or Shift+F5 | Ctrl+F |
| Replace | Ctrl+H or Cmd+Shift+H | Ctrl+H |
| Go To | Ctrl+G or F5 | Ctrl+G or F5 |
| AutoSum | Shift+Cmd+T | Alt+= |
| Fill down | Cmd+D or Ctrl+D | Ctrl+D |
| Fill right | Cmd+R or Ctrl+R | Ctrl+R |
| Enter the current date | Ctrl+; | Ctrl+; |
| Enter the current time | Cmd+; | Ctrl+Shift+; |
| Insert a new sheet | Shift+F11 | Shift+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?.
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).
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.