There are various ways to hide and unhide columns in Excel. It may happen that one of the methods may not work for you, in that case, it is good to know alternatives that can work.
How to Unhide Columns in Excel
In this tutorial, you’ll learn the following methods to unhide Columns in Excel:
- Using a keyboard shortcut.
- Using the Mouse.
- Using the Format options in the ribbon.
- Changing the column width.
#1 – Using a Keyboard Shortcut
To unhide columns in Excel using a keyboard shortcut:
- Select the column that have the hidden columns in between. For example, if you are trying to unhide column C, then select column B and D.
- Hold the Control key and press the 0 key from the numeric keypad. If you don’t have the numeric keypad in your keyboard, use Control + Shift + 0 Key from the regular keyboard.
Note: This shortcut may not work in all cases as it is dependent on the operating system settings. Here is more about this issue. In that case, you can use the following keyboard shortcut:
- This will instantly unhide the columns.
If you want to unhide all the columns in the worksheet, select the entire worksheet and use the shortcut.
#2 – Using the Mouse to Unhide Columns
One quick and easy way to unhide a column is to use the mouse.
To do this:
- Hover your mouse in between the columns alphabets that has the hidden column. For example, if Column C is hidden, then hover the mouse between Column B and D (at the top of the worksheet). You will see a double line icon with arrows pointing on left and right.
- Hold the left key of the mouse and drag it to the right. It will make the hidden column appear.
#3 Using the Format Option in the Ribbon
Under the home tab in the ribbon, there are options to hide and unhide columns in Excel.
Here is how to use it:
- Select the columns between which there are hidden columns.
- Go to Home –> Cells –> Format –> Visibility –> Unhide Columns. This will instantly unhide the columns.
Another way of accessing this option is by selecting the columns and right clicking using the mouse. In the menu that appears, select the unhide option.
#4 Changing the Column Width
There is a possibility that none of these methods work when you try to unhide column in Excel. It happens when you change the Column Width to 0. In that case, even if you unhide the column, it’s width still remains 0, and hence you can’t see it or select it.
To change the column width:
- In the name box, type any cell address in that column. For example, if it is column C, type C1.
- Although the column is not visible, the cursor would go in between B1 and D1 (indicating that C1 has been selected).
- Go to Home –> Format –> Column Width. It will open the Column Width dialogue box.
- Enter a column width value to make the column visible. In Excel 2013, if you enter any value less than .039, it hides the column completely. For any value higher than or equal to .039, the column is visible (although it would be a thin line for such a small value).
This is by far the most reliable way to unhide columns in Excel. If everything fails, just change the column width.
- How to Insert Multiple Rows in Excel – 4 Methods.
- How to Quickly Insert New Cells in Excel.
- Keyboard & Mouse Tricks that will Reinvent the Way You Excel.