text outside merge cells despite clicking wrap text

[chedd via OfficeKB.com]

Hi

I have a large amount of text and i have also merged 5 columns to fitt in
with spreaqdsheet design. I have already clicked the wrap text box, but text
is still going outside the designate cell and is not visible unless you
double click cell. How can I make sure all text is visible. Any ideas

 

[Gord Dibben]

Wrap text is functional in merged cells BUT.............autofit does not work
with merged cells so your row or column will not expand.

You will have to add event code to make the rows autofit.

See this thread for details.

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

My suggestion is.............don't use merged cells.........they cause no end of
problems.

Maybe a Textbox would be better suited for your design.


Gord Dibben MS Excel MVP

 

[Kathleen]

Hi Gord,

Is it possible to use a text box in an excel template (password protected )?

Kathleen

 

[Kathleen]

Hi Gord,

Tested it out and it seems that it is workable but the text box expanded
covers the next line of information. Is there anything I can do?

 

[Gord Dibben]

TextBox from the Drawing Toolbar?

You can set it to autosize or not when you right-click and Format
TextBox>Alignment.

If you want wrap text in the box you will have to allow it to re-size.


Gord

 

[Kathleen]

Hi Gord,

Yes, textbox from drawing toolbar. Did the autosize. Says, "can't not
shift off page"

Kathleen