| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
| Can I paste a paragraph of text into a merged cell? | Excel Discussion (Misc queries) | |||
| Can't see all of the paragraph text in the cell. | Excel Discussion (Misc queries) | |||
| how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
| Starting a new paragraph within a cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
