Collapsed Rows - Unable to Uncollapse

New Contributor

I feel like this is such a ridiculous issue to need help with.

I have a spreadsheet that has multiple non-consecutive collapsed rows.

I have tried unhiding all rows - they do not expand.

I have tried hiding all rows and then unhiding all rows - they still remain collapsed.

I have tired setting the row height to all rows - the collapsed rows do not adjust regardless of size submitted.

I have tried manually dragging the rows open. However, trying to catch them all is cumbersome as there are over 800 rows. Also, when I have manually opened rows, then applied a filter and then removed the filter - the rows collapse again.

There are no permission or locks on the file that I can identify.


Anyone have any ideas as to why this is happening and what to do to keep all rows expanded?


Thank you in advance.




3 Replies


Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

best response confirmed by Sergei Baklan (MVP)
I was able to fix the problem by turning my filters off and back on. Go figure. Thank you for trying to help me out.

@PamMcStayJZAD , thanks for sharing