[Solved] How to use a cell like a page in Calc?

[mtnylmz]

Can I use a cell in Calc like a page. I want to use two lines in a cell but I cannot do it. Cells seem to be only one line. When I click on "enter", I pass to another cell. Is it possible?

[FJCC]

Double click on a cell to put the edit cursor in the cell. Type the first line of text then press Ctrl + Enter to move to the second line.

[Cazer]

Yes, you can indeed use a cell in Calc almost like a mini-page! As FJCC mentioned, you'll need to double-click the cell to put the edit cursor in it. Type your first line, then press Ctrl + Enter to start a new line within the same cell. Just remember that the text edit cursor has to be inside the cell, not at the input line, for this to work​.
For more information on how to navigate cells and customize the effect of the Enter key, you might find this article from the OpenOffice wiki really helpful: https://wiki.openoffice.org/wiki/Docume ... eadsheets

[Zizi64]

Without Ctrl-Enter:

Set the Automatic wrap property in the applied cell style.The text will flow into the next line inside a single cell when the text exceed the cell width.

Multiline cell by Wrap automatically option.ods

(17.14 KiB) Downloaded 38 times

Sample file created in LibreOffice 7.4.6