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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment