Center Autofilter buttons

[jxbeeman]

Hi,
I was wondering if there is a way to center autofilter buttons, or maybe
move them to the left side? An even better way would be to get the cell to
recognize that the autofilter button is in the cell so it doesn't write text
under the button.

Thanks,
Josh

 

[Luke M]

Unfortunately, none of that is available. However, if you autofit a column
that contains autofilters, the cell width does adjust to properly display all
the text as well as the button (close to accomplishing your last goal).

 

[Dave Peterson]

I don't think so.

But you can try this...

In each of your header cells, make sure you finish with an alt-enter. This will
force a new line in the cell and the arrow will be on that same line as the
empty line.

Or you could widen the columns (autofit should work ok).