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