Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Center Comments on Center of Screen | Excel Discussion (Misc queries) | |||
Merge and Center and Center Accross Selection | New Users to Excel | |||
Any insight into cause of Autofilter buttons to stop working? | Excel Discussion (Misc queries) | |||
make autofilter buttons more discernable? | Excel Discussion (Misc queries) | |||
Add buttons for Center Across and Paste Formula | Excel Discussion (Misc queries) |