Set the cells to wrap text and the rows to autofit.


Gord Dibben MS Excel MVP

On Sat, 12 Dec 2009 09:40:01 -0800, lostsoul62
wrote:

I will edit a cell by taking some info out and then I have a cell with 100
points of space and I only need 14 because I'm doing 14 point fonts. So I do
a text wrap and the info just jumps up and down but the cell won't auto
adjust. Is there a way to adjust the cell without doing it manualy. because
if I have to do this to a dozen cells manualy it can be a pain. I hope I
explained my problem otherwise just ask because this is really bugging me.