Tame your computer - with a double-click trick

30/04/2018

public/news/thumbnail_11roem-tip-time-logo.png

In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she explains how to move to the 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:

  1. Point to any of the borders of cell and wait until the mouse pointer appears as a combination of an upward-pointing arrow and four-headed arrow.
  2. 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:

 Quickly move to the end of a range of cells in a row or column

Quickly delete empty rows 

30 April 2018

Karen Roem offers software training and support through her company Roem Ltd.  Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk

Roem Limited

Independent, innovative software training company based in Cambridge. Registered supplier to local companies such as AstraZeneca, University of Cambridge, South Cambridgeshire District Council and NHS England.

Roem Limited directory information