6 Keyboard Shortcuts For Moving Within A Range Selection

These are keyboard shortcuts for moving the active cell around a selected range of cells.

Enter – Move the active cell one cell in a direction based on your settings. This is down by default.
Shift + Enter – Moves the active cell up to the previous cell in the range.
Tab – Moves the active cell to the right in the range.
Shift + Tab – Moves the active cell to the left in the range.
Ctrl + Period – Moves the active cell to the next corner of the range in a clockwise fashion. This does not move to corners in non continuous ranges.
Shift + Backspace – Collapse the selected range to just the active cell in the range.

About the Author

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.