PC Review


Reply
Thread Tools Rate Thread

How do I start a new paragraph in a merged cell?

 
 
cruzr
Guest
Posts: n/a
 
      26th Jun 2008
I am creating a form and would like to have a space where people can give
more info. I merged a lot of cells and would like to be able to make more
paragraphs.
 
Reply With Quote
 
 
 
 
Drew
Guest
Posts: n/a
 
      26th Jun 2008
Try "ALT+ENTER"

Remember that if using Excel 2003 and prior I think you will find that even
with merged cells, the character limit is 250 characters.

"cruzr" <(E-Mail Removed)> wrote in message
news:E0FB3473-19FA-4F8A-B256-(E-Mail Removed)...
>I am creating a form and would like to have a space where people can give
> more info. I merged a lot of cells and would like to be able to make more
> paragraphs.



 
Reply With Quote
 
KIM W
Guest
Posts: n/a
 
      26th Jun 2008
And related functionality to point out in this context:

If you want to paste in text with carriage returns into one cell, you must
do in cell editing. Just double-click on the cell or use F2 on highlighted
cell to get insertion bar blinking in the cell, then pase intext containing
carriage returns.

If you don't do this, your paste will go into multiple cells because of the
carriage return.

And yes, Merged Cells should be avoided if possible. Usually "Center Across
Selection" formatting does what one wants.

KIM W.

"David Biddulph" wrote:

> Please don't merge cells. The archive of this group includes countless
> examples of problems caused by merged cells.
> --
> David Biddulph
>
> "cruzr" <(E-Mail Removed)> wrote in message
> news:E0FB3473-19FA-4F8A-B256-(E-Mail Removed)...
> >I am creating a form and would like to have a space where people can give
> > more info. I merged a lot of cells and would like to be able to make more
> > paragraphs.

>
>
>

 
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
Autofit Merged cell Code is changing the format of my merged cells =?Utf-8?B?SkI=?= Microsoft Excel Misc 0 20th Aug 2007 02:12 PM
Can I paste a paragraph of text into a merged cell? =?Utf-8?B?VENQb2hsbWFu?= Microsoft Excel Misc 3 16th Feb 2007 06:58 PM
how do i link merged cells to a merged cell in another worksheet. =?Utf-8?B?aWJibQ==?= Microsoft Excel Worksheet Functions 3 27th Apr 2006 11:40 PM
Paragraph breaks in merged cells...? agshumph Microsoft Excel Discussion 2 23rd Aug 2004 08:56 AM
Determine start column/ end column of Merged Cell jC! Microsoft Excel Programming 3 8th Jul 2004 12:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:50 PM.