Enter data and move between Excel cells on Mac
In Excel for Mac, Return completes an entry and moves forward in the selection. By default, Shift-Return moves up, Tab moves right and Shift-Tab moves left. Escape cancels a cell entry; F2 edits the selected cell.
Microsoft Excel · Reviewed 2026-11-05 · Review method
Platform, keyboard and verification notes
- Scope
- Microsoft Excel · Microsoft Excel desktop for Mac; Mac section of Microsoft documentation checked 5 November 2026. Not Excel for the web.
- Keyboard and customization
- English documentation and US-style key names. Punctuation and function keys can differ on other layouts.. These are documentation-backed defaults, not a hands-on test. App settings, operating-system shortcuts, extensions and keyboard layout can change what happens. Check focus and the current app menu or shortcut settings when a binding differs.
- Review basis
- Documentation reviewed 2026-11-05 by Codex — source and editorial review; no runtime test. These bindings were not tested in a running app for this guide.
Mac shortcuts for this workflow
| Action | Keys | Context |
|---|---|---|
| Complete entry | Return | Commit the entry and advance in the current selection. Source ↗ |
| Complete and move up | Shift-Return | Move backward vertically through the selection. Source ↗ |
| Move right | Tab | Continue across a row of entries. Source ↗ |
| Move left | Shift-Tab | Return to the previous entry position. Source ↗ |
| Cancel entry | Escape | Abandon the current uncommitted cell edit. Source ↗ |
| Edit selected cell | F2 | Fn may be needed depending on the Mac’s function-key settings. Source ↗ |
Decide whether you are moving or editing
The selected cell and the text caret inside a cell are different states. Arrow keys or typed characters can behave differently once editing begins. Use the visible formula bar and caret to identify the state before replacing a value, especially when the cell already contains a formula rather than plain text.
Choose a route that matches the table
For a row of related fields, Tab provides a predictable horizontal path. For a vertical series, Return is the more natural route. A selected range can shape the traversal, so inspect its boundary before a long entry session. Confirm headers and units first; efficient navigation cannot correct data entered into the wrong column. Excel’s editing preferences can change the direction used after Return, so confirm that setting when your movement differs.
Practice cancellation on a harmless value
Use a disposable sheet, select a populated cell, begin editing and cancel with Escape. Then enter two test values using different completion keys and observe the selection. This helps distinguish abandoning an unfinished edit from undoing an edit that was already committed. Avoid testing replacement behavior on a workbook whose original values you cannot restore.
Sources and corrections
- Keyboard shortcuts in Excel — Microsoft Support, Mac section — checked 2026-11-05
Found a mismatch? Email pashaseenainc@gmail.com with your app version, macOS version, keyboard layout and the command. Please leave personal document names out.
Keep going
Right there when you need it.
Keep a compact shortcut reference in your Mac’s menu bar.
Explore the native Mac app