How To Unhide Rows In Excel?

Select the rows above and below the hidden rows

Right-click the selected row headers

Click Unhide

Or select the entire worksheet by clicking the Select All button

Go to the Home tab

Click Format in the Cells group

Choose Hide & Unhide

Click Unhide Rows

Use the keyboard shortcut Ctrl+Shift+9

If the rows are filtered, clear or adjust the filter first

Suggested for You

Trending Today