• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Changing width of dropdown report filter

V

VVale

New Member
Hi,


is it possible to change the width of the dropdwon list box of a report filter in a pivot table? It is too short and the names are not displayed completely. I don't want the user to increase the width every time they need to select an item in the list.


I hope someone can help me.


Thank you very much


VVale
 
Just browsing on the forum to see where I can help... and you may have resolved this by now but this may help you...


Right click a cell on the pivot table... select Pivot Table Options

Make sure "Autofit column widths on update" is selected

Exit out and then refresh your pivot table...


Rgds

Jabba
 
You must log in or register to reply here.
Back
Top