How to Unhide Rows in Excel – 8 Quick Methods

The sample dataset showcases item names and sales from January to March.

8 Quick Ways to Unhide Rows in Excel


Method 1 – Show Hidden Rows Using the Context Menu in Excel

 

Show Hidden Rows Using Context Menu in Excel

Steps:

Select the rows: one above and one row below the row or rows you want to see. Right-click and choose unhide..

Show Hidden Rows Using Context Menu in Excel

This is the output.


Method 2 – Unhide Rows by Double Clicking

Steps:

  • Place the cursor over the hidden row and double-click until a split two-headed arrow is displayed.

Unhide Rows by Double Clicking

The row is visible.

Unhide Rows by Double Clicking


Method 3 – Unhide Rows using the  Format Feature

Steps:

  • Select the rows you want to unhide.
  • Go to the Home tab > Cells > Format > Hide & Unhide.
  • Click Unhide Rows.

Excel Unhide Rows with Format Feature

Hidden rows are visible.

Excel Unhide Rows with Format Feature

Read More: [Fixed!] Excel Rows Not Showing but Not Hidden


Method 4 – Unhide a Specific Row Using the Name Box in Excel

Unhide Specific Row Using Name Box in Excel

Steps:

  • Enter B6 in the name box.
  • Press Enter.
  • The green line indicates B6 is selected.

  • Go to the Home tab > Format > Hide and Unhide > Unhide Rows.

Unhide Specific Row Using Name Box in Excel

The whole row containing B6 is visible.

Unhide Specific Row Using Name Box in Excel


Method 5 – Disclose Rows using a Keyboard Shortcut

Steps:

  • Select the hidden rows including one row above and one below.
  • Press Ctrl, Shift, 9.

Hidden rows will be displayed.

Disclose Rows with Keyboard Shortcut

Read More: Shortcut to Unhide Rows in Excel


Method 6 – Making Rows Visible by Changing the Row Height

Steps:

  • Click the top left corner and select the whole spreadsheet.

Visible Rows by Changing the Excel Row Height

  • Go to the Home tab and choose Format .
  • Select Row Height.

Visible Rows by Changing the Excel Row Height

  • In the new window, enter a row height. Here, 18.

Visible Rows by Changing the Excel Row Height

Hidden rows will be displayed.

Visible Rows by Changing the Excel Row Height


Method 7 – Show All Hidden Rows in the Whole Excel Spreadsheet

Steps:

  • Click the top left corner of your sheet.

Show All Hidden Rows in Whole Excel Spreadsheet

  • Right-click and select Unhide.

Read More: Unhide All Rows Not Working in Excel


Method 8 – Unhide Rows Using a VBA Code in Excel

Steps:

  • Select the rows you want to unhide.
  • Go to the Developer tab and choose Visual Basic to open the visual basic editor.

Unhide Rows Using VBA Code in Excel

  • Click Insert and select ‘Module’. A new module window will open.

Unhide Rows Using VBA Code in Excel

  • You can also right-click the spreadsheet bar and go to View Code.

  • Enter the VBA code.

VBA Code:

Sub UnhideAllRows()
Selection.EntireRow.Hidden = False
End Sub
  • Click Run or press F5 to run the macro.

Unhide Rows Using VBA Code in Excel

Hidden rows will be displayed.


Check the Number of Hidden Rows

Steps:

  • Select the File tab.
  • Go to Info.
  • Click ‘Check for Issues‘.
  • Click Inspect Document.

Check the Number of Hidden Rows

  • To make sure the Hidden Rows and Columns option is enabled in the Document Inspector, click Inspect.

You will see the total number of hidden rows and columns.

Check the Number of Hidden Rows


Reasons Why Rows in Excel Cannot Be Unhidden

  • The Worksheet is protected

Go the Review tab > select Changes > click Unprotect Sheet.

Click Protect Sheet in the Review tab, choose Format rows and click OK to keep the worksheet protected.

  • Small Row height, but Not Zero

Check the height of the rows.

  • Filtered out Rows

When row numbers become blue, it means that some rows have been filtered. Remove all filters.


Tips:

To unhide all rows and columns, select the entire spreadsheet and press Ctrl + Shift + 9 to see hidden rows. Press Ctrl + Shift + 0 to see hidden columns.


Download Practice Workbook

Download the workbook here.


Related Articles


<< Go Back to Hide Rows | Rows in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sabrina Ayon
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

2 Comments
  1. Thanks for sharing these methods to unhide rows in Excel! I was particularly impressed with the ‘AutoFit’ method, it wasn’t something I knew existed. Saves me so much time when working with large datasets.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo