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.

Table of Contents hide

Download Practice Workbook

4 Methods to Unhide Columns in Excel All at Once

1. Select Entire Worksheet and Use Unhide Command

2. Use Keyboard Shortcut to Unhide Columns

3. Apply a Different Width to All Columns

4. Use a VBA Macro to Unhide Columns

Conclusion

Download Practice Workbook

You can download the practice workbook from here:

Unhide All Columns at Once.xlsm

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.

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.

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.

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

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.

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.

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

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

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.

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.

Now, a new “Module” window will appear. And Paste this VBA code into the box.

Sub UnhideAllColumnsatOnce()
Cells.EntireColumn.Hidden = False
End Sub

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.

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

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.