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

C

cruzr

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.
 
D

Drew

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.
 
K

KIM W

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top