# Contain text within cell [closed]

Hey guys. Am just wondering if there is any function in LO that I could use to automatically contain text within a cell…

Usually when you type text into a cell and there is too much text to fit in that cell, the little red arrows appear to either side of the cell right?

I want LO to automatically start a new line of text once the cell is horizontally full, extending the row the text is entered in downward to accommodate the extra text.

Also if possible I would like to be able to set the width of borders on the inside of the cell, meaning that when the line of text encroaches upon the border of the cell, a new line is started automatically.

A good example is the box I am typing in right now, when I get to the right hand edge of this box and keep typing……….. a new line starts automatically.

At the moment I have to enter line breaks manually, which is becoming rather tedious, as when I edit a part of the text I have to rearrange all the other lines to make sure that they fit in the cell.

If any of this is unclear I can post an example pdf.

Many thanks.

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp close date 2017-03-21 12:59:56.984954

Sort by » oldest newest most voted

Hi

Have you tried FormatCellsAlignment tab▸PropertiesWrap text automatically ?

Regards

more

That's just what I'm after, cheers. Could someone please weigh in on the border adjustment part?:

"Also if possible I would like to be able to set the width of borders on the inside of the cell, meaning that when the line of text encroaches upon the border of the cell, a new line is started automatically".

( 2017-03-15 10:37:49 +0200 )edit
1

See Borders tab (same dialog)▸Spacing to contents

( 2017-03-15 11:57:45 +0200 )edit

Excellent, right on the money as always, Pierre!

( 2017-03-21 12:59:14 +0200 )edit