How to filter in an online excel sheet?

Copper 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

@hanaademaj 

 

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

 

It should work

 

@hanaademaj 

It appears if click on Filter

image.png

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

@hanaademaj 

I never seen such option exists