extend text

AllenL

Board Regular
Joined
Mar 14, 2002
Messages
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
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,016
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top