PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?cXVpYW5h?=
Guest
Posts: n/a
 
      7th Jul 2006

 
Reply With Quote
 
 
 
 
Richard Buttrey
Guest
Posts: n/a
 
      7th Jul 2006
On Fri, 7 Jul 2006 08:53:03 -0700, quiana
<(E-Mail Removed)> 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 With Quote
 
RagDyeR
Guest
Posts: n/a
 
      8th Jul 2006
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" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
On Fri, 7 Jul 2006 08:53:03 -0700, quiana
<(E-Mail Removed)> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create form to add data to Excel 40 odd columns =?Utf-8?B?RGV4eHRlcnI=?= Microsoft Excel Misc 6 15th May 2006 08:43 PM
Not all text wraps in a cell containing large amount of text =?Utf-8?B?S3Jpcw==?= Microsoft Excel Misc 3 23rd Dec 2005 04:25 PM
save as text - wraps Tim Windows XP Internet Explorer 1 21st May 2004 03:33 AM
TEXT WRAPS AROUND ON A BUTTON =?Utf-8?B?TmFzb3M=?= Microsoft Access Form Coding 1 14th May 2004 02:53 PM
It always wraps my text Roach Microsoft Excel Misc 1 8th Jan 2004 05:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:23 AM.