[Fixed!] Excel Rows Not Showing but Not Hidden (3 Reasons & Solutions)

Sometimes, while working in Microsoft Excel, we see some rows not showing although they are not hidden. In such cases, the usual Hide & Unhide option of excel does not work as rows are not hidden. So, we have to find out why we cannot see those rows. There might be several reasons for this invisibility of rows. For example, insufficient row size or application of Filter. In this article, I will discuss the probable reasons behind these invisible rows and how you can solve those reasons.


Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.


3 Reasons with Solutions of Excel Rows Not Showing but Not Hidden

Reason 1: Unhidden Rows Are Not Visible Due to Insufficient Row Height in Excel

Let’s assume we have a dataset containing several fruits and their order quantities. In this dataset, we cannot see rows 7 and 8. If you notice carefully, you will notice a thick line is present between rows 6 and 9. This thick line means rows between rows 6 to 9 have insufficient height. So if you try to display rows 7 and 8 using the traditional Unhide option, it won’t work.

Unhidden Rows Are Not Visible Due to Insufficient Row Height in Excel

Solution:

Let’s solve the problem and display rows 7 and 8 following the below steps.

Steps:

  • First, put the cursor between rows 6 and 9 and right-click on it.
  • Then click on the Row Height option.

Unhidden Rows Are Not Visible Due to Insufficient Row Height in Excel

  • As a result, the row height dialog appears where you can see that row height is zero (0).

Unhidden Rows Are Not Visible Due to Insufficient Row Height in Excel

  • Now, to make the rows visible, enter the desired height (say 20) in the Row Height field and press OK.

Unhidden Rows Are Not Visible Due to Insufficient Row Height in Excel

  • Upon clicking OK, you will see that row 8 is visible now. Follow the same procedure to display row 7.

Unhidden Rows Are Not Visible Due to Insufficient Row Height in Excel

Note:

  • You can show the shrunk row by double-clicking on the row header of the regarding row.

Unhidden Rows Are Not Visible Due to Insufficient Row Height in Excel

  • You will always not see the thicker line where rows have zero height. In that case, it is better to select corresponding rows and check their height.

  • If you want to display rows 7 and 8 at once, select rows 6 to 9 at first. Then change their height accordingly.

Read More: How to Unhide Multiple Rows in Excel (9 Methods)


Reason 2: Rows Are Not Hidden but Not Displaying When Excel Filter Is Applied

Sometimes when we Filter data in excel, some rows get invisible. In such a situation, one might think corresponding rows got hidden. Actually, rows that contain unfiltered data got invisible. You can show invisible rows by withdrawing the applied Filter. For instance, in the below dataset rows 5,6,8, and 10 are not showing as we filtered the dataset for Apple.

Rows Are Not Hidden but Not Displaying When Excel Filter Is Applied

Solution:

Follow the below steps to make the above-mentioned rows visible again.

Steps:

  • First, go to the corresponding worksheet that contains the data and click any of the cells.

Rows Are Not Hidden but Not Displaying When Excel Filter Is Applied

  • Next, from Excel Ribbon, go to Data > Filter. Then click on the Filter option to disable the filtering.

Rows Are Not Hidden but Not Displaying When Excel Filter Is Applied

  • Consequently, you will get the below result. All the rows in the dataset become visible again.

Note:

You can use Ctrl + Shift + L to withdraw and apply the Filter option.

Read More: How to Hide Rows Based on Cell Value in Excel (5 Methods)


Similar Readings


Reason 3: Excel Rows Are Not Visible Because of Freeze Panes

When we apply the Freeze Panes in excel and scroll the data, it seems some rows have become hidden. But, these rows are not showing because we scrolled the dataset down after applying Freeze Panes. For example, in the below dataset, I have locked the first four rows applying Freeze Panes. Then I scrolled the dataset down. As a result, rows 5 to 7 have become invisible.

Excel Rows Are Not Visible because of Freeze Panes

Solution:

Now, I will show the unseen rows by following the below steps.

Steps:

  • First, go to the active worksheet and select any cell.
  • Then go to View > Freeze Panes > Unfreeze Panes.

Excel Rows Are Not Visible because of Freeze Panes

  • Selecting Unfreeze Panes will withdraw the panes from the worksheet and we will get the below output. We can see that all the rows are showing now.

Read More: Excel VBA: Unhide All Rows in Excel (5 Practical Examples)


Conclusion

In the above article, I have tried to discuss several reasons and probable solutions for excel rows not showing but not hidden. Hopefully, these solutions and explanations will be enough to solve your problems. Please let me know if you have any queries.


Related Articles

Hosne Ara

Hosne Ara

Hi, This is Hosne Ara. Currently, I do write for ExcelDemy. I have a long experience working with different industries and I have seen how vast the scope of Microsoft Excel is. So, eventually, I started to write articles on Excel and VBA. Basically, my articles are targeted to help people who are working in Excel. By profession, I am an Engineer. Materials and Metallurgical Engineering is my major. Besides, I am a certified Project Manager (PMP) too. I have worked with Power Plant and IT industry earlier. As a person, I am detail-oriented and love doing research. Establishing a greener world is one of my mottos.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo