How to Hide and Unhide Columns in Excel


Learn how to easily hide and unhide columns, including the tricky column A, in Excel with this step-by-step guide.

Hiding a column tucks data out of sight without interfering with its purpose. You might want to hide confidential data or a helper column. Or, you might want to remove unnecessary columns from a busy sheet. Fortunately, hiding and unhiding columns is easy, with the exception of unhiding column A. In this article, you’ll learn how to hide and unhide columns, as well as the not-so-intuitive steps for unhiding column A.

PREMIUM: Build your skills with this Excel power user guide.

I’m using Microsoft 365 on a Windows 11 64-bit system. However, everything you learn applies to older versions and Excel for the web. Although the article hides and unhides column A, you can apply what you learn to hiding and unhiding row 1.

Jump to:

Selecting a column

Hiding and unhiding a column requires only a few clicks: select the column, right-click and choose the option. However, you must select the entire column(s) beforehand. To do so:

  1. Hover the cursor over the column’s header cell until it turns into a black pointer (Figure A).
Figure A: Hover the cursor over the header cell.
  1. Click the header cell (column C) to select the whole column (Figure B).
Select a column to hide it.
Figure B: Select a column to hide it.

If you want to select multiple columns, select the first column and then drag the selection left or right to add adjacent columns to the selection. To create a noncontiguous selection of columns, select the first column, hold down the Ctrl key and click the header cells for the columns you want to add to the selection.

Now that you know how to select whole columns, let’s move on to hiding a column.

SEE: Explore these Excel tips and tricks for beginners and pros.

Hiding columns in Excel

With column C selected, you’re ready to hide it as follows:

  1. Right-click the selected column.
  2. Choose Hide from the resulting context menu (Figure C).
Choose Hide from the right-click dropdown in Excel.
Figure C: Choose Hide from the right-click dropdown in Excel.

As you can see in Figure D, column C is no longer visible.

Excel hides column C.
Figure D: Excel hides column C.

Instead of right-clicking, you can also click Formatting in the Cells group on the Home tab, choose Hide & Unhide and then select Hide Columns from the resulting menu.

See: Here’s how to hide rows and columns and use groups in a shared Microsoft Excel workbook.

Unhiding columns in Excel

Unhiding a column isn’t intuitive, but it isn’t difficult. To do so, you select the columns adjacent to the hidden column and then repeat the process to hide the column, choosing the unhide option instead. You’re really selecting three (or more) columns: the hidden column(s) and each column on either side of the hidden column(s).

Let’s unhide column C as follows:

  1. Select columns B and D by clicking the header cell for column B and then drag the selection to column D (Figure E).
Select the columns adjacent to the hidden column, columns B and D.
Figure E: Select the columns adjacent to the hidden column, columns B and D.
  1. Right-click the selection.
  2. Choose Unhide from the context menu.

SEE: Here are some of the best keyboard shortcuts for rows and columns in Microsoft Excel.

Unhiding column A in Excel

So far, the methods for hiding and unhiding columns work fine until you need to unhide column A — there’s only one adjacent column, column B. Selecting just column B won’t also select the hidden column A. But that doesn’t mean column A is gone forever; however, the selection technique will be different.

First, let’s hide column A, so we can then unhide it:

  1. Click column A’s header cell.
  2. Right-click the selected column.
  3. Choose Hide from the contextual menu.

Now it’s time to unhide column A as follows:

  1. Hover the mouse over column B’s header cell, and drag left. The pointer changes from the selection arrow to a cross (Figure F). This will happen as the mouse pointer nears the Select All cell.
The pointer will turn into a cross once the selection includes column A.
Figure F: The pointer will turn into a cross once the selection includes column A.
  1. Right-click, and choose Unhide.


Source link

Leave a Comment