I'm using a drop down list, data validation and vlookup on a spreadsheet. All
is working well EXCEPT when the cell populates with the the verbiage from the
vlookup, the cell will not word wrap, shrink to fit, auto adjust or format as
I request. I need to size the cell according to the amount of text being
referenced . Do I need to do something special?