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

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.

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

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" wrote in message
...
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.

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

Please don't merge cells. The archive of this group includes countless
examples of problems caused by merged cells.
--
David Biddulph

"cruzr" wrote in message
...
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.

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

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" wrote in message
...
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.