How to hide rows in excel

October 21, 2021
731 Views 0

· Hide a single row

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

2. Choose Hide from the pop-up list.

How to hide rows 1.gif


· Hide rows within a continuous range range

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

2. Choose Hide from the pop-up list.

How to hide rows 2.gif


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

How to hide rows 3.gif 


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)

Was this helpful?