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.

Excellent

Thanks (0)

very useful..thanks for posting..:)

Thanks (0)

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)

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

Thanks (0)

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)

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)

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)

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)

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

Thanks (0)

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

Thanks (0)

great,specially Group option

Thanks (0)

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)

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)