During an Advanced Excel course last week, 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.
* Unless stated otherwise, these tips were written for Microsoft Office 2007. Most of what is covered however will also apply to earlier versions.
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.
PS I'm committed to sharing the best of what I know with others so please don't keep these tips a secret. If you enjoyed today's tip, please forward it to anyone you feel may benefit or reprint it (with full copyright and subscription information) in your newsletters and message boards. Got a tip to share? Submit it by emailing karen@roem.co.uk - if your tip is selected, I'll publish it along with your name; the bragging rights will last a lifetime.
28 August 2012
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 http://www.roem.co.uk
________________________________________________________