Dear all, in excel 2007 you can expand the drop down box, but is resets it
back every time you again select the dropdown menu. How can I tell excel to
match the drop down box width to show all data in the cells even though the
original column width is not set to show all data in it (done to show more
columns on the screen).

Hi,

have received any replies on your question? I'm interested in knowing the answer, too. Please e-mail me if you know. Thanks!

E



Danie wrote:

Autofilter dropdown box width
07-May-08

Dear all, in excel 2007 you can expand the drop down box, but is resets it
back every time you again select the dropdown menu. How can I tell excel to
match the drop down box width to show all data in the cells even though the
original column width is not set to show all data in it (done to show more
columns on the screen).

Previous Posts In This Thread:

On Wednesday, May 07, 2008 9:54 AM
Danie wrote:

Autofilter dropdown box width
Dear all, in excel 2007 you can expand the drop down box, but is resets it
back every time you again select the dropdown menu. How can I tell excel to
match the drop down box width to show all data in the cells even though the
original column width is not set to show all data in it (done to show more
columns on the screen).


Submitted via EggHeadCafe - Software Developer Portal of Choice
Essential SQL Server 2000
http://www.eggheadcafe.com/tutorials...rver-2000.aspx