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
nice tip….keep up the pace in the office tips
@ ReviewSaurus, Thank you….I just write tips of features what I normally use for my work…so that keeps me going:)
I have used the keyboard shortcut to “Hide” & “Unhide” columns for years and use it all the time. Just purchased a new computer running Vista “Business” and the shortcut to “Unhide a Column” does NOT work( Ctrl Shift ) )??
I have tried several Keyboards, but still the same problem. Is this a problem with Vista ??
Thank you
@BILL KALISZ, I just tried in my Vista Home Premium…I guess its a bug…It used to work in Windows XP