how to unhide columns in excel

Unhide columns in excel

Do you know that one can easily hide and unhide columns in excel worksheet even after saving?

Of course, this is possible. And as a user, making use of the Excel Worksheet for your works, you need to know this.

Many keep saying I can’t unhide columns in excel or how do I unhide columns in excel?

Nevertheless, IntoGeek got you covered here, Today, I will teach you how to unhide columns in excel shortcut and after saving.

Also, this can be done on any version of Excel both the Windows and Mac versions.

For a more straightforward approach, I have listed out the step-by-step guide on how to achieve this in your excel.

Let’s see them quickly;

 

Steps on How to Unhide Columns in Excel

Below here are the six simple steps on how to unhide columns in excel after saving the worksheet.

Step 1: Open your Excel document

On your computer system, locate the excel document that has hidden columns, and then double-clicks on it to open the document.

You can also, double-click the Excel icon on your Windows desktop, and then select the document’s name from the file menu homepage.

Step 2: Select the Columns on both sides of the Hidden Column

Here, you select the columns on both sides of the hidden columns by pressing down the Shift key and then click on the letter column on the right and the letter column on the left.

Once you do this, the columns will be highlighted immediately.

  • Example: If the hidden column is column D, you press down the Shift key and click on column C and then column E.
  • If you wish to unhide column D, then you select the left and right columns and type “D1” into the “Name Box” that is located at the left below the formula bar.

Step 3: Click the Home Tab

By default, your excel sheet is on the home tab toolbar, but if you are not, then locate the Home tab at the upper-left side and click on it.

The home tab would be displayed along with other toolbars below the green ribbon.

Step 4: Click Format

On the Home tab, locate the “Format” button in the “Cells” section at the right side end of the toolbar.

Click on the Format button, and a drop-down menu will display.

Step 5: Select Hide & Unhide

From the drop-down menu, check the heading with “Visibility” and select the “Hide & Unhide” option below it.

Once you select it, a pop-out menu will appear.

Step 6: Click Unhide Columns

From the pop-out menu, quickly scroll and click the “Unhide Columns” option.

Immediately, the hidden column that is between the two columns you selected will be unhidden, and it will display back.

 

So, that is all you need to know on how to Unhide Columns in Excel worksheet.

If you don’t know how to do this before, you have known it today.

I know you enjoyed this article, kindly help in sharing this post to your friends and on social media accounts.

Thank you!

Related Articles: