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.

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.

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" wrote:

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.

.

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

On Sun, 13 Dec 2009 12:47:01 -0800, lostsoul62
wrote:

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" wrote:

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.

.