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.
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-
- 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.
- 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 but has appeared now.
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:
- 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-
- 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 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.
- 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.
Cells.EntireColumn.Hidden = False
- 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.
Read More: How to Hide and Unhide Columns in Excel
Download Practice Workbook
You can download the practice workbook from here:
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.
- How to Hide Extra Columns in Excel
- How to Unhide Columns in Excel
- Unhide Columns Is Not Working in Excel
- Unhide Columns in Excel Shortcut Not Working