Forum Discussion
Solved
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 tr...
- 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.
I had the same issue. When you look at the rows, you see the double lines just like the ones you see when a column is hidden. The number of the rows might look like 1,2,3,4 and then 5-30, for example are missing or collapsed or hidden or grouped and the row numbering resumes with 31, 32, 33, etc.
You can manually click the double line, hold, and drag it down to reveal row 5 - and repeat for 6-30. But that takes forever. Unhiding doesn't work if these items were not hidden. Selecting the whole work sheet > Sort & Filter from the Editing menu > deselecting the Filter option made everything visible. You'll have to reset all your individual sortings/filters.
You can manually click the double line, hold, and drag it down to reveal row 5 - and repeat for 6-30. But that takes forever. Unhiding doesn't work if these items were not hidden. Selecting the whole work sheet > Sort & Filter from the Editing menu > deselecting the Filter option made everything visible. You'll have to reset all your individual sortings/filters.