Automatically resizing a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.

If I have a cell with "wrap text" and I type in enough text, the height of the cell/row automatically adjusts. Fine.

But SOMETIMES, the height does NOT adjust, and the text gets scrunched and isn't legible. Why does that happen, and is there any way to resize the cell/row automatically? I seem to recall that if you hit F2 within the cell, it would resize it. That doesn't appear to work for me currently, and I'd obviously prefer a more automatic method to solve my problem.

Specifically, I pasted some HTML into Excel, and now it will not adjust the row height. I don't have access to the original HTML anymore, so I have to work with what I have.
 
I have had this problem as well. Go to Format/Row and
select AutoFit.

Yvonne
-----Original Message-----
Hi.

If I have a cell with "wrap text" and I type in enough
Click to expand...
text, the height of the cell/row automatically adjusts.
Fine.
But SOMETIMES, the height does NOT adjust, and the text
Click to expand...
gets scrunched and isn't legible. Why does that happen,
and is there any way to resize the cell/row
automatically? I seem to recall that if you hit F2
within the cell, it would resize it. That doesn't appear
to work for me currently, and I'd obviously prefer a more
automatic method to solve my problem.
Specifically, I pasted some HTML into Excel, and now it
Click to expand...
will not adjust the row height. I don't have access to
the original HTML anymore, so I have to work with what I
have.
 
This problem happens to some of my sheets when the view is set at a
ratio other than the set ones, i.e. 90%

It only appears to effect the screen and not the print out.

Try using a different ratio if this is your problem.

Mike
 
Back
Top