TheExcelAddict .com
Microsoft Excel 'Quick Tip'

Double-Clicking Saves Scrolling

To quickly jump to the end of a range of data in your Excel worksheet, you can double-click the border of the active cell in the direction you want to move.

For example, if you double-click the bottom edge of the active cell, you will instantly jump to the last cell in that column.

If there are any blank cells in the column, the cell immediately above the blank cell will be selected.

Once you have that technique mastered, you can hold down the SHIFT key while double-clicking the edge of the active cell to select a range of cells from the beginning cell to the cell immediately above the first blank cell.

Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the TheExcelAddict.com/Newsletter.htm and you could win a really cool prize.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright All Rights Reserved by

Close this window