Range WrapText and AutoFit with Bold
Dave Peterson wrote:
Did you use alt-enter to force new lines in the cell--where you
wanted the lines to break?
No, I don't want to do that. I'm loading data programmatically. The
column headings will be different every time.
Then I use format|column|width|255 and hit enter
then format|column|autofit
I can do that programmatically, but then the columns are too wide. I
want the text to wrap without breaking words in the middle, widening
the columns just enough to fit whole words but not the whole text.
Thanks for the suggestions.
-- Peter Gummer
|