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
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.
Let’s solve the problem and display rows 7 and 8 following the below steps.
- First, put the cursor between rows 6 and 9 and right-click on it.
- Then click on the Row Height option.
- As a result, the row height dialog appears where you can see that row height is zero (0).
- Now, to make the rows visible, enter the desired height (say 20) in the Row Height field and press OK.
- Upon clicking OK, you will see that row 8 is visible now. Follow the same procedure to display row 7.
- You can show the shrunk row by double-clicking on the row header of the regarding row.
- 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.
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.
Follow the below steps to make the above-mentioned rows visible again.
- First, go to the corresponding worksheet that contains the data and click any of the cells.
- Next, from Excel Ribbon, go to Data > Filter. Then click on the Filter option to disable the filtering.
- Consequently, you will get the below result. All the rows in the dataset become visible again.
You can use Ctrl + Shift + L to withdraw and apply the Filter option.
- How to Hide and Unhide Rows in Excel (6 Easiest Ways)
- Unhide All Rows Not Working in Excel (5 Issues & Solutions)
- Formula to Hide Rows in Excel (7 Methods)
- Hidden Rows in Excel: How to Unhide or Delete Them?
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.
Now, I will show the unseen rows by following the below steps.
- First, go to the active worksheet and select any cell.
- Then go to View > Freeze Panes > Unfreeze 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.
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.
- VBA to Hide Rows Based on Cell Value in Excel (14 Examples)
- Hide Duplicate Rows Based on One Column in Excel (4 Methods)
- How to Hide Blank Rows in Excel VBA (4 Useful Methods)
- Excel Macro: Hide Rows Based on Cell Text in Excel (3 Simple Methods)
- Hide Rows Based on Cell Value with Conditional Formatting in Excel