Ask Your Question

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

asked 2014-12-29 01:55:14 +0200

The Crow gravatar image

In Excel I used to do this by using <alt><enter>. 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 <alt><enter> acts just like <enter>. What is the Calc equivalent?

edit retag flag offensive close merge delete


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.

Busumuru gravatar imageBusumuru ( 2014-12-30 15:31:23 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-12-29 03:10:42 +0200

m.a.riosv gravatar image


edit flag offensive delete link more

answered 2018-06-08 12:45:05 +0200

Albert25 gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2014-12-29 01:55:14 +0200

Seen: 4,209 times

Last updated: Jun 08 '18