column size in custom format with word wrap

  • Thread starter Thread starter Doug Glancy
  • Start date Start date
D

Doug Glancy

Win 2k, XL 2k

I'm using a custom format that's a General format followed by some text. I
put in some line feeds in using alt-0010 and turned on word wrap, but the
column still has to be as wide as if it were all on one line. I looked in
Google archives but couldn't find this exact issue.

Is there a solution to this? Here's the actual format:

General "Year[alt-0010]Monthly[alt-0010] Payment"

Thanks,

Doug
 
Gord,

I may not have been clear. I'm putting the line feed in the custom format.
I get multiple lines in the cell as intended, but if I try to autofit the
column down to the visible width of the text, I get the old "########." I
have to widen the column to about the width it would be without wrapping to
be able to see the text.

Does that alter your answer?

Thanks,

Doug

Gord Dibben said:
Doug

Use ALT + Enter key to get a line-feed.

Gord Dibben Excel MVP

Win 2k, XL 2k

I'm using a custom format that's a General format followed by some text. I
put in some line feeds in using alt-0010 and turned on word wrap, but the
column still has to be as wide as if it were all on one line. I looked in
Google archives but couldn't find this exact issue.

Is there a solution to this? Here's the actual format:

General "Year[alt-0010]Monthly[alt-0010] Payment"

Thanks,

Doug
Click to expand...
Click to expand...
 
I think you're stuck. And you have to resize the rowheight manually, too!

Can you use a helper cell:

=A1&" Year"&CHAR(10)&"monthly"&CHAR(10)&"Payment"

or even:
=text(a1,"#.00")&" Year" &CHAR(10)&"monthly" & CHAR(10)&"Payment"

If you needed to format the number, too.





Doug said:
Gord,

I may not have been clear. I'm putting the line feed in the custom format.
I get multiple lines in the cell as intended, but if I try to autofit the
column down to the visible width of the text, I get the old "########." I
have to widen the column to about the width it would be without wrapping to
be able to see the text.

Does that alter your answer?

Thanks,

Doug

Gord Dibben said:
Doug

Use ALT + Enter key to get a line-feed.

Gord Dibben Excel MVP

Win 2k, XL 2k

I'm using a custom format that's a General format followed by some text. I
put in some line feeds in using alt-0010 and turned on word wrap, but the
column still has to be as wide as if it were all on one line. I looked in
Google archives but couldn't find this exact issue.

Is there a solution to this? Here's the actual format:

General "Year[alt-0010]Monthly[alt-0010] Payment"

Thanks,

Doug
Click to expand...
Click to expand...
Click to expand...
 
Doug

You were clear. I missed the "custom format with line-feeds".

I have tried what you want but can't seem to find a way to get it done.

See Dave P.'s suggestion about entering the line feeds in the cell text via
formula.

Gord

Gord,

I may not have been clear. I'm putting the line feed in the custom format.
I get multiple lines in the cell as intended, but if I try to autofit the
column down to the visible width of the text, I get the old "########." I
have to widen the column to about the width it would be without wrapping to
be able to see the text.

Does that alter your answer?

Thanks,

Doug

Gord Dibben said:
Doug

Use ALT + Enter key to get a line-feed.

Gord Dibben Excel MVP

Win 2k, XL 2k

I'm using a custom format that's a General format followed by some text. I
put in some line feeds in using alt-0010 and turned on word wrap, but the
column still has to be as wide as if it were all on one line. I looked in
Google archives but couldn't find this exact issue.

Is there a solution to this? Here's the actual format:

General "Year[alt-0010]Monthly[alt-0010] Payment"

Thanks,

Doug
Click to expand...
Click to expand...
Click to expand...
 
Thanks Dave and Gord.

Doug

Dave Peterson said:
I think you're stuck. And you have to resize the rowheight manually, too!

Can you use a helper cell:

=A1&" Year"&CHAR(10)&"monthly"&CHAR(10)&"Payment"

or even:
=text(a1,"#.00")&" Year" &CHAR(10)&"monthly" & CHAR(10)&"Payment"

If you needed to format the number, too.





Doug said:
Gord,

I may not have been clear. I'm putting the line feed in the custom format.
I get multiple lines in the cell as intended, but if I try to autofit the
column down to the visible width of the text, I get the old "########." I
have to widen the column to about the width it would be without wrapping to
be able to see the text.

Does that alter your answer?

Thanks,

Doug

Gord Dibben said:
Doug

Use ALT + Enter key to get a line-feed.

Gord Dibben Excel MVP

On Tue, 24 Feb 2004 17:08:54 -0800, "Doug Glancy"

Win 2k, XL 2k

I'm using a custom format that's a General format followed by some
Click to expand...
text.
I
put in some line feeds in using alt-0010 and turned on word wrap, but the
column still has to be as wide as if it were all on one line. I
Click to expand...
looked
in
Google archives but couldn't find this exact issue.

Is there a solution to this? Here's the actual format:

General "Year[alt-0010]Monthly[alt-0010] Payment"

Thanks,

Doug
Click to expand...
Click to expand...
Click to expand...
 
Back
Top