Search

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.

How to hide Excel worksheet rows

You can see from below images that the selected Rows in above example are hidden.

Excel worksheet rows 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.

How to hide Rows in Excel Worksheet

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.

Hide Rows from Excel Ribbon

 

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.

How to unhide hidden rows from Excel worksheet

You can see from below image that all the hidden Rows between Row 4 to Row 9 are unhidden.

Unhidden Rows Excel worksheet

 

An animation about how to unhide hidden Rows in Excel worksheet is copied below.

How to unhide hidden Rows in Excel Worksheet

 

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.

Unhide Rows from Excel Ribbon

 

Related Tutorials
• Important Excel Worksheet Navigation keys
• Excel Cursor and Mouse Pointer Shapes
• Row, Column and Cell in Excel worksheet
• How to change the Row height in Excel worksheet
• Excel AutoFit Row Height
• How to change the Column width in Excel worksheet
• Excel AutoFit Column Width
• How to hide or unhide Columns in Excel worksheet
• Maximum rows and columns in Excel Worksheet
• What is Active Cell in Excel and How to identify Active Cell
• What is Range in Excel Worksheet and How to form a Range Address
• Examples of Range Addresses in Excel worksheet
• Types of Ranges in Excel Worksheet
• How to select Range in Excel worksheet
• How to select Multiple Range in Excel worksheet
• What is Group mode in Excel, How to exit Group edit mode
• How to select all worksheets to Excel group
• How to select Ranges from different worksheets using Excel Group edit mode
• How to hide or show Excel Worksheet Row and Column headings (Column Letter and Row Number)
• How to hide or show Excel Worksheet Gridlines
• How to change the color of Excel worksheet Tabs
• How to change the color of Excel Gridlines
• How to change the default font and size in Excel
• How to Move or Copy entire worksheet within an Excel workbook
• How to Move or Copy entire worksheet to another Excel workbook