#231 Navigating a Selected Range of Cells in Excel

[nogallery]

If you do much work at all in Excel, you probably already know a few handy keyboard shortcuts that take you to the very beginning and very end of your worksheet’s data.

CTRL + Home takes you to cell A1 and CTRL + End takes you to the end of your worksheet’s data which is often helpful. But, what can you do if you select a large range of cells in the middle of your spreadsheet that you’d like to navigate? In this case, jumping to the very beginning or very end is of no use.

Navigating a Selected Range

Fortunately, you can navigate through a selected range by changing the active cell and move quickly around that range. To change the active cell, select a range of cells and then press
CTRL + .

This jumps you to the next clockwise corner of your selected range. Simply repeat it to continue on to the next corner until you get where you want to be.

Changing a Selected Range

You can also use a SHIFT + any arrow key combination to expand or shrink the cells included in your selected range.

See It In Action

Like it? Hate it? Have any questions? Have a better idea? Let me know!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s