Saturday, April 16, 2011

Excel: Ctrl + [SpaceBar] & Shift + [SpaceBar]

I recently found out about this amazing keyboard trick on Excel.

Select any cell on your worksheet.
Press Ctrl + [SpaceBar]
Excel will highlight the whole column!

Select a different cell on the worksheet.
Press Shift + [SpaceBar]
Excel highlights the whole row!

Press Ctrl+Shift+[SpaceBar] and Excel highlights the whole worksheet!

Neat!
Related Posts Plugin for WordPress, Blogger...