Hide or Unhide Columns in Microsoft Excel

 

Hide Columns in Microsoft Excel

Hiding columns in Excel is super easy. And, you can select the columns you want to hide in a few different ways.

• To select a single column, click the column header.
• To select multiple adjacent columns, drag through them. Or you can click the first column header, hold Shift, and click the last column header in the range.
• To select multiple non-adjacent columns, click the first column header, hold Ctrl, and click the remaining column headers.

Once you choose the columns you want to hide, they’ll be highlighted. Right-click one of them and pick “Hide” in the shortcut menu.

After you hide columns in Excel, you’ll see a thick white line indicator between the remaining column headers. If you’re using a Mac, this indicator may appear as a bold green line. This is a good thing to keep in mind if you’re looking for data you don’t see.

Unhide Columns in Microsoft Excel

When you’re ready to view those hidden columns, unhiding them is just as simple as hiding them. Select the columns on each side of the hidden column(s). You can do this easily by dragging through them. Then, right-click and pick “Unhide” in the shortcut menu.

Another way to unhide columns is by double-clicking the line indicator for the hidden columns.