extend text

AllenL · Mar 22nd, 2002, 02:07 PM

Question:
Some of my cells has very long text and they get cut off by the adjacent cell.
So I am wondering, is there a way to get the text to extend to the adjacent cell?
Thanks in advance

Al Chara · Mar 22nd, 2002, 02:13 PM

You can merge the two cells or AutoFit your cell.

jimmywanna · Mar 22nd, 2002, 02:33 PM

in the ceel you want the text in, right click the mouse. Click format ceels, there should be in there the option in the "alignment tab" of "shrink to fit".
this might work.

Mark W. · Mar 22nd, 2002, 02:37 PM

Quote:

On 2002-03-22 13:13, Al Chara wrote:
You can merge the two cells or AutoFit your cell.

If by "merge" you mean use the "Merge cell" Alignment format it won't produce the desired effect. If A1 contains "very, very long " and B1 contains "text" an attempt to apply a "Merge cell" format to A1:B1 will result in the merger of these two cells into one, but only contain "very, very long ".

[ This Message was edited by: Mark W. on 2002-03-22 13:38 ]

Yogi Anand · Mar 22nd, 2002, 03:46 PM

Hi AllenL:
Is it important that the row height not increase ... if this is not a consideration then go for FORMAT|CELLS|ALIGNMENT|Wrap_text
This will wrap the text in the same cell and will automatically increase the row height as required. You may also combine increasing the column width and the wrap feature to format your worksheet as necessary!
HTH

Al Chara · Mar 22nd, 2002, 05:19 PM

Mark,

I was assuming that the adjacent cell was empty (probably a bad assumption.)

Mar 22nd, 2002, 02:13 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	You can merge the two cells or AutoFit your cell. __________________ Kind regards, Al Chara

Mar 22nd, 2002, 03:46 PM	#5
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi AllenL: Is it important that the row height not increase ... if this is not a consideration then go for FORMAT\|CELLS\|ALIGNMENT\|Wrap_text This will wrap the text in the same cell and will automatically increase the row height as required. You may also combine increasing the column width and the wrap feature to format your worksheet as necessary! HTH __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 02:07 PM	#1
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Question: Some of my cells has very long text and they get cut off by the adjacent cell. So I am wondering, is there a way to get the text to extend to the adjacent cell? Thanks in advance

Mar 22nd, 2002, 02:33 PM	#3
jimmywanna Board Regular Join Date: Mar 2002 Posts: 182	in the ceel you want the text in, right click the mouse. Click format ceels, there should be in there the option in the "alignment tab" of "shrink to fit". this might work.

Mar 22nd, 2002, 05:19 PM	#6
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Mark, I was assuming that the adjacent cell was empty (probably a bad assumption.)