How to Hide a Column in Excel

- How to Hide Multiple Adjacent Columns
- How to Hide Multiple Columns that are not Adjacent

The advantage of hiding a column instead of deleting a column is that you can always bring it back when you need it. Please refer to Ctrl+0 if you like using shortcut to hide columns or follow steps below:

Step 1: Select the column;

Step 2: Right-click and select "Hide" from the dialog box.

Alternatively, use the commands from the Ribbon:

Step 1: Click any cell in the column that you want to hide, or select the whole column;

Step 2: Click the "Home" Tab from the ribbon;

Step 3: Click "Format" in the Cells area, and select "Hide Columns" from "Hide & Unhide" command;

Step 4: The column will disappear.

Leave a Reply