Excel Arrow Keys Scroll Instead of Moving Cells on Mac (Scroll Lock and Ctrl+Arrow Fixes)
Quick answer: If the arrow keys scroll the sheet instead of moving the selected cell in Excel for Mac, Scroll Lock is probably on. Microsoft documents Shift+F14 to toggle it. If you are trying to jump to the edge of your data, use Cmd+Arrow, not Ctrl+Arrow, which macOS uses for Mission Control and Spaces.
Symptoms
The whole sheet scrolls and the selected cell does not move
Arrow keys move the cursor inside a cell instead of selecting a new one
Ctrl+Arrow switches desktops or opens Mission Control
Home, End, Page Up and Page Down do not work
Likely causes and fixes
| What you see | Cause | Fix |
|---|---|---|
| Sheet scrolls, selection stays | Scroll Lock is on | Press Shift+F14 |
| Arrow moves a cursor in the cell | Cell is in edit mode | Press Return or Escape first |
| Ctrl+Arrow switches desktops | macOS shortcut conflict | Use Cmd+Arrow in Excel |
| Home or End do nothing | MacBook has no such keys | Use Fn with the arrow keys |
Fix 1: Turn Scroll Lock off
Press Shift+F14. Microsoft notes that a MacBook has no F14 key, so you may need a USB keyboard that does. An external keyboard with an F13 to F15 row works for this. If standard function keys are off, you may also need Fn. See Function Keys in Excel for Mac: The Fn Setting and the F-Key Shortcuts That Matter.
Fix 2: Use Cmd+Arrow for the edge of the data
In Excel for Mac, move to the edge of the current data region with Cmd+Arrow. Ctrl+Arrow is the Windows habit and conflicts with macOS desktop switching. Add Shift to select while moving.
Fix 3: Leave edit mode
If you are typing in a cell, arrow keys move the text cursor. Press Return or Escape to leave edit mode, then use the arrows.
Fix 4: Navigation keys on a MacBook
Microsoft documents Fn with the arrow keys for Home, End, Page Up and Page Down on a MacBook. For the full map of Windows navigation keys, see Windows Keyboard on Mac: Where Every Key Went (Ctrl, Alt, Windows, Delete, Home, End, Print Screen).
Quick test: which problem do you have?
Press an arrow key once and watch what moves:
The whole sheet slides but the selected cell stays put: Scroll Lock is on. Use Shift+F14.
A text cursor moves inside the cell: you are in edit mode. Press Escape or Return.
The highlighted area grows as you press arrows: Extend Selection mode is on, covered below.
Nothing in Excel moves and the desktop changes: a macOS shortcut such as Ctrl+Arrow took the key. Use Cmd+Arrow.
Another cause: Extend Selection mode
Microsoft lists F8 as the shortcut to extend the selection, and Shift+F8 to add to the selection. If you pressed F8 by accident, the arrow keys grow the highlighted area instead of moving the active cell. Press Escape to leave the mode, or press F8 again. Remember that F8 may need Fn on a MacBook.
Selecting while you move
Once the arrows behave, a few combinations speed up navigation: Shift+Arrow extends the selection one cell at a time, Cmd+Arrow jumps to the edge of the data region, and Shift+Cmd+Arrow selects all the way to the edge.
If you cannot reach an F14 key
Most MacBooks have no F14, so toggling Scroll Lock can feel impossible. Try these in order:
Quit and reopen Excel. Scroll Lock state often resets when the app restarts.
Borrow an extended keyboard. Any USB keyboard with F13 to F15 will do. Press Shift+F14 once, then unplug it.
Work around it. If the arrows are scrolling, you can still move the active cell by clicking, using the Name Box, or pressing ⌃G to open Go To.
Check for a remapping tool. Some utilities can send F14, but test on a copy of a workbook first.
Moving around big sheets without the arrows
Jump to a cell: press ⌃G, type the address and press Return.
Scroll to the active cell: press Control+Delete.
Move to the first or last cell: use Fn+⌘+Left or Fn+⌘+Right, depending on your keyboard.
Jump to the edge of the data: ⌘+Arrow.
Switch sheets: ⌥→ and ⌥←, covered in the sheet shortcuts guide.
Other reasons the arrows act strangely
Sticky Keys is on. A latched modifier changes what the arrow does. Turn it off in System Settings > Accessibility > Keyboard.
A frozen pane or hidden rows. The cell may be moving but off screen. Check View > Freeze Panes, and compare with the freeze panes guide.
A different app has focus. Click a cell to make sure Excel is active.
The workbook is in a special mode. Press Escape to leave Edit or Extend Selection modes.
FAQs
How do I turn off Scroll Lock in Excel on Mac?
Press Shift+F14, using an external keyboard if your MacBook has no F14.
How do I jump to the last row of data on a Mac?
Press Cmd+Down arrow.
Why does Ctrl+Arrow not work in Excel for Mac?
macOS uses Ctrl+Arrow for Mission Control and Spaces. Use Cmd+Arrow in Excel.
Why does the selection expand when I press an arrow key?
Extend Selection mode is probably on. Press Escape, or press F8 again, and the arrows will move the active cell normally.
Is there a Scroll Lock light on a Mac?
No. Microsoft documents Shift+F14 to toggle Scroll Lock in Excel, and notes you may need a USB keyboard to reach F14.
Why do my arrows move inside the formula bar?
You clicked into the formula bar or are in edit mode. Press Escape, then click a cell.
Does this happen in Numbers or Google Sheets?
No. Scroll Lock behaviour is specific to Excel.
Will a restart fix it?
Often, because the Scroll Lock state clears with the app. If it comes back repeatedly, look for the keyboard or utility that is sending the key.
