Advanced filtering in Excel Online?

%3CLINGO-SUB%20id%3D%22lingo-sub-162794%22%20slang%3D%22en-US%22%3EAdvanced%20filtering%20in%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-162794%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I'm%20trying%20to%20find%20a%20workaround%20to%20the%20Excel%20Online%20filtering%20problem%2C%20whereby%20when%20one%20person%20filters%20a%20worksheet%20the%20filter%20applies%20to%20everyone%20else's%20view.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20thought%20maybe%20I%20could%20use%20Advanced%20Filtering%20to%20replicate%20some%20of%20the%20most%20common%20filters%2C%20but%20can't%20find%20a%20way%20of%20creating%20Advanced%20Filters%20in%20Excel%20Online.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20this%20possible%2C%20and%2For%26nbsp%3Bcan%20anyone%20suggest%20a%20way%20of%20filtering%20data%20in%20Excel%20Online%20that%20doesn't%20affect%20the%20views%20of%20other%20people%20simulataneously%20editing%20the%20worksheet%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-162794%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1721182%22%20slang%3D%22en-US%22%3ERe%3A%20Advanced%20filtering%20in%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1721182%22%20slang%3D%22en-US%22%3E%3CP%3E%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F112125%22%20target%3D%22_blank%22%3E%40Jon%20Chambers%3C%2FA%3E%20I'm%20looking%20for%20the%20same%20answer%2C%20I%20think%20it's%20only%20available%20in%20offline%20apps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1721281%22%20slang%3D%22en-US%22%3ERe%3A%20Advanced%20filtering%20in%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1721281%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F812114%22%20target%3D%22_blank%22%3E%40sweetsinner%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20were%20two%20different%20questions.%3C%2FP%3E%0A%3CP%3EIs%20Advance%20Filter%20available%20for%20Excel%20Online%3F%20-%20no%3C%2FP%3E%0A%3CP%3EIs%20it%20a%20way%26nbsp%3B%3CSPAN%3Eof%20filtering%20data%20in%20Excel%20Online%20that%20doesn't%20affect%20the%20views%20of%20other%20people%20simultaneously%26nbsp%3Bediting%20the%20worksheet%3F%20-%20Yes%2C%20that's%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fsheet-views-in-excel-0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6%23%3A~%3Atext%3DSheet%2520views%2520are%2520an%2520innovative%2Cwithout%2520being%2520disrupted%2520by%2520others.%26amp%3Btext%3DYou%2520can%2520even%2520set%2520up%2Cwhich%2520view%2520you%2527re%2520in.%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ESheet%20Views%20in%20Excel%3C%2FA%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello, I'm trying to find a workaround to the Excel Online filtering problem, whereby when one person filters a worksheet the filter applies to everyone else's view.

 

I thought maybe I could use Advanced Filtering to replicate some of the most common filters, but can't find a way of creating Advanced Filters in Excel Online.

 

Is this possible, and/or can anyone suggest a way of filtering data in Excel Online that doesn't affect the views of other people simulataneously editing the worksheet?

 

Thank you

2 Replies
Highlighted

;@Jon Chambers I'm looking for the same answer, I think it's only available in offline apps

Highlighted

@sweetsinner 

There were two different questions.

Is Advance Filter available for Excel Online? - no

Is it a way of filtering data in Excel Online that doesn't affect the views of other people simultaneously editing the worksheet? - Yes, that's Sheet Views in Excel