How to Hide Rows in Excel
Use the row selector to highlight the rows you wish to hide., Right-click within the highlighted area., Unhide the rows.
3 Steps
1 min read
Easy
Step-by-Step Guide
-
Step 1: Use the row selector to highlight the rows you wish to hide.
You can hold the Ctrl key to select multiple rows. -
Step 2: Right-click within the highlighted area.
Select “Hide”.
The rows will be hidden from the spreadsheet. , To unhide the rows, use the row selector to highlight the rows above and below the hidden rows.
For example, select Row 4 and Row 8 if Rows 5-7 are hidden.
Right-click within the highlighted area.
Select “Unhide”. -
Step 3: Unhide the rows.
Detailed Guide
You can hold the Ctrl key to select multiple rows.
Select “Hide”.
The rows will be hidden from the spreadsheet. , To unhide the rows, use the row selector to highlight the rows above and below the hidden rows.
For example, select Row 4 and Row 8 if Rows 5-7 are hidden.
Right-click within the highlighted area.
Select “Unhide”.
About the Author
S
Steven Adams
Specializes in breaking down complex home improvement topics into simple steps.
48 articles
View all articles
Rate This Guide
--
Loading...
5
0
4
0
3
0
2
0
1
0
How helpful was this guide? Click to rate: