Sheet View with "Filters" off?

%3CLINGO-SUB%20id%3D%22lingo-sub-2782533%22%20slang%3D%22en-US%22%3ESheet%20View%20with%20%22Filters%22%20off%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2782533%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20I'm%20wondering%20if%20%22Filters%22%20must%20be%20turned%20on%20at%20all%20times%20for%20Sheet%20Views%20to%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20using%20a%20spreadsheet%20shared%20between%203%20people%20to%20track%20work%20that%20we%20do.%20We%20would%20like%20to%20be%20able%20to%20use%20Sheet%20View%20to%20easily%20view%20just%20individual%20user%20data%20from%20the%20main%20sheet%20by%20simply%20selecting%20one%20filtered%20sheet%2C%20instead%20of%20going%20into%20the%20main%20sheet%20and%20sorting%2Ffiltering%2Fetc.%3C%2FP%3E%3CP%3EWe%20did%20it%20before%20with%20a%20macro%2C%20but%20that%20is%20not%20possible%20with%20this%20new%20Live365%20sheet%20that%20we%20are%20being%20required%20to%20migrate%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20made%20several%20sheet%20views%2C%20but%20it%20seems%20as%20soon%20as%20Filters%20are%20turned%20%22off%22%2C%20all%20of%20the%20sheet%20views%20show%20the%20same%20thing%20as%20the%20%22Default%22%20sheet.%26nbsp%3BHaving%20Filter%20always%20%22On%22%20shows%20the%20dropdown%20arrow%20on%20every%20column%20on%20every%20sheet.%20I%20am%20trying%20to%20avoid%20that%20as%20it%20makes%20the%20idea%20of%20Sheet%20View%20irrelevant%20to%20us.%3C%2FP%3E%3CP%3EThe%20attached%20picture%20(fake%20spreadsheet)%20shows%20the%20dropdown%20arrows.%20My%20goal%20is%20simplicity%20for%20the%20users%20and%20for%20a%20supervisor%20(with%20limited%20Excel%20knowledge)%20who%20may%20want%20to%20go%20in%20and%20look%20at%20individual%20workflow%2Fs.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FILTER.JPG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F312683i5EBE42AEFD3EEB95%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22FILTER.JPG%22%20alt%3D%22FILTER.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20have%20multiple%20Sheet%20View%20sheets%20that%20are%20filtered%20by%20default%20without%20having%20Filters%20turned%20on%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI%20feel%20there%20is%20a%20simple%20fix%20for%20this%2C%20but%20NONE%20of%20the%20help%20pages%20(Microsoft%20or%20independent)%20I%20have%20found%20address%20the%20concept%20at%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20stumped.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2782533%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello. I'm wondering if "Filters" must be turned on at all times for Sheet Views to work.

 

We are using a spreadsheet shared between 3 people to track work that we do. We would like to be able to use Sheet View to easily view just individual user data from the main sheet by simply selecting one filtered sheet, instead of going into the main sheet and sorting/filtering/etc.

We did it before with a macro, but that is not possible with this new Live365 sheet that we are being required to migrate to.

 

I have made several sheet views, but it seems as soon as Filters are turned "off", all of the sheet views show the same thing as the "Default" sheet. Having Filter always "On" shows the dropdown arrow on every column on every sheet. I am trying to avoid that as it makes the idea of Sheet View irrelevant to us.

The attached picture (fake spreadsheet) shows the dropdown arrows. My goal is simplicity for the users and for a supervisor (with limited Excel knowledge) who may want to go in and look at individual workflow/s.

FILTER.JPG

 

Can I have multiple Sheet View sheets that are filtered by default without having Filters turned on? 

I feel there is a simple fix for this, but NONE of the help pages (Microsoft or independent) I have found address the concept at all.

 

I'm stumped.

0 Replies