Wrap not wrapping

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ralphael1 - 28 Sep 2005 21:36 GMT

I go FORMAT, click CELLS, click NUMBER, click TEXT, click WRAP TEXT as
I usually do but for some reason it does not wrap.
Anyone have a clue?
Maybe I need to turn the machine off and let it recharge...

Ralphael, the OLD one

Reply to this Message

Gord Dibben - 28 Sep 2005 23:01 GMT

Ralpael

Format>Cells>Alignment tab. Wrap text is on this Tab.

Checkmark it a couple of times to set and reset it.

Then make sure the row is formatted to "Autofit".

If you are dealing with "merged" cells, this presents a whole 'nother problem
as autofit does not work with merged cells unless you use code.

Gord Dibben Excel MVP

>I go FORMAT, click CELLS, click NUMBER, click TEXT, click WRAP TEXT as
>I usually do but for some reason it does not wrap.
>Anyone have a clue?
>Maybe I need to turn the machine off and let it recharge...
>
>Ralphael, the OLD one

Reply to this Message

Ralphael1 - 28 Sep 2005 23:30 GMT

> Ralpael
>
[quoted text clipped - 8 lines]
>
> Gord Dibben Excel MVP

Gord, I always do just as you pointed out except for the "Autofit."
I have no idea what this is or where to look for it. I have never used
this before and have had no problems until today.

Ralphael, the Old one.

Reply to this Message

Gord Dibben - 29 Sep 2005 16:17 GMT

Select the cell and Format>Row>Autofit.

Gord

>> Ralpael
>>
[quoted text clipped - 14 lines]
>
>Ralphael, the Old one.

Reply to this Message

Ralphael1 - 30 Sep 2005 00:53 GMT

Many thanks, it works now. KUDOS 2 U

Ralph

Reply to this Message

pknivens - 30 Sep 2005 12:07 GMT

What is the Code for the merged cells? I have this proble all the time
and just mess with the borders until it look right....very
frustrating.

Ralphael1 Wrote:

> > Ralpael
> >
[quoted text clipped - 15 lines]
>
> Ralphael, the Old one.

Signature

pknivens

Reply to this Message

Gord Dibben - 30 Sep 2005 18:41 GMT

pk

You have asked for code to deal with autofitting merged cells.

I will first give you my standard rant on merged cells.

Merged cells are the spawn of Satan!

They cause more problems with Excel than any other feature I can think of.

Copying, cutting, pasting, sorting, filtering are all affected by merged
cells.

Now the code<g>

Jim Rech has written code for this.

http://groups.google.com/groups?threadm=e1%241uzL1BHA.1784%40tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

Gord

>What is the Code for the merged cells? I have this proble all the time
>and just mess with the borders until it look right....very
[quoted text clipped - 20 lines]
>>
>> Ralphael, the Old one.

Reply to this Message