Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I merge 3 lines of text to show in one row?
I am doing a family history excel document. One row should have approx. 3
lines of info, however, I can only get one row of info to show. When I dclick that row the info shows but when I print or do a print preview only one line of info shows. I have merged the cells in that row. |
#2
|
|||
|
|||
It sounds like you need to select Wrap Text from the Alignment tab of the
Format Cells dialog and/or increase the height of the row to accommodate the numbers of rows of text in the cell. -- Ian -- "pita29" wrote in message ... I am doing a family history excel document. One row should have approx. 3 lines of info, however, I can only get one row of info to show. When I dclick that row the info shows but when I print or do a print preview only one line of info shows. I have merged the cells in that row. |
#3
|
|||
|
|||
Try (as follows): and enter into a cell:
This is line 1 << Do not press Enter key - instead hold-down the Alt key while pressing the Enter key This is Line 2 << Same as above This is Line 3 << Same or press only Enter key when complete HTH "Ian" wrote in message ... It sounds like you need to select Wrap Text from the Alignment tab of the Format Cells dialog and/or increase the height of the row to accommodate the numbers of rows of text in the cell. -- Ian -- "pita29" wrote in message ... I am doing a family history excel document. One row should have approx. 3 lines of info, however, I can only get one row of info to show. When I dclick that row the info shows but when I print or do a print preview only one line of info shows. I have merged the cells in that row. |
#4
|
|||
|
|||
Merged cells don't play nice with autofitting rows.
Instead of doubleclicking on the row separator line, actually drag it to increase the rowheight. pita29 wrote: I am doing a family history excel document. One row should have approx. 3 lines of info, however, I can only get one row of info to show. When I dclick that row the info shows but when I print or do a print preview only one line of info shows. I have merged the cells in that row. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Text Field | Excel Discussion (Misc queries) | |||
HOW DO I SUMMARIZE A LIST OF TEXT, I WANT ONE A TO SHOW UP NOT 10 | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
how many lines can be in wrap text within a cell? | Excel Worksheet Functions |