Rows keep hiding themselves.

%3CLINGO-SUB%20id%3D%22lingo-sub-1265129%22%20slang%3D%22en-US%22%3ERows%20keep%20hiding%20themselves.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1265129%22%20slang%3D%22en-US%22%3E%3CP%3EI%20received%20an%20excel%20file%20with%20some%20rows%20hidden.%26nbsp%3B%20After%20unhinding%20them%2C%20every%20time%20I%20filter%20for%20a%20certain%20value%20in%20a%20column%20the%20rows%20hide%20themselves%20again%2C%20even%20though%20they%20were%20showing%20and%20I%20saved%20the%20document%20again.%26nbsp%3B%20How%20do%20I%20get%20them%20to%20stay%20unhidden%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1265129%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1265188%22%20slang%3D%22en-US%22%3ERe%3A%20Rows%20keep%20hiding%20themselves.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1265188%22%20slang%3D%22en-US%22%3EHello%2C%20%3CBR%20%2F%3E%3CBR%20%2F%3EI%20guess%20that%20may%20be%20an%20Outline..%20Kindly%20upload%20a%20screenshot%20to%20see%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1265224%22%20slang%3D%22en-US%22%3ERe%3A%20Rows%20keep%20hiding%20themselves.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1265224%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SNip%20of%20excel%20screen.JPG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F180630iC75C5DB47054D8FB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22SNip%20of%20excel%20screen.JPG%22%20alt%3D%22SNip%20of%20excel%20screen.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1265337%22%20slang%3D%22en-US%22%3ERe%3A%20Rows%20keep%20hiding%20themselves.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1265337%22%20slang%3D%22en-US%22%3ETo%20unhide%20all%20rows%2C%20select%20all%20the%20spreadsheet%20using%20CTRL%20%2B%20A.%20Then%2C%20in%20the%20Home%20tab%2C%20click%20on%20Format%20%26gt%3B%20Hide%20%26amp%3B%20Unhide%20%26gt%3B%20Unhide%20Rows%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1265407%22%20slang%3D%22en-US%22%3ERE%3A%20Rows%20keep%20hiding%20themselves.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1265407%22%20slang%3D%22en-US%22%3EThanks%2C%20I'll%20try%20that.%20Unfortunately%20the%20rows%20are%20still%20hidden.%20I%20can%20manually%20bring%20them%20back%2C%20only%20to%20have%20them%20hide%20again%20every%20time%20I%20filter.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1265424%22%20slang%3D%22en-US%22%3ERE%3A%20Rows%20keep%20hiding%20themselves.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1265424%22%20slang%3D%22en-US%22%3EHello%2C%20if%20possible%20kindly%20upload%20your%20file%20and%20let%20me%20see%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1265493%22%20slang%3D%22en-US%22%3ERE%3A%20Rows%20keep%20hiding%20themselves.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1265493%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1265534%22%20slang%3D%22en-US%22%3ERE%3A%20Rows%20keep%20hiding%20themselves.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1265534%22%20slang%3D%22en-US%22%3EHello%2C%20%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20see%20that%20Freeze%20Panes%20is%20added%20to%20the%20Excel%20file.%20%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20Remove%20it%3A%20in%20the%20View%20tab%2C%20click%20on%20Freeze%20Panes%20and%20select%20Unfreeze%20panes.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAside%20from%20that%2C%20I%20can't%20see%20any%20row%20that%20hides%20itself%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1265544%22%20slang%3D%22en-US%22%3ERe%3A%20Rows%20keep%20hiding%20themselves.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1265544%22%20slang%3D%22en-US%22%3EHello%2C%20%3CBR%20%2F%3E%3CBR%20%2F%3EI%20think%20I%20understand%20the%20challenge%2C%20when%20you%20apply%20filter%20to%20a%20column%2C%20definitely%20the%20rows%20hide%20to%20only%20show%20the%20data%20you%20want.%20To%20remove%20ALL%20filter%2C%20in%20the%20Sort%20%26amp%3B%20Filter%20group%20of%20the%20Data%20tab%2C%20click%20on%20Clear..%3CBR%20%2F%3E%3CBR%20%2F%3EAll%20your%20data%20will%20be%20back%20without%20any%20rows%20hidden%3C%2FLINGO-BODY%3E
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?

12 Replies
Hello,

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

 

SNip of excel screen.JPG

@Abiola1 

To unhide all rows, select all the spreadsheet using CTRL + A. Then, in the Home tab, click on Format > Hide & Unhide > Unhide Rows
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, if possible kindly upload your file and let me see
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
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

@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?

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

 

Hope it helps.

@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.

 

Thank you! Looks like this may have resolved the problem. Appreciate you taking the time to assist.