Automatically resizing a cell

T

Tod

When you pasted you probably also pasted the formatting
into the cell. You'll need to use PasteSpecial with Values
to preserve the formatting.

To do that:

After copying, go to the cell where you want to paste.
Right click in the cell and choose Paste Special
Select Values from the Paste section, then click OK.

tod
-----Original Message-----
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top