How to filter in an online excel sheet?

%3CLINGO-SUB%20id%3D%22lingo-sub-1491769%22%20slang%3D%22en-US%22%3EHow%20to%20filter%20in%20an%20online%20excel%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491769%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20question%20regarding%20filtering%20in%20excel.%20When%20I%20usually%20create%20a%20filter%20and%20having%20my%20excel%20file%20saved%20on%20the%20computer%2C%20I%20get%20a%20filter%20that%20looks%20like%20-%26gt%3B%20(see%20picture%201).%20However%2C%20when%20the%20document%20is%20uploaded%20to%20my%20onedrive%20the%20filtering%20ends%20up%20like%20-%26gt%3B%20(see%20picture%202).%20Is%20there%20a%20possibility%20to%20keep%20the%20same%20filtering%20%22list%22%20when%20its%20uploaded%20to%20onedrive%20as%20in%20picture%201%3F%26nbsp%3B%3CBR%20%2F%3EThanks%20in%20advance%2C%20Hana%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Annotation%202020-06-26%20132037.png%22%20style%3D%22width%3A%20354px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201290i84275AFBB32A0E26%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Annotation%202020-06-26%20132037.png%22%20alt%3D%22Picture%201%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EPicture%201%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Annotation%202020-06-26%20131859.png%22%20style%3D%22width%3A%20309px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201291i02B6FB5611B41671%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Annotation%202020-06-26%20131859.png%22%20alt%3D%22Picture%202%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EPicture%202%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1491769%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491787%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20filter%20in%20an%20online%20excel%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491787%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711158%22%20target%3D%22_blank%22%3E%40hanaademaj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20to%20reduce%20the%20size%2C%20(Control%20%2B%20%22-%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20should%20work%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491792%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20filter%20in%20an%20online%20excel%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491792%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711158%22%20target%3D%22_blank%22%3E%40hanaademaj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20appears%20if%20click%20on%20Filter%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20396px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201292iDBA920E7F7772CDF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491797%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20filter%20in%20an%20online%20excel%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491797%22%20slang%3D%22en-US%22%3EYou%20mean%20the%20size%20of%20the%20document%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491805%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20filter%20in%20an%20online%20excel%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491805%22%20slang%3D%22en-US%22%3EYes%2C%20I%20can%20see%20the%20options%20if%20I%20click%20filter%2C%20but%20I%20just%20wanted%20to%20see%20what%20kind%20of%20possibilities%20I%20have%20of%20creating%20the%20same%20view%20as%20in%20example%201%3F%20(so%20that%20one%20can%20see%20the%20filtering%20directly)%20and%20it%20that%20is%20even%20possible%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491817%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20filter%20in%20an%20online%20excel%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491817%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711158%22%20target%3D%22_blank%22%3E%40hanaademaj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20never%20seen%20such%20option%20exists%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello everyone, 

I have a question regarding filtering in excel. When I usually create a filter and having my excel file saved on the computer, I get a filter that looks like -> (see picture 1). However, when the document is uploaded to my onedrive the filtering ends up like -> (see picture 2). Is there a possibility to keep the same filtering "list" when its uploaded to onedrive as in picture 1? 
Thanks in advance, Hana

Picture 1Picture 1Picture 2Picture 2

5 Replies
Highlighted

@hanaademaj 

 

Try to reduce the size, (Control + "-")

 

It should work

 

Highlighted

@hanaademaj 

It appears if click on Filter

image.png

Highlighted
You mean the size of the document?
Highlighted
Yes, I can see the options if I click filter, but I just wanted to see what kind of possibilities I have of creating the same view as in example 1? (so that one can see the filtering directly) and it that is even possible
Highlighted

@hanaademaj 

I never seen such option exists