Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Can you create form in Excel & text wraps across several columns?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 296
Default 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
__________________________
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default 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
__________________________


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Transfer data from Text Form Fields in MS Word into Excel? CWillis Excel Discussion (Misc queries) 1 July 18th 06 06:35 AM
Convert Text to Columns with Excel 2007 beta does not work well Martin Excel Worksheet Functions 0 June 7th 06 03:17 PM
How do I create a database from an Excel form? FIRESIGN98 Excel Discussion (Misc queries) 1 January 5th 06 08:58 PM
Display form from an VB application in Excel kuhni Excel Discussion (Misc queries) 0 August 10th 05 06:04 PM
create a data entry form template in Excel 2003? david.bottomley@haltoncollege Excel Discussion (Misc queries) 0 January 19th 05 09:59 AM


All times are GMT +1. The time now is 08:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"