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.

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" <[email protected]> wrote in message
news:[email protected]...
>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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>>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.
>
>

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