When you enter text into a Calc cell, the text continues in front of the neighboring cells to the right. Unless there are some contents in one of those cells, in which case the visible text is cut off before it can cover the existing cell contents.
To always be able to see all text contents in a cell, you might want to enable the automatic word wrap feature.
-
Click the cell or select some cells where you want the text to wrap automatically.
-
Choose Format - Cells.
-
Click the Alignment tab.
-
Enable Wrap Text Automatically.
You can also insert line breaks into the cell manually using Ctrl+Return.
-
Double-click a cell to enter text directly into the cell.
-
Press Ctrl+Return to advance the text cursor to the next line in the same cell.
Note that this doesn't work when you enter the text in the Input Line of the Formula Bar.