You can do this automatically. First select the text range and assign it
the largest text size you'll ever need, like 24. Then, with the same range
selected, select the "Shrink to Fit" option under Format, Cells, Alignment.
You may have to adjust row heights after this.

--
Jim
"cara" wrote in message
...
| Hi
| I have data strings of varying length that I want to have as big as
possible
| given a fixed column width. Is there a way to automate this or do I have
to
| format the font for every individual one?
| Thanks!
| Cara