Tip of the week # 411
4 January 2014

Quickly extend the selection to the beginning or end of the document (Excel, Word and Outlook)

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 (see tip_306.php 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.html), but it's back on my radar. Thanks, Mike!