I have an excel file wherein column J has dropdown values and Column K has a vlookup formula to fetch the values for value in Column K.
Query:
1. Users use column J dropdown values to populate the contents. They might choose from 100 different options. So basically a user will use 100 cells in column J. Since column K is formula driven, the appropriate values are auto populated. Wrap text is applied to Column J but the complete text is not shown as the length of the contents are more than 3000 characters.
Solution required:
I need the cell to autofit in column J. For Instance, if an user has made a selection in cell K10, then cell J10 should autofit to show the complete text. If he makes a selection in K11, then J11 should autofit.
I have the same functionality in 2 more columns and hence is proving a headache.
Regards,
Amaresh
Bookmarks