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.
And while we’re on the topic of working within an already selected range, in case you didn’t know, if you edit the contents of a cell and then use Enter, you will find that you were allowed to make the change without losing the highlight of the range.
Also, if you make that change and then use Ctrl + Enter, you will fill the entire range with that same data.
Whew. Check it out today!