How to show all rows in Excel

November 17, 2022

319

[ad_1]

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.

To choose "Select all" 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 5 .

Select the row that is above the hidden row.

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.

Hold down the Shift key and select the row below the hidden row.