All I want is the text to fit in the cell

[suestew]

So I've used "wrap text" and I've used "Row - auto fit" and I still have text
that is not showing up in the cell. I have 2800 lines and I'm going to have
to go through individually and make sure they are all the right height.
There has to be a simpler way.

Please help. I'm desperate.

Thanks.

 

[Michael]

Cells.AutoFit

 

[Michael]

Sorry,
I meant: Cells.Rows.AutoFit

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

 

[suestew]

Is this a macro?

Cells.AutoFit
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

 

[suestew]

Sorry I'm so confused but are you sending me a macro or are you telling me
how to use the Excel functions?

If its the latter, I've already tried to use Row - auto fit and it's not
working.

thanks again for your help.

 

[Otto Moehrbach]

That is one line of a macro.
If you want to do this manually, select your entire range or select the
entire sheet. Then you can wrap it all, and/or autofit all the columns and
rows. HTH Otto

 

[Gord Dibben]

How much text is not showing up?

If you have more than 1024 characters in a cell Excel will display only the
first 1024.

Add an Alt + Enter every 80-100 chars.

Another thing..............if cells are merged, autofit will not work.

You would need event code to autofit any row with merged cells.


Gord Dibben MS Excel MVP

 

[suestew]

Thanks - your response was very helpful. I do have more than 1024 characters
in many of the cells. Now the question is, can I filter cells that have that
or more so I can adjust those by group rather than individually.

Thanks.

 

[Dave Peterson]

Like data|autofilter???

If that's what you mean, you may want to read Debra Dalgleish's notes:
http://contextures.com/xlautofilter02.html#String

 

[Gord Dibben]

Assuming cells are in column A

In B1 enter =LEN(A1) and double-click fill handle to copy down.

Autofilter on column B for custom>greater than 1000


Gord

 

[Roy Smith]

I would certainly appreciate receiving the Excel event code to autofit
rows with merged cells

 

[Gord Dibben]

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which is all one line.

http://groups.google.com/group/micr...60cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874


Gord Dibben MS Excel MVP