How to Unhide Columns in Excel All at Once (4 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

If you are searching for a solution or some special tricks to unhide columns in Excel all at once then you have landed in the right place. There are 4 quick ways to unhide columns in Excel all at once. This article will show you each and every step with proper illustrations so, you can easily apply them for your purpose. Let’s get into the main part of the article.


How to Unhide Columns in Excel All at Once: 4 Methods

Suppose, you have a dataset where a number of columns are hidden and you want to unhide them at once. In this section, I will show you 3 quick and easy methods to unhide columns in Excel all at once on the Windows operating system. You will find detailed explanations of methods and formulas here. I have used the Microsoft 365 version here. But you can use any other versions as of your availability. If any methods won’t work in your version then leave us a comment.

How to Unhide Columns in Excel All at Once

Read More: Hide Columns with No Data in Excel


1. Select Entire Worksheet and Use Unhide Command

You can unhide all hidden columns at once by selecting all cells and selecting the Unhide option. Follow these steps to do this-

📌 Steps:

  • First, click on the green arrow in the left-top corner of the worksheet. Then you will see all cells of the worksheet have been selected.

How to Unhide Columns in Excel All at Once

  • Then, right-click on the mouse while the mouse cursor is on the column header.
  • As a result, a list of options will appear.
  • And, select the Unhide option from it.

How to Unhide Columns in Excel All at Once

  • As a result, all hidden columns will appear. In the dataset, Column D & F were hidden but has appeared now.

Unhide Columns All at Once

Read More: How to Hide Columns with Button in Excel


2. Use the Keyboard Shortcut to Unhide Columns

There is a keyboard shortcut in Excel by which you can unhide all hidden columns very easily. I am sharing the full procedure step-by-step below:

📌 Steps:

  • First, click on any cell of the worksheet to select it.
  • Then, use an Excel keyboard shortcut Ctrl + A to select all the cells of the active worksheet.
  • Now, hold the ALT key and press the H O U L keys serially.
  • As a result, you will see all hidden columns have appeared.

Read More: How to Hide Multiple Columns in Excel


3. Apply a Different Width to All Columns

Hiding a column means making the column of zero width. So, you can change the width of the columns to unhide it. To do this, follow the steps below-

📌 Steps:

  • First, press Ctrl + A to select all the cells of the active worksheet.
  • Then, go to the Home tab >> Format option >> Column Width.

Imposing Column Width

  • Then, a window named Column Width will appear.
  • Insert a suitable value in the box and press OK.

Imposing Column Width

  • As a result, all hidden columns have shown up with the given width.

Imposing Column Width

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


4. Use a VBA Macro to Unhide Columns

Alternatively, you can use the VBA macro code to unhide all the hidden columns at once. I am sharing the VBA code here and also the procedure of how you will apply it.

📌 Steps:

  • For this, first, go to the top ribbon and press on the Developer then press on the Visual Basic option from the menu.

You can use ALT + F11 to open the ‘Microsoft Visual Basic for Applications’ window if you don’t have the Developer tab added.

How to Unhide Columns in Excel All at Once

  • Now, a window named “Microsoft Visual Basic for Applications” will appear. Here from the top menu bar, press on the “Insert” And a menu will appear. From them select the “Module’” option.

Using VBA Macro

  • Now, a new “Module” window will appear. And Paste this VBA code into the box.
Sub UnhideAllColumnsatOnce()
Cells.EntireColumn.Hidden = False
End Sub

Using VBA Macro

  • To run the code go to the top menu, press on the Run option, and here will open some other options and select the Run Sub/UserForm also you can simply press F5 to run the code.

Using VBA Macro

  • As a result, you will see the hidden columns have appeared in the worksheet.

hide Columns All at Once

Read More: How to Hide and Unhide Columns in Excel


Download Practice Workbook

You can download the practice workbook from here:


Conclusion

In this article, you have found how to unhide columns in Excel all at once. I hope you found this article helpful. Please, drop comments, suggestions, or queries if you have any in the comment section 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.
Osman Goni Ridwan
Osman Goni Ridwan

OSMAN GONI RIDWAN is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, OSMAN has transitioned into the role of a content developer. Specializing in creating technical content exclusively centered around Excel... Read Full Bio

2 Comments
  1. I have read this whole article. I don’t see where it helps my situation.

    I have columns A & B hidden.

    How do I unhide them since I can’t select any column before column C.

    I have selected the whole spreadsheet and then held down the ALt button then the H O U L keys sequentially.

    I get no results.

    Thanks for your help with this problem!

    Take care,
    Tony

    • Dear Anthony Maviglia,
      Thank you for your comment. Sometimes keyboard shortcuts may not work in Excel for several reasons. You can check an alternative solution below.

      • If you want to select column A and B and then unhide them, first press Ctrl + G >> type A:B in the Reference box >> click on OK. This will select your hidden columns.

      • Then, go to the Home tab >> click on Format >> click on Hide & Unhide >> select Unhide Columns option.

      I hope this will help you to solve your problem. Please let us know if you have other queries.
      Regards,
      Arin Islam
      ExcelDemy.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo