If you’re like most people, you probably use Excel to track data and analyze it. But if you want to hide all the rows in your spreadsheet, there’s a few steps you can take.
- Open Excel and click on the Tools button.
- Click on the Options button.
- Scroll down and click on the Row hiding tab.
- Click on the Hide all rows button.
- Excel will hide all the rows in your spreadsheet, but you’ll still have access to them if you need to work with them later on.
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.
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
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 .
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).
Right-click the header of a selected row and from the open menu, choose “Unhide.”
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
