Home

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