– How to Hide a Column
– How to Hide Multiple Columns that are not Adjacent
Please refer to Ctrl+0 if you like using shortcut to hide columns or follow steps below to hide multiple adjacent columns:
Step 1: Click column headers to select all the columns;
Step 2: Right-click and select "Hide" from the dialog box.
Alternatively, see steps below using commands in Ribbon:
Step 1: Select the columns to hide by clicking their headers; if there are too many columns, please select the first column, hold "Shift" key, then click the last column;
Step 2: Click the "Home" tab from the ribbon;
Step 3: Click "Format" in Cells section, and select "Hide Columns" from the "Hide & Unhide" command;
Step 4: The columns will disappear.