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
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.
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
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
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.