How to Hide Adjacent Columns in Excel

– 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;

This image has an empty alt attribute; its file name is excelcolumnwidth04.jpg

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.

Leave a Reply