Rows keep hiding themselves.

Highlighted
New Contributor

I received an excel file with some rows hidden.  After unhinding them, every time I filter for a certain value in a column the rows hide themselves again, even though they were showing and I saved the document again.  How do I get them to stay unhidden?

8 Replies
Highlighted
Hello,

I guess that may be an Outline.. Kindly upload a screenshot to see
Highlighted

 

SNip of excel screen.JPG

@Abiola1 

Highlighted
To unhide all rows, select all the spreadsheet using CTRL + A. Then, in the Home tab, click on Format > Hide & Unhide > Unhide Rows
Highlighted
Thanks, I'll try that. Unfortunately the rows are still hidden. I can manually bring them back, only to have them hide again every time I filter.
Highlighted
Hello, if possible kindly upload your file and let me see
Highlighted
Highlighted
Hello,

I have see that Freeze Panes is added to the Excel file.

To Remove it: in the View tab, click on Freeze Panes and select Unfreeze panes.


Aside from that, I can't see any row that hides itself
Highlighted
Hello,

I think I understand the challenge, when you apply filter to a column, definitely the rows hide to only show the data you want. To remove ALL filter, in the Sort & Filter group of the Data tab, click on Clear..

All your data will be back without any rows hidden