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.
Or
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.
[Ctrl]+[Enter]
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