Excel+Navigating+the+Selected+Range

Excel Navigating the Selected Range

If you have a large range selected ( Highlighted ) in MS Excel? And you need to move the selected cell, within the highlight, to another location to check data or functions? The last thing you want to do is remove the Highlight and then re-highlight it all again when you have finished

• Solution:- • 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.  