How to Unhide Rows on Excel?

Select the rows above and below the hidden rows

Right-click the selected row headers

Click Unhide

Select the rows around the hidden rows

Go to the Home tab

Click Format

Hover over Hide & Unhide

Click Unhide Rows

Select the entire worksheet by clicking the Select All button

Go to the Home tab

Click Format

Hover over Hide & Unhide

Click Unhide Rows

Use the keyboard shortcut Ctrl + Shift + 9

If the rows are hidden by a filter, clear or adjust the filter first

Suggested for You

Trending Today