Clicking on box that has lots of text,but only shows some text

I have to click the right arrow for the rest of the text to show up. is there a fix?

Text boxes wrap so maybe you mean a cell? If the text is longer than the cell length and the next cell has something in it then the text will be truncated and a red arrow will appear to show there is more in the cell.

You can wrap the text within the cell in one of three ways, select the cell then:

  • Click Format > Cells, select the Alignment tab and tick the box Wrap text automatically (left-hand red oval). Or
  • In the Sidebar under Properties > Alignment tick the box Wrap text (right–hand red oval)
  • Create a new style for cells with wrapped text. Apply that to the selected cell(s) by double-clicking the style

Or is something else? In which case a sample document might help.

2 Likes