How to Hide Columns in Excel (4 Simple Methods)

In some situations, you may want to hide one or more columns in an Excel worksheet. Obviously, Excel allows users to easily hide columns. You might want to display or print a worksheet in such a way that some of the data is hidden, but not deleted from the workbook. Similarly, you may wish to hide unused or unimportant columns to keep your users focused on the relevant information. Once a column is hidden, it will not be shown on the display or printed worksheet.

In this article, you will learn 4 simple methods to hide columns in Excel with vivid illustrations.


Download the Practice Workbook

We have prepared a workbook so that you can practice. You can download it from the link below.


4 Simple Methods to Hide Columns in Excel

To demonstrate the article, we will use the following dataset.

4  Simple Methods to Hide Columns in Excel (Sample Dataset)

There can be 3 combinations of columns we can hide in Excel. These are as follows:

1. Single Column

2. Multiple Adjacent Columns

3. Multiple Non-Adjacent Columns

We can hide any single or multiple columns in Excel. Multiple columns can be both adjacent or non-adjacent. Sometimes it seems necessary to hide some multiple non-adjacent columns. Hiding multiple columns that are not next to one another may become crucial to visualize the remaining data more effectively.

In the following sections, we will learn how to hide all such combinations of columns using some quick and effective techniques.


1. Quickest Method: Keyboard Shortcut to Hide Columns in Excel

We can easily hide a single or some multiple columns using keyboard shortcut Ctrl+0. This is the quickest method to hide columns in Excel.

1.1 Hide Single Column

Let’s say, we want to hide the sales amount of January.

Steps:

  • Select the entire column by clicking on top of Column C(January).

Keyboard Shortcut to Hide Single Column in Excel

  • Press and hold the Ctrl key on the keyboard.
  • Now, press the 0 (zero) key without releasing the Ctrl key. Column C disappeared from view.

Keyboard Shortcut to Hide Single Column in Excel

Read More: How to Hide Rows and Columns in Excel (10 Ways)


1.2 Hide Multiple Adjacent Columns

To hide multiple adjacent columns of sales data from January to March, follow the steps below.

Steps:

  • First, we have to Select the first column (C column that shows sales of January) by clicking on the column letter.

Keyboard Shortcut to Hide Multiple Columns in Excel

  • Press & hold the Shift > Select Column E (that shows sales data of March).

Keyboard Shortcut to Hide Multiple Columns in Excel

  • Press and hold the Ctrl key on the keyboard.
  • Now, press the 0 (zero) key without releasing the Ctrl key. The columns don’t appear in the view now.


1.3 Hide Multiple Non-adjacent Columns

For our dataset, let’s say, we want to see the sales data of all even months i.e. February, April, and June. To do this, we must hide the sales data of all the remaining months i.e. January, March, and May. Carefully go through the following steps.

Steps:

  • First, Select the January column(Column C) by clicking on the column letter.

Keyboard Shortcut to Hide Multiple Columns in Excel

  • Then, press & hold the Ctrl key > Select Column E and Column G by clicking on the column letters.

Keyboard Shortcut to Hide Multiple Columns in Excel

  • Press & hold the Ctrl key on the keyboard.
  • Now, press the 0(zero) key without releasing the Ctrl key. The columns disappeared from view.

Read More: How to Hide Selected Columns in Excel (5 Easy Methods)


2. Hide Single or Multiple Columns with Excel Hide Command

Hide command is a simple way to hide columns in Excel.

2.1 Hide Single Column

Let’s say, we want to hide the sales amount of January.

Steps:

  • Select Column C(January) by clicking on the column letter.

Hide Single Column with Excel Hide Command

  • Right-click the selected columns, and then select Hide from the Context Menu.

Hide Single Column with Excel Hide Command

You can see that Column C disappeared.

Read More: How to Hide Columns with Button in Excel (4 Suitable Methods)


2.2 Hide Multiple Adjacent Columns

To hide multiple adjacent columns of sales data from January to March, follow the steps below.

Steps:

  • First, we have to select the first column (Column C– January) by clicking on top of it.

Hide Multiple Columns with Excel Hide Command

  • Then press and hold the Shift > select Column E.

Hide Multiple Columns with Excel Hide Command

  • Right-click on the selected columns, and then select Hide from the Context Menu.

Hide Multiple Columns with Excel Hide Command

You can see the columns are hidden from view.

Read More: Excel Hide Columns Based on Cell Value without Macro


2.3 Hide Multiple Non-Adjacent Columns

For our dataset, let’s say, we want to see the sales data of all even months i.e. February, April, and June. To do this, we must hide the sales data of all the remaining months i.e. January, March, and May. Carefully go through the following steps.

Steps:

  • First, select Column C(January) by clicking on the top of it.

Hide Multiple Columns with Excel Hide Command

  • Then, press & hold the Ctrl key > Select Column E and Column G by clicking on the column letters.

Hide Multiple Columns with Excel Hide Command

  • Right-click on the selected columns, and then select Hide from the Context Menu.

Hide Multiple Columns with Excel Hide Command

You can see the columns are hidden now.


Similar Readings:


3. Hide Single or Multiple Columns with Group Command from the Data Tab

Group command is used to visually group columns or rows to monitor them in a concise & organized manner under one heading.

3.1 Hide Single Column

Let’s say, we want to hide the sales amount of January.

Steps:

  • Select the entire column by clicking on top of Column C(January).

Hide Single or Multiple Columns with Group Command from the Data Tab

  • On the Data tab > Outline group > Group > Group.

Hide Single or Multiple Columns with Group Command from the Data Tab

Column C is grouped.

Hide Single or Multiple Columns with Group Command from the Data Tab

  • To hide the column, click the minus sign. Column C disappeared.


3.2 Hide Multiple Adjacent Columns

To hide multiple adjacent columns of sales data from January to March, follow the steps below.

Steps:

  • First, we have to select the first column (Column C – January) by clicking on top of it.

Hide Single or Multiple Columns with Group Command from the Data Tab

  • Then press and hold the Shift > select Column E.

Hide Single or Multiple Columns with Group Command from the Data Tab

  • On the Data tab > Outline group > Group > Group.

Hide Single or Multiple Columns with Group Command from the Data Tab

The Columns became grouped.

  • To hide the column, click the minus sign. The Columns disappear from view.

Note:
The Group command can’t be used to hide multiple non-adjacent columns.

Read More: How to Hide Columns in Excel with Minus or Plus Sign (2 Quick Ways)


4. Hide Columns Using the Excel Name Box

Using the Name Box is another simple way of hiding columns in Excel.

4.1 Hide Single Column

Let’s say, we want to hide the sales amount of January.

Steps:

  • Type the Cell Reference C1(that contains January Data) or any other cell in Column C into the Name Box.

Hide Columns Using the Excel Name Box

The C1 Cell is selected.

Hide Columns Using the Excel Name Box

  • On the Home tab > Cells Group > Format > Hide & Unhide > Hide Columns.

Hide Columns Using the Excel Name Box

You can see that Column C disappeared.

Hide Columns Using the Excel Name Box

Read More: How to Hide and Unhide Columns in Excel (7 Quick Methods)


4.2 Hide Multiple Adjacent Columns

To hide multiple adjacent columns of sales data from January to March, follow the steps below.

Steps:

  • Type the Cell References C1, D1, and E1 (that contains data of corresponding month) or any other cells on the corresponding columns into the Name Box.

Hide Columns Using the Excel Name Box

We can see the C1, D1, and E1 Cells are selected.

  • On the Home tab > Cells Group > Format > Hide & Unhide > Hide Columns.

You can see the  Column C, Column D & Column E are hidden.


4.3 Hide Multiple Non-adjacent Columns

For our dataset, let’s say, we want to see the sales data of all even months i.e. February, April, and June. To do this, we must hide the sales data of all the remaining months i.e. January, March, and May. Carefully go through the following steps.

Steps:

  • Type the Cell References C1, E1, and G1(that contains data of the corresponding month) into the Name Box.

Hide Columns Using the Excel Name Box

You can see the C1, E1 and G1 Cells are selected.

Hide Columns Using the Excel Name Box

  • On the Home tab > Cells Group > Format > Hide & Unhide > Hide Columns.

You can see that Column C, Column E and Column G are hidden.

Hide Columns Using the Excel Name Box


How to Unhide Columns in Excel (2 Quick ways)

1. Unhide Columns by Double Clicking the Hidden Column Line

Let’s say, we have to unhide Column C.

How to Unhide Columns in Excel

Steps:

  • Double click on the Hidden Column line.

You can see Column C now.

Read More: How to Unhide Columns in Excel


2. Unhide Columns with Simple Unhide Command

Let’s say, we want to unhide the sales amount of January.Unhide Columns with Simple Unhide Command

Steps:

  • Select both columns on either side of Column C(January).

Unhide Columns with Simple Unhide Command

  • Right-click the selected columns, and then select Unhide from the Context Menu.

Unhide Columns with Simple Unhide Command

Now, you can see Column C.

Read More: Hide or Unhide Columns Based on Drop Down List Selection in Excel


Conclusion

In this article, we described 4 simple methods of How to Hide Columns in Excel. Please have a look at our website ExcelDemy.com. Let us know if you face any problems in the comment box. There is a practice workbook added. Go ahead and give it a try.


Further Readings

Robiul Hossain

Robiul Hossain

Hello, I am Robiul. I’ve completed my BSc in Naval Architecture & Marine Engineering from Bangladesh University of Engineering & Technology (BUET). I have a keen interest in Programming and Data science. I really love to solve problems that help lots of people in their day to day life. Currently, I am working with a highly skilled and motivated Technical Writing team of ExcelDemy. We are committed to bringing you the best possible results of your Microsoft Excel problems. Stay with us and enjoy the best Excel experience.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo