How to hide columns in excel

October 21, 2021
1,129 Views 0

· Hide a single column

1. Right-click on the target column for operation.

2. Choose Hide from the pop-up list.

How to hide columns 1.gif


· Hide columns within a continuous range range

1. Right-click to select a continuous column range.

2. Choose Hide from the pop-up list.

How to hide columns 2.gif 

· Hide multiple column selections

1. Long-press Ctrl on the keyboard, while using the mouse to left-click the columns for operation.

2. Right-click on the last column(s) selected, and choose Hide from the list.

How to hide columns 3.gif

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. (Relevant tutorials: How to unhide rows in excel)

Was this helpful?