Posted: November 27, 2019

Need a hand to unhide columns in Excel?  

There are different methods or unhiding available to you, depending on the version of Excel you are using. 

I'll take you through the method that will work on any version. 

Then I'll quickly cover what's on offer in the newer versions and then I'll take you through how to unhide column A or row one, which is a bit tricky. 

So stick with me and I'll show you a tip on how to get them back.  

Read on!

How to unhide columns in Excel (in any version)  

Hiding columns is actually quite easy. It's the getting them back that's a bit of a challenge! ?

In the example below you can see that columns B and C and H to J are missing, so of course they have been hidden.  

How to unhide columns in Excel 1

So let's look at getting them back, or unhiding them.  

You may have tried selecting a column next to the hidden column and then doing a right-click, and selecting Unhide from the shortcut menu, but had no success 

That's exactly what most people do, and sadly, it doesn’t work, which can be a little bit scary when you've hidden data and then you can't get it back again (yikes).  

How to unhide columns in Excel 

A lot of people may tell you just to go and select the entire worksheet before you unhide.  

Let me explain why this isn’t my preferred way of unhiding. 

You can select the entire worksheet simply by clicking on that little triangle in the top left corner of the worksheet

How to unhide columns in Excel 2

Then just do a right-click over any column letter and then select Unhide. 

How to unhide columns in Excel 3

But just a word of warning here. When you have several columns hidden, like in the example below where columns B and C and H to J have been hidden, every column will become unhidden if you unhide this way.  

So if you're working in a file you share with other people, and you have just unhidden all of their work as well, they may not be that happy with you. 

So that's probably not my recommended way of unhiding. It will work, but it will actually unhide everything.  

Unhiding only the columns you need 

This is what I would recommend you do.  

Select the columns on either side of the hidden columns.  

How to unhide columns in Excel 4

Now do a right-click Unhide.

How to unhide columns in Excel 5

And the hidden columns will now be visible AND all other hidden columns remain hidden.

How to unhide columns in Excel 0

So that's a great way to unhide columns when you have randomly hidden columns and you want to avoid unhiding ALL of the columns. 

Unhiding columns in newer versions of Excel 

If you're in a newer version of Excel, like I am, and you have a really steady hand, you can try clicking and dragging on the double lines up in the Column Header bar.  

How to unhide columns in Excel 6

Just click and drag and you will unhide each column.

How to unhide rows in Excel 

You can use the same steps to unhide rows in Excel.  

Just select on either side and then right-click. 

How to unhide columns in Excel 7

And then select Unhide from the shortcut menu. 

How to unhide columns in Excel 8

And they will once again be visible. 

How to unhide columns in Excel 9

BTW, you can also click and drag on the double-lines if you are working in a newer version of Excel.  

How to unhide column A and row 1 

Let's cover a challenge that a lot of people come across, and that's where column A and row 1 are hidden and you're trying to get them back. 

How to unhide columns in Excel 10

Pretty challenging if you can't select on either side in order to get them back ( ?sigh). 

You could definitely click the triangle to select the entire worksheet, and do the right-click, Unhide, but of course as soon as you do that it will unhide ALL hidden columns, so if that’s not what you are wanting, it’s not ideal.  

Instead, follow this little trick.  

What you can do is use the Go To dialog box. You can open this on the Home tab, Find & Select, Go to Special or by pressing the F5 key on your keyboard (F5 is at the top of your keyboard).

Once the Go To dialog box is displayed type a1 into the Reference box, and then click on OK, which will take you to cell A1.

How to unhide columns in Excel 11

Now from the Home tab, you go over to Format and you go down to Hide & Unhide.  

How to unhide columns in Excel 12

Now depending on what you're actually trying to unhide here, select the option you require. 

And your row or column will now be visible. 

How to unhide columns in Excel 13

BTW, if you are using a newer version of Excel and you have a very steady hand, you can try to click and drag them back to being visible again ?

How to locate and find hidden rows and columns

I get asked a lot, "how can I quickly find hidden columns within a worksheet"?

This is a good skill to have if you are working in shared files and you're not sure where others have hidden data. Best to be aware of it before you start making changes to the workbook.

To locate hidden rows or columns first select the entire worksheet. Clicking on the arrow in the top left to select is a great way to do this.

How to unhide columns in Excel 2

Now press F5 on you keyboard to open the Go To dialog box.

How to find hidden columns

Click SpecialVisible cells only.

How to find hidden columns

Click OK.  

Border lines will now indicate where data is hidden.

How to find hidden columns

Check out the video below to see the 'finding hidden columns' steps in action. I made this video a long time ago but it's still relevant and super useful today ?

Was this blog helpful? Let us know in the Comments below.

If you enjoyed this post check out the related posts below.

Join our free insiders Group!

Learn how to SAVE TIME and WORK SMARTER, without the 'techie' speak!

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Join our free insiders club! 

Receive 100+ Steps to Becoming Proficient in Excel