Center Autofilter buttons
 

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

Center Autofilter buttons
 

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).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jxbeeman" wrote:

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

Center Autofilter buttons
 

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

jxbeeman wrote:

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

--

Dave Peterson