Alternately, select the Format > Hide & Unhide > Unhide Rows option from Excel’s “Home” tab in the ribbon. This also applies to

All of the rows that were previously hidden by Excel will now be visible.
You are ready to go.
How to Unhide Specific Rows in Excel
Use the following technique to make only certain rows visible while keeping all other hidden items hidden.

Click the header of the row above the one you want to make visible by hiding it. For instance, click the header for row 5 to make row 6 visible

Now, press and hold down the Shift key on your keyboard and click the header of the row that’s beneath your hidden row. In the above example, you’ll click the header for row 7 (while the Shift key is held down).

Note that you select all the rows between your clicked items when you click a row header while holding down Shift. This also selects the hidden content that you will later choose to reveal.

Select “Unhide” from the pop-up menu by right-clicking the selected row’s header.
There you have it. Your chosen content was previously hidden by Excel, but it is now accessible for your use.

Leave a Reply

Your email address will not be published.