A Simple Excel Trick to Navigate…One I just Discovered on Accident

Today I learned an Excel trick that really amazed me! I’ve been teaching Excel for a long time and never knew you could double click on the edge of a selected cell to navigate in 4 directions. If you double click on the bottom edge of cell it will navigate to the bottom row. If you double click on the top part of the selected cell, it will navigate to its header. Left and right clicking take you to the sides, horizontally.

double click in Excel to navigate

Hold down the shift key while you double click and it will make a selection of all the cells starting from the start to end of the range.

About Steve Chase

I'm a proud husband and dad to 4 boys! Microsoft Certified Trainer and Boy Scout Leader are some of things I call myself. The Cincinnati Reds are my favorite team! When not outdoors, I enjoy working with documents in Microsoft Office, QuickBooks, Visio and Photoshop. My wife, Erin, shares her awesome recipes on her blog at 5dollardinners.com.
This entry was posted in Excel. Bookmark the permalink.

One Response to A Simple Excel Trick to Navigate…One I just Discovered on Accident

  1. very helpful thanks 2 U & Microsoft Programming..

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