Wednesday, May 16, 2007

Office shortcut keys

I've been doing a bit of office spreadsheet reporting these last few days and it was driving me bonkers to prepare the format the way I wanted it. What I had to do was basically highlight certain rows and delete them over and over. Now on a laptop infront of TV you could really do with shortcut keys and not the the old mouse. So I did a quick search and came up with:

Highlight Row => "Shift" + Spacebar
Highlight Column => "Ctrl" + Spacebar

To insert a row, hit "Ctrl + '+'"
To delete a row, hit "Ctrl + '-'"

Some others whilst I'm at it:
Ctrl+9 Hide Cell
Shift+Ctrl+9 Unhide The cell
Ctrl+0 Hide the Column
Shift+Ctrl+0 Unhide The Column

For the complete list for keyboard junkies visit:
www.exceltip.com

No comments: