Unhide Columns Is Not Working in Excel (4 Issues & Solutions)

Get FREE Advanced Excel Exercises with Solutions!

In many cases, you might find that the unhide columns option is not working in Excel. Sometimes, the solutions to this problem are very easy but hard to find. This article discusses the four issues regarding unhide columns in Excel not working along with their solutions.


Unhide Columns Not Working in Excel: 4 Issues and Their Solutions

There may be some instances where the unhide column options in your Excel don’t work. Sometimes, it consumes a lot of our time and becomes annoying. But, actually, there are some straightforward solutions for all the issues.
For example, let’s consider a dataset of Weekly Sales as shown in the screenshot below. Now, you will hide Column C. Then we will see 4 issues regarding unhide columns not working in Excel along with their solutions.

4 Issues Regarding Unhide Columns Not Working in Excel and Their Solutions

Here, we have used the Microsoft Excel 365 version for this article. So, the issues we solve will be for this version.

Read More: How to Hide Columns with Button in Excel


1. Column Width Is Very Small or Zero in Excel

Sometimes, you may see a column hidden as shown in the below screenshot. But in reality, the column width is set to zero or very small.

Column Width Is Very Small or Zero

Now, when you use the unhide column option, it doesn’t work in Excel. This is because you have never hidden the column before. Instead, you set the column width to a very small number or zero. In this case, the width of Column C is set to zero.

Column Width Is Very Small or Zero

At this point, follow the below steps to solve the issue.

  • First, go to the line between columns B and D.
  • Then, a marker as shown in the below screenshot will appear.
  • Now, drag the marker to the right to increase the column width.

Column Width Is Very Small or Zero

  • Finally, you will have your output as shown in the below screenshot.

Column Width Is Very Small or Zero

Read More: Hide Columns with No Data in Excel


2. Protected Worksheet Preventing to Unhide Columns in Excel

Another reason why you can’t unhide columns in Excel may be that the worksheet you are working on is protected. This may happen if someone protects the worksheet before sharing it with you.

Protected Worksheet Preventing to Unhide Columns in Excel

Now, you can see the unhide column option is not even appearing let alone working in the below screenshot.

Protected Worksheet Preventing to Unhide Columns in Excel

At this point, to solve this issue follow the below steps.

  • At the very beginning, go to the Review tab.
  • Next, click on the Unprotect Sheet.

Protected Worksheet Preventing to Unhide Columns in Excel

  • Finally, try unhiding the column now and you will have an output as shown in the below screenshot.

Protected Worksheet Preventing to Unhide Columns in Excel

Read More: How to Hide Multiple Columns in Excel


3. Enabled Freeze Panes Option Causing Problem to Unhide Columns in Excel

In the previous versions of Microsoft Excel, sometimes when you have your Freeze Panes enabled, it may prevent you from unhiding the columns in Excel. This problem does not appear in the Microsoft 365 version.

Now, to solve this issue, follow the below steps.

  • First, go to the View tab.
  • Then, click on Freeze Panes from the Window options.
  • After that, select Unfreeze Panes.

Enabled Freeze Panes Option Causing Problem to Unhide Columns

  • Eventually, this will fix your issue.

Read More: How to Hide Columns Without Right Click in Excel


4. Can’t Unhide First Few Columns

Also, in the older versions of Microsoft Excel, you may face problems while trying to unhide the first few columns. These problems do not appear in the Microsoft 365 version. In those older versions, you need to select the column before unhiding the column you want.
Now, to solve this issue, follow the below steps.

  • First, go to the Home tab.
  • Then, select Find & Select.
  • After that, click Go to.

Can’t Unhide First Few Columns

  • Then, insert A:A as a reference.
  • Consequently, click on OK.

Can’t Unhide First Few Columns

Read More: How to Hide and Unhide Columns in Excel


Download Practice Workbook

You can download the practice workbook from the link below.


Conclusion

In this article, we discuss 4 possible reasons for the issue of unhiding columns not working in Excel along with their solutions. Last but not least, I hope you found what you were looking for in this article. If you have any queries, please drop a comment below.


Related Articles


<< Go Back to Hide Columns | Columns in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sowmik Chowdhury
Sowmik Chowdhury

Sowmik Chowdhuri, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a crucial Excel & VBA Content Developer at ExcelDemy. His profound passion for research and innovation seamlessly aligns with his unwavering dedication to Excel. In this role, Sowmik not only skillfully addresses challenging issues but also demonstrates enthusiasm and expertise in gracefully navigating intricate situations, highlighting his steadfast commitment to consistently deliver content of exceptional quality and value. Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo