Cells that don't auto go back?

[lostsoul62]

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.

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[lostsoul62]

I've done that and it doesn't work. I have a cell with 3 lines of data but
there is 4 lines of space which means the top line is empty and can't be
deleted and I can't get my curser in it. Any Idea?

 

[Gord Dibben]

I'm thinking I don't know what you mean by "taking some info out".

Did you leave any extra spaces when you edited?

Let's say you have 100 characters in a cell set for wrap text and row
autofit.

F2 to enter edit mode. Backspace 30 times to remove 30 characters.

Hit Enter key.

What happens to row autofit?


Gord