Formulas

How to Hide and Unhide Columns in Excel?

Pinterest LinkedIn Tumblr

You cannot identify what data you need in a huge set of rows and columns? Want to know the trick to hide and unhide columns in Excel? Then this article will help your worksheet to look easier by using some basic steps to hide and unhide columns. Let’s get started.

Introduction to Hide and Unhide Columns in Excel

Sometimes it’s better to use hide and unhide columns to see the data you want without any complications. You can easily do this by using Format option or just by right-clicking and specifying the hide or unhide option. Once you examine with the example, you will get a clear idea about the hiding and unhiding process in spreadsheet. Now we will move on to the process of hiding and unhiding columns.

How to Hide the Columns?

There may be a situation where you don’t want your data to be deleted but you want to hide it for some time until you want the data to be known. You can hide your data in the following two ways.

Using Format option

  1. Select one or more column which you want to hide. you can either select the entire column or top of the column.
  2. Then go to Home >Format (under the group name “Cells”) > Hide & Unhide (under the menu name “Visibility”) and select Hide Columns.
  3. Once you select Hide Columns, the selected column will be hidden.

Here is an example which contains the following data: Product name, Price and Status. Now I want to hide the Status (Column D) of the product since I want to see only the name and price of the product. So select Hide Columns options from the Formats option in the Home tab.

hide and unhide columns

Once you select Hide Columns, the Status column will be hidden from the worksheet. you can see the double line between Column C and Column E which indicates that Column D is hidden from the worksheet.

hide and unhide columns

Note. The shortcut key to hide the column is Ctrl + 0 (zero). Select the column you want to hide and press the shortcut key.

Using Right-Click

  1. Select one or more column which you want to hide. you can either select the entire column or top of the column.
  2. Then right-click the column and select Hide from the drop-down box.
  3. Once you select Hide, the selected column will be hidden.

Here is an example which contains the following data: Name, Email, Marks, Result, Subject and Send Email. Now I want to hide the multiple columns namely Column F and G since I want to know only the Name, Email, Marks and Result. So right-click the column and select Hide option

hide and unhide columns

Once you select Hide, the Column F and G will be hidden from the worksheet. you can see the double line between Column E and Column H which tells that the in-between columns is hidden from the worksheet.

How to Hide and Unhide Columns in Excel? 1

How to Unhide the Columns?

Now you know how to hide the data according to your needs. what if you want to unhide the data again? You can unhide your data in the following two ways.

Using Format option

  1. Highlight the column on the hidden column which you want to unhide.
  2. Then go to Home >Format (under the group name “Cells”) > Hide & Unhide (under the menu name “Visibility”) and select Unhide Columns.
  3. Once you select Unhide Columns, the selected column will be shown.

As we already discussed this example for the hiding process, now i want the Status column again to be shown which we previously hide it. So select UnHide Columns options from the Formats option in the Home tab.

hide and unhide columns

Once you select UnHide Columns, the Status column will be shown again in the worksheet. The below image will help you to visualize better.

How to Hide and Unhide Columns in Excel? 2

Using Right-Click

  1. Highlight the column on either side of the hidden column which you want to unhide.
  2. Then right click the column and select UnHide from the drop down box.
  3. Once you select UnHide, the selected column will be shown.

As we already know this example, i want to unhide the Column F and G again. So right click the column and select UnHide option.

hide and unhide columns

Once you select UnHide, the Column F and G will be shown again in the worksheet. The below image will help you to visualize better.

hide and unhide columns

To know more on Excel go through our Formulas.

Do follow our YouTube channel for regular updates.

Related Posts

Write A Comment