Microsoft Excel logo.

First, select your entire worksheet using Ctrl+A (Windows) or Command+A (Mac). Press Ctrl+Shift+9, right-click a cell, and choose "Unhide," or select Format > Hide & Unhide > Unhide Rows from the ribbon at the top to unhide all rows.

Unhiding all the rows in a Microsoft Excel spreadsheet is as easy as pressing a keyboard shortcut or using a button on the ribbon. We’ll show you how.

How to Unhide All Rows in Excel With a Shortcut

To show hidden rows in your spreadsheet, launch your spreadsheet with Microsoft Excel. Then, access the worksheet in which you have the hidden content.

Select your entire worksheet by pressing Ctrl+A (Windows) or Command+A (Mac). Alternatively, click the “Select All” button in the worksheet’s top-left corner.

Choose "Select All" in the worksheet's top-left corner.

While your worksheet is selected, unhide all rows by using this shortcut: Ctrl+Shift+9. Or, right-click a selected cell and choose “Unhide” in the menu.

How to Unhide All Rows and Columns in Excel

Alternatively, in Excel’s “Home” tab in the ribbon, click the Format > Hide & Unhide > Unhide Rows option. This also works for

Select Format > Hide & Unhide > Unhide Rows or Unhide Columns.

Excel will make all your hidden rows visible again in your spreadsheet. You’re all set.

RELATED: How to Hide or Unhide Columns in Microsoft Excel

How to Unhide Specific Rows in Excel

To reveal only specific rows while keeping all other hidden items invisible, use the following method.

To unhide a specific row, click the header of the row that’s above your hidden row. For instance, to unhide row 6 , click the header for row 5 .

Select the row that's above the hidden row.

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: You hold down Shift and click a row header because doing so selects all the rows between your clicked items. This selects your hidden content as well, which you’ll unhide in the following step.

Hold down Shift and select the row that's beneath the hidden row.

Right-click the header of a selected row and from the open menu, choose “Unhide.”

Select "Unhide" in the menu.

And that’s it. Excel has unhidden your selected content, and you can now work with it the way you want.

Want to unhide all of your Excel columns too? Check out our guide.

RELATED: 12 Basic Excel Functions Everybody Should Know

Profile Photo for Mahesh Makvana Mahesh Makvana
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. He’s written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips.
Read Full Bio »