Tip of the week # 54128 April 2018

Move to end of a range of cells in a row or column (Microsoft Excel)
*

Back in 2006 (no, this isn't a typo!) I wrote a tip on how to quickly move
to the end of a range of cells in a row or column using keyboard shortcuts.
But as I know not everyone is a fan of shortcuts I thought I'd share a
"double-click trick" that almost does the same.

Here's how:

Point to any of the borders of a cell and wait until the mouse pointer
appears as a combination of an upward-pointing arrow and four-headed arrow.

Double-click any of the cell's borders - left, right, top or bottom.

Your cursor will jump to the edge of the range of cells. Simply double-click
again to jump in your preferred direction.

Remember, blank rows make it difficult and messy to filter and manipulate
data. If you use empty rows for visual purposes, use colours or borders
instead.

Related tips:

Tip # 143: Quickly move to the end of a range of cells in a row or column
( tip_143.html )

Subscribe to tips

Forward this page

I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.