Here’s a great shortcut you may not have heard of or maybe you have. I know I was really pleased when I was shown it, and those people who like to use the mouse a lot to navigate will like it as well, I guarantee.

Lets rock and roll with it then…..when you select a cell in Excel, as you know there is a black square put around the cell, if you double click on one of the border  lines of the cell, then Excel will move the cell selection in the direction of that cell.  i.e of you double click the bottom of the cell border the selection move downwards.

Here is an example.

Select a cell within a table of data
Double click the bottom border of the cell
Do NOT double click the fill handle tho’!

Excel will take the a cursor and select the last cell in the column that contains any data.  The same thing will happen on any cell border selected and move to the last cell in the appropriate direction with any data in it.

Now then you may be thinking that is the same as using CTRL+Left Arrow, Right Arrow etc etc?.  If the original cell you selected has data in it then they will indeed both act in the same way.

BUT

If the original cell is not within a data table then the result is not the same.

If you select an unused cell directly to the right of your data table and double click on cell the left cell border Excel will take you to the first column that contains data in your table. If however you are a few cells removed from the edge of your data table by carrying out the same actions Excel will take you to the right of your data table.

Have a click around with Excel and this shortcut to see how it behaves..its cool.

More Excel Tips

1. Perform Inexact Searches In Excel

2. Search For And Highlight Invalid Data In Excel Worksheets

3.  Open Multiple Windows For The Same Workbook

Recommended Further Learning