Forum Discussion

shannonjeffries's avatar
shannonjeffries
Copper Contributor
Mar 30, 2020

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?

  • hiimpaul's avatar
    hiimpaul
    Copper 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.

  • amymarie's avatar
    amymarie
    Copper 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?

    • ZaZaJones's avatar
      ZaZaJones
      Copper Contributor

      amymarie 

      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.

       

    • Annadcruz's avatar
      Annadcruz
      Copper Contributor

      amymarie I had the same problem and is currently fixed for now. Remove filter then unhide the rows then Apply Filter.

       

      Hope it helps.

  • 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
    • kuchnicki's avatar
      kuchnicki
      Copper Contributor

      Abiola1, clearing all filters in the Sort & Filter group of the Data tab resolved my issue. Thank you!

    • JFitz5303's avatar
      JFitz5303
      Copper Contributor
      Thank you! Looks like this may have resolved the problem. Appreciate you taking the time to assist.
  • shannonjeffries's avatar
    shannonjeffries
    Copper Contributor
    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.
  • Hello,

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

Resources