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 th...
Abiola1
Mar 30, 2020MVP
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
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