ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can you create form in Excel & text wraps across several columns? (https://www.excelbanter.com/excel-worksheet-functions/98109-can-you-create-form-excel-text-wraps-across-several-columns.html)

quiana

Can you create form in Excel & text wraps across several columns?
 


Richard Buttrey

Can you create form in Excel & text wraps across several columns?
 
On Fri, 7 Jul 2006 08:53:03 -0700, quiana
wrote:

Yes.

Select the cells in question and then

Format, Cells,
select Alignment tab
click the 'Wrap Text' and 'Merge Cells' if necessary

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

RagDyeR

Can you create form in Excel & text wraps across several columns?
 
Would suggest to *not* recommend the use of "Merge Cells".

Besides, you cannot automatically "Wrap Text" when "Merge Cells" is enabled.

Better to select the columns in question, then:
<Format <Cells <Alignment tab,
And expand the "Horizontal" box and choose,
"Center Across Selection",
And then, if necessary, click on "Wrap Text",
And then click on the other tabs to assign formats to the selection.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Richard Buttrey" wrote in
message ...
On Fri, 7 Jul 2006 08:53:03 -0700, quiana
wrote:

Yes.

Select the cells in question and then

Format, Cells,
select Alignment tab
click the 'Wrap Text' and 'Merge Cells' if necessary

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________




All times are GMT +1. The time now is 01:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com