Move Right Between Non-Adjacent Selections in Excel (Ctrl + Alt + Right Arrow)
This shortcut allows you to jump the active cell to the next selection in a non-adjacent selection set. It is useful when working with scattered cell selections.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Alt + Right Arrow | Cmd + Option + Right Arrow |
What Does This Shortcut Do?
Moves the active cell focus to the next selection in a group of non-adjacent cells, allowing you to efficiently navigate scattered selections without using the mouse.
How to Use the Shortcut
- Select multiple non-adjacent cells using Ctrl (Windows) or Cmd (Mac)
- Press Ctrl + Alt + Right Arrow (Windows) or Cmd + Option + Right Arrow (Mac)
- The active cell will move to the next selection in the group
Tips & Best Practices
- Useful when reviewing or formatting scattered selections quickly
- Combine with Ctrl/Cmd + Click selection to efficiently navigate
- Works in both normal worksheets and filtered data
FAQ
- Q: Can I move backward between non-adjacent selections?
- Yes, use the corresponding left arrow shortcut to move to the previous selection.
- Q: Does it work in Excel tables?
- Yes, the shortcut works in tables, ranges, and normal worksheets.
- Q: Can I combine with formatting commands?
- Yes, after navigating, you can apply formatting, copy, or delete commands to the active selection.