Move to the End of a Long Column Quickly in MS Excel

Dennis Faas's picture

This is one of those little tips that most folks aren't aware of but are ever so grateful for the knowledge once they have learned it. Why? Because it saves time and keystrokes, of course!

To jump to the bottom of a very long column, simply select a cell in the column and double-click the top or bottom edge of the cell.

In a nanosecond you will be at the bottom of the data in that column, regardless of whether it's 12,000 rows long!

To return to the top of your data, click the edge of the cell. Clicking the left or right edge of the cell works in the same manner for going across rows.

Now aren't you glad I shared that with you?

When you become a member at, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

| Tags:
Rate this article: 
Average: 4.4 (12 votes)