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

  • by Carol Bratt on 20090408 @ 06:09PM EST | google it | send to friends
  • Filed under Carol's Corner Office | (related terms: cell, column, bottom, top, data)

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 CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!