Tricks for Hiding and Unhiding Excel Rows and Columns

istock_rozkmina_spreadsheet.jpg

istock_rozkmina_spreadsheet
istock_rozkmina_spreadsheet
13

Hiding and unhiding rows and columns are mundane tasks that many users take for granted. However, sometimes simple tasks can trip up Excel users, like unhiding just one row or column within a hidden set. Other users don't know simple keystroke commands that can streamline hiding and unhiding columns or rows. In this article, I'll explore these techniques as well as discuss two powerful alternatives to manually hide and unhide rows and columns. I'll also discuss how to re-enable an Excel keyboard shortcut that's disabled in any operating system subsequent to Windows XP.

Hiding Rows and Columns Let's first explore the traditional approaches to hiding rows and columns. Going forward, I'll only explain rows – simply replace the word Row with Column in any menu commands that I describe if you want to hide or unhide columns. First, select the row or rows that you wish to hide or unhide, and then carry out these steps: 

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

Replies

Please login or register to join the discussion.

avatar
By Mansooralamiugc
Jun 26th 2015 01:10

Excellent

Thanks (0)
avatar
By Nimmi
Jun 26th 2015 01:11

very useful..thanks for posting..:)

Thanks (0)
avatar
By Yousuf Mirza Baig
Jun 26th 2015 01:11

Asalam O Alaikum. Good Morning. Thank you so very much Sir David H. Ringstrom. I follow your easy steps / guidelines and now I can easily Hide and Unhide my Columns. I wish to become your student but I am very far in Saudi Arabia. Thanking you again. Good Bye Sir.

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

I'm so glad that you found my article helpful. Thank you for your kind feedback!

Thanks (0)
avatar
By TU SMK AlFurqan
Jun 26th 2015 01:11

Assalaamu alaikum
Our problem is that I HIDE the rest columns from R1C12 until the end of column, if you know what I mean. But I cannot unhide those columns again because I simply cannot select the columns.

I tried Ctrl + Shift + Right Arrow - but when i left click, there's no UNHIDE option. Would you kindly help?

http://www.smkalfurqan.com/201...

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

I recommend that you first click the button in the upper left-hand corner of the worksheet frame to select the entire worksheet. Next choose Format, Hide & Unhide, and then Unhide Columns in Excel 2007 and later, or in Excel 2003 and earlier choose Format, Column, Unhide.

Thanks (0)
avatar
By Tom willkins
Jun 26th 2015 01:11

Hello Sir
I am looking to see if there is a way to hide and unhide columns when I select a value from a drop down list. I have three values 5, 7 and 9 and each time I select one only that many columns must be selected. I was wondering is there anyway to do that or I am pushing excel beyond. Thank you in advance.

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

Tom, it's possible, but you have to use Visual Basic for Applications programming to do so. One approach is to add an ActiveX ComboBox to your worksheet, and populate the list with the numbers 5, 7, and 9. Right-click on the ComboBox, choose View Code, and then add these two lines of code within the Change event:

Range("G1").Columns.Resize(, 9).Hidden = True

Range("G1").Columns.Resize(, ComboBox1.Value).Hidden = False

Replace G1 with the actual starting point for the range of columns that you wish to hide, and ComboBox1 with the actual name of your ComboBox. ActiveX ComboBoxes are available in the Developer tab of Excel 2007 and later under the Insert command, or the Form Controls toolbar in Excel 2003. You'll have to use Design Mode to manage the properties. If you supplement this information with some Google searches you'll be able to get up to speed on the technique if you're not already familiar with VBA.

Great question, and I appreciate the opportunity to enrich my article.

Best regards,

David

Thanks (0)
avatar
By IRAE
Jun 26th 2015 01:11

What about Alt+Shift+right arrow.
this has always been the easiest way for me.

Thanks (0)
avatar
By Abhisek
Jun 26th 2015 01:11

sir how will i unhide the hide coloumn and row with use the shortkut keys.

Thanks (0)
avatar
By AT
Jun 26th 2015 01:11

great,specially Group option

Thanks (0)
avatar
By balmydrizzle
Jun 26th 2015 01:11

A much quicker way is tweaking Excel's bug if you don't mind the column width at current state, Say you hide column B-K, simply select column A to L and select auto adjust column width, all hidden columns become unhidden. This works at least in Excel 2007.

Thanks (0)
avatar
Apr 5th 2016 14:04

Nice review david, i noticed there's slight differences on the similar guidance i read:

http://gantt-chart-excel.com/how-to-unhide-rows-in-excel.html

Need further assistance please.

Thanks

Regards,

Stuart

Thanks (1)