How to hide columns in excel

October 21, 2021
2.6K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

· Hide a single column

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

2. Choose Hide from the pop-up list.

· Hide columns within a continuous range range

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

2. Choose Hide from the pop-up list.

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


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)