Navigating the Selected Range

Have a large range selected in MS Excel?

Need to move the selected cell, within the highlight, to another location to check data or functions?

I know you’re not considering the idea of simply clicking somewhere else, taking a look at your data and then reselecting the range all over again, are you?

Let’s hope there’s a better way!

Here’s a list of quick key options you can use for moving within an already selected (highlighted) cell range:

• Enter will move you from top to bottom within the selected range, one cell at a time. (If you used the Options window to change the selection direction after an Enter, it will move in this direction instead).
  
  
• Shift + Enter will move you from bottom to top within the selected range, one cell at a time.
  
  
• Tab will move you from left to right within the selected range, one cell at a time.
  
  
• Shift + Tab will move you from right to left within the selected range, one cell at a time.
  
  
• Ctrl + . (period) will move you clockwise to the next corner of the selected range.
  
  
• Ctrl + Alt + Right Arrow, for nonadjacent cells within the range, will move you to the next selection to the right in the range.
  
  
• Ctrl + Alt + Left Arrow, for nonadjacent cells within the range, will move you to the next selection to the left in the range.