Hello,
After my first post was successfully answered on here in an extremely short period of time, I'm back with another one. This time, I am creating a sheet in which users will choose a relevant options from a drop down list, but some of the options are lengthier and it appears as if the drop down list does not allow word wrap. As a result, some choices are not fully shown and I am afraid this will result in poor results and inaccurate data collection. How can I make the drop down list give an extra line or two when the choice does not fit into one line? I don't want to expand the width of the cell, since it will mess up other formatting.
Thanks!
Bookmarks