Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

If you are searching for the 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.


Download Practice Workbook

You can download the practice workbook from here:


4 Methods to Unhide Columns in Excel All at Once

Suppose, you have a dataset where a number of columns are hidden and you want t 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 Windows operating system. You will find detailed explanations of methods and formulas here. I have used 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


1. Select Entire Worksheet and Use Unhide Command

You can unhide all hidden columns at once by selecting all cells and selecting 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 become 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 that has appeared now.

Unhide Columns All at Once

Read More: Hide or Unhide Columns Based on Drop Down List Selection in Excel


2. Use 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 and Unhide Columns in Excel (7 Quick Methods)


Similar Readings


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: Unhide Columns in Excel Shortcut Not Working (6 Solutions)


4. Use a VBA Macro to Unhide Columns

Alternatively, you can use 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: Excel Hide Columns with No Data (4 Effective Ways)


Conclusion

In this article, you have found how to unhide columns in Excel all at once.I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Osman Goni Ridwan

Osman Goni Ridwan

I am Ridwan, graduated from Naval Architecture and Marine Engineering Dept, BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands. My prime goal is to be a data analyst as I do love to solve problems and play with data.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo