How to filter in an online excel sheet?

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



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


It should work



It appears if click on Filter


You mean the size of the document?
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


I never seen such option exists