Forum Discussion
shannonjeffries
Mar 30, 2020Copper Contributor
Rows keep hiding themselves.
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?
- hiimpaulCopper Contributor
Look in all of your filters and make sure that blanks are selected. If there is one that is not selected, select it and your issue should be resolved.
- amymarieCopper Contributor
shannonjeffriesI am having the same issue - so frustrating. Every time i filter (in my case an employee name), after unfiltering to see all, many rows are automatically hidden. I have to manually unhide EVERY TIME! Have you found a solution yet?
- ZaZaJonesCopper Contributor
I keep having the same problem, instead of mannually doing it, you can highlight the whole spreadsheet, do format and hide everything first, then do format cells and unhide them. that will bring them back faster but i still have not heard how to keep it from hiding the cells period. It did not do this int he past.
- 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 - shannonjeffriesCopper ContributorThanks, 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.
- Hello, if possible kindly upload your file and let me see
- Hello,
I guess that may be an Outline.. Kindly upload a screenshot to see- shannonjeffriesCopper Contributor
- To unhide all rows, select all the spreadsheet using CTRL + A. Then, in the Home tab, click on Format > Hide & Unhide > Unhide Rows