Weekly Computer Tip # 143
11 February 2006

quickly move to the end of a range of cells in a row or column (Microsoft Excel)

I'm sure you all know by now that I absolutely love keyboard shortcuts. OK, they have to be intuitive otherwise I won't remember them (and hence won't use them), but there is a pretty instinctive way to move to the top or bottom, start or end of a range of cells in Excel, without ending up on row 65536 because your mouse is more like a shopping trolley. (Going anywhere but where you want it to go.)

Here's how: (to move to the)

1. end of a range of cells in a column: press CTRL + Down Arrow
2. top of a range of cells in a column: press CTRL + Up Arrow
3. end of a range of cells in a row: press CTRL + Right Arrow
4. start of a range of cells in a row: press CTRL + Left Arrow

Be aware it'll jump to the edge of the range of cells, so if there is an empty cell within your row or column it'll pause. But simply press the CTRL key and the relevant ARROW KEY to continue.

For some other time-saving keyboard shortcuts in Excel you might want to have another look at tip # 70 (http://www.roem.co.uk/tip_70.html) and #37 (http://www.roem.co.uk/tip_37.html).

Until next week.

PS 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.

Home   Training   Support   Clients   Contact Details   News   Disclaimer