I write lots of tips on Keyboard Shortcuts for different applications especially for Windows and Office applications as they help to increase the efficiency during work and most of the time eases the work.
So here is another keyboard shortcut tip on how to hide and unhide rows or columns in Excel?
To hide selected rows – Ctrl + 9
To hide selected columns – Ctrl + 0
To unhide hidden rows within the selected range – Ctrl + Shift + (
To unhide hidden columns within the selected range – Ctrl + Shift + )
This applies to Office 2007 and earlier versions.
I found these shortcuts when I was trying to figure out how to delete empty rows in excel