Navigate through your selected range by changing the active cell (Excel 2003/2007)

You may already know about a few handy shortcut keys that take you to the beginning and end of your worksheet’s data. Pressing [Ctrl][Home] takes you to cell A1 and pressing [Ctrl][End] takes you to the end of your worksheet’s data. However, what if you select a large range spanning more than one screen, and you’d like to navigate through it? It may not necessarily include the beginning or end of your data, so the shortcut keys we mentioned earlier aren’t efficient.

Fortunately, you can navigate through a selected range by changing the active cell (the cell where you started the selected range). Since Excel takes you to the active cell, you can use this to move quickly through a selected range of data. To change the active cell, select a range of cells and then press [Ctrl][+][.]. Excel jumps to the next clockwise corner of your selected range. Press the same key combination to cycleThrough each corner of your selected range.

You can also use a [Shift][arrow key] combination to expand or contract the selected range from the range’s origin (which is also the active cell). It’s navigation with an extra perk.