How to hide rows in excel
October 21, 2021
3.6K
Views
0
0
A free Office suite fully compatible with Microsoft Office
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)
Also Read:
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to add text to beginning or end of all cells in Excel
- 5. How to color cell based on value in Excel?
- 6. How to compare two excel sheets and highlight differences