In Calc how do I enter two lines of text into one cell?

In Excel I used to do this by using . I have some spreadsheets from Excel with two or more lines of text and I’d like to continue the practice. But in Calc using acts just like . What is the Calc equivalent?

Select the cell containing your text. Then, go to Format - Alignment - Justified.
First select the cell. Go to Format - Cells. Hit the Alignment tab in the dialog box. Select the check box adjacent to “Wrap text automatically”. Click the OK button. That’s all.


1 Like

When just selecting the cell and pasting multiple lines, it opens the import dialog.

To paste multiple lines into the same cell, first double-click the cell to enter edit mode, then paste.

1 Like