Keyboard Shortcut to Hide and Unhide Rows or Columns in Excel

By Mr.Byte • February 29, 2008

If you are new here, Subscribe to Full Feeds or by Email or follow us in Twitter and receive free daily updates on Office and Windows Tips, Tricks and Tweaks..

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

Categories: Software, Tips
Tags: Excel, Hide, Keyboard Shortcut Keys, MS Office, Office 2007, Unhide

Share and Enjoy:

This is not the post you were looking for? Why not search within the site to find it!

Find us on Facebook

Subscribe:

Enjoyed this article? Every day we write many tips like this for Windows, Microsft Office Applications and other desktop applications.

Now you can get our tips daily in your inbox for free.
Feed Reader, Email or Twitter.

8 Responses to “Keyboard Shortcut to Hide and Unhide Rows or Columns in Excel”

How to Delete Empty Rows those are in between in MS Office Excel?
February 29, 2008 at 12:08 am | Permalink

[...] Step 4: Use the keyboard shortcut key (Ctrl + 9) to hide the rows which has highlighted cells. (Click here for keyboard shortcuts for hiding and unhiding rows and columns in Excel.) [...]
ReviewSaurus
February 29, 2008 at 1:02 am | Permalink

nice tip….keep up the pace in the office tips
Mr.Byte
February 29, 2008 at 1:23 am | Permalink

@ ReviewSaurus, Thank you….I just write tips of features what I normally use for my work…so that keeps me going:)
The Weekend Roundup « Exec.OS
March 1, 2008 at 4:14 pm | Permalink

[...] a neat little Excel trick from blog Lyte Byte, that I show you: a.) because it’s handy, and b.) because this blog is [...]
BILL KALISZ
March 15, 2008 at 9:18 am | Permalink

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
Mr.Byte
March 16, 2008 at 4:09 pm | Permalink

@BILL KALISZ, I just tried in my Vista Home Premium…I guess its a bug…It used to work in Windows XP
Jackson
March 11, 2009 at 11:08 pm | Permalink

hi there thanks for these shortcuts
Vimal
April 15, 2009 at 1:20 am | Permalink

Thanks for your help.