How to hide or unhide Rows in Excel worksheet
How to hide Rows in Excel worksheet
Sometimes you may want to hide some sensitive or unwanted rows from your Excel worksheet. You can hide a Row or a Range of Rows from Excel worksheet. After you hid Rows from Excel worksheet, the hidden Rows are not printed.
Hiding Rows from Excel worksheet is very useful if you do not want to display some Rows of Excel worksheet containing sensitive/unwanted information to other users or if you do not want some Rows of sensitive/unwanted information appear in Excel worksheet's printouts.
To hide Rows from Excel worksheet, first select the Rows which you want to hide. After selecting the Rows, right-click on the selected Rows and click "Hide" from the context menu as shown below.
You can see from below images that the selected Rows in above example are hidden.
A double-line between Row number 4 and 9 in above image shows that Rows are hidden between Row number 4 and 9. The skipped Row numbers in Row header are hidden. That means, Rows 5 to 8 are hidden.
An animation about how to hide Rows in Excel worksheet is copied below.
Another method to achieve the same result described above is to select the Rows you want to hide first and then run command "Hide Rows" from Excel Ribbon > "Home" Tab > "Cells" Group > "Format" > "Hide & Unhide", as shown in below image.
How to unhide hidden Rows in Excel worksheet
To unhide hidden Rows, select upper and lower Rows of the hidden Rows.After selecting upper and lower Rows of the hidden Rows, right-click on selected Rows and select "Unhide" from the context menu.
In this example, Rows 5 to 8 are hidden. Upper are lower Rows of the hidden Rows are Row 4 and Row 9.
You can see from below image that all the hidden Rows between Row 4 to Row 9 are unhidden.
An animation about how to unhide hidden Rows in Excel worksheet is copied below.
Another method to achieve the same result described above is to select upper and lower Rows of the hidden Rows and then run command "Unhide Rows" from Excel Ribbon > "Home" Tab > "Cells" Group > "Format" > "Hide & Unhide", as shown in below image.
