Most valuable professional
  • Excel Book Excerpt

Excel Jump to the Edge of the Data

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Jump to the Edge of the Data

Problem: I have thousands of rows of data. I want to quickly move to the edge of the data using my mouse.

Strategy: To jump to the bottom of the data, double-click the bottom edge of the active cell.

LE10000041.jpg 

Figure 77 Double-click the bottom of the active cell.

Result: Excel will navigate down until the cell before a blank cell.

Additional Details: Double-click the right edge of the active cell to move to the right edge of the data.

Alternate Strategy: For keyboard fans, using Ctrl+Down Arrow or pressing End followed by the Down Arrow will do the same thing.

 

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: