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

SHRINK AND WRAP 7
Row Height - Forcing a Minimum ('03 & '07) 3
Row Height-Auto Adjust to Content? 5
Merged cells stop wrapping 4
wrap text 1
Rows expand to fit text typed in? 2
Shrinking text in Excel 2007 1
Why does some text wrap and fit and other doesn't 3

Top