Tame your computer – simplify selection

12 Jan

If you are working with a big Excel workbook or Word document it can be cumbersome to select large chunks of data or text. You might already be in the habit of using SHIFT+CLICK (look here if you missed the tip on how to quickly select a range of cells) but after my last course in 2013 (happy 2014 everybody!) Mike Price told me about  this nifty way of selecting to the start or end of an Excel workbook.

Here’s how:

  1. Extend to the start: Click at the start of the range you want to select and press CTRL + SHIFT + HOME
  2. Extend to the end: Click at the start of the range you want to select and press CTRL + SHIFT + END

It also works in Outlook and Word (which I clearly had totally forgotten about; see tip 51), but it’s back on my radar. Thanks, Mike!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: