Forum Discussion
Collapsed Rows - Unable to Uncollapse
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.