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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200807/1

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/micro...1c160cbeb27874

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

On Thu, 10 Jul 2008 10:00:45 GMT, "chedd via OfficeKB.com" <u18187@uwe wrote:

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

Hi Gord,

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

Kathleen

"Gord Dibben" wrote:

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/micro...1c160cbeb27874

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

On Thu, 10 Jul 2008 10:00:45 GMT, "chedd via OfficeKB.com" <u18187@uwe wrote:

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

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?

"Kathleen" wrote:

Hi Gord,

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

Kathleen

"Gord Dibben" wrote:

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/micro...1c160cbeb27874

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

On Thu, 10 Jul 2008 10:00:45 GMT, "chedd via OfficeKB.com" <u18187@uwe wrote:

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

TextBox from the Drawing Toolbar?

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

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


Gord

On Wed, 16 Jul 2008 12:44:09 -0700, Kathleen
wrote:

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?

"Kathleen" wrote:

Hi Gord,

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

Kathleen

"Gord Dibben" wrote:

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/micro...1c160cbeb27874

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

On Thu, 10 Jul 2008 10:00:45 GMT, "chedd via OfficeKB.com" <u18187@uwe wrote:

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

Hi Gord,

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

Kathleen

"Gord Dibben" wrote:

TextBox from the Drawing Toolbar?

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

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


Gord

On Wed, 16 Jul 2008 12:44:09 -0700, Kathleen
wrote:

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?

"Kathleen" wrote:

Hi Gord,

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

Kathleen

"Gord Dibben" wrote:

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/micro...1c160cbeb27874

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

On Thu, 10 Jul 2008 10:00:45 GMT, "chedd via OfficeKB.com" <u18187@uwe wrote:

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