Navigation short cut – double click your edges

I have a feeling I should have known this for years and that this article will highlight an embarrassing gap in my Excel expertise, but just in case I’m not the only Excel user who hasn’t spotted this before, here goes:

Navigate by double-clicking your edges

Double-click on the edge of a selected cell to quickly move to the corresponding edge of your data area. Do it while holding down the shift key to select all the intervening cells.

Navigate by double-clicking your edges - shift to select

If you prefer using the keyboard, the equivalent shortcuts are to hold down control and press one of the arrow keys to navigate, and to hold down both the control and shift keys and press an arrow key to select. Also, control+shift+spacebar selects the entire current region.

Advertisements

2 responses to “Navigation short cut – double click your edges

  1. Like that. Useful thanks

  2. it even works in XL97, although the cursor shape doesn’t change

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s