- 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.