Excel Filter drop-down box

M

MS User

I use the filter all the time, but would like to know if there is a way to
change the default to show either all the drop-down options or at least more
than the 3 that currently show?

I know you can pull down on the bottom right corner, but I would prefer not
to have to do this each time.
 
Top