How to hide rows in excel

October 21, 2021
3.6K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

· Hide a single row

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

2. Choose Hide from the pop-up list.

· Hide rows within a continuous range range

1. Right-click to select a continuous rowrange.

2. Choose Hide from the pop-up list.

· Hide multiple row selections

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

2. Right-click on the last row(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 hide columns in excel)