Maybe you can insert a new column and fill it with enough alt-enter's so that
it's the cell that determines how high that rowheight will be.

You can even hide that column if you want. The autofit will still look at that
hidden column (at least in xl2003).

Kris wrote:

Thanks, this may be the best way for an automatic row height adjustment - I
should have elaborated - my rows have from 1 to four lines of text and that
changes regularly as data is updated so I would still have to select those
with different numbers of lines and manually adjust and calculate how much
row height gives an equal margin above and below for various line counts.

"Dave Peterson" wrote:

And if you want to rely on autofitting the rows, you may want to (I wouldn't!)
add alt-enters as the first and last character.



Kris wrote:

Is there a way to add a small margin above and below the text in each row to
spread out the rows better and make them more readable? Thanks,

--

Dave Peterson


--

Dave Peterson