Format cell to both Wrap text and shrink to fit

D

dunnL1

Is there a way to both wrap text in a cell and shrink to fit, so that I can
set the row height, rather than using Autofit?
 
A

ascott

did you try checking the shrink to fit box first and then the wrap text box?
that might work! I tried it just now on Excel 2003 and it worked
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change a great number of words in word files, with a macro as short as possible. 5
SHRINK AND WRAP 7
Grow/Shrink Text gradually from slide to slide 0
Select Text to End of Footnote 9
Wrapping and Anchors 0
Set row height, but allow wrap text 0
Excel does not accept text format! 0
Row Height-Auto Adjust to Content? 5

Top