First, select your entire worksheet using Ctrl+A (Windows) or Command+A (Mac). Press Ctrl+Shift+9, right-click a cell and choose “Show” or choose Format > Hide and Show > Show Rows on the ribbon at the top to show all rows.
Showing 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 show all rows in Excel with a shortcut
To show hidden rows in your spreadsheet, start your spreadsheet with Microsoft Excel. Then go to 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 upper left corner of the worksheet.
While your worksheet is selected, show all rows using this shortcut: Ctrl+Shift+9. Or, right-click on a selected cell and choose “Show” from the menu.
How to show all rows and columns in Excel
Alternatively, in Excel’s “Home” tab on the ribbon, click the Format > Hide and Show > Show Rows option. This also works for
Hide and Show > Show Rows or Show Columns.” width=”562″ height=”500″ onload=”pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);” onerror=”this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this );”>
Excel will make all your hidden rows visible again in your spreadsheet. Are you ready.
RELATED: How to hide or show columns in Microsoft Excel
How to show specific rows in Excel
To reveal only specific rows while keeping all other hidden items invisible, use the following method.
To show a specific row, click the row header above its hidden row. For example, to display a row
6 click the row header
Now, press and hold the Shift key on your keyboard and click on the row header that is below your hidden row. In the example above, you’ll click the row header
7 (while holding down the Shift key).
Note: You hold down the Shift key and click a row header because doing so selects all rows among the items you clicked on. This also selects your hidden content, which you will show in the next step.
Right-click on the header of a selected row and from the open menu choose “Show”.
And that is. Excel has displayed your selected content and you can now work with it the way you want.
Do you want to show all your Excel columns too? Consult our guides.
RELATED: 12 basic Excel functions that everyone should know