Weekly Computer Tip # 374
24 August 2012

time-saving shortcut to select all cells in a row or column
(Excel 2003-2010)

During an Advanced Excel course yesterday one of the course participants (thanks, Gerard!) made the whole classroom fall in love with this time-saving shortcut to select all cells in a row or column:

1. Click in the first cell of the row or column you want to select.
2. Press [CTRL] + [SHIFT] + [RIGHT ARROW] key to select all nonblank cells in the row or [CTRL] + [SHIFT] + [DOWN ARROW] key to select all nonblank cells in a column.

Want to work faster and smarter? Get trained! Even if you believe you have mastered Windows or Office I guarantee you go away with new tricks, tips and shortcuts that you never would have found on your own.

.