Text Wrap

[collinsc]

Hi

I have a very large document. Each cell is set as ‘wrap text’ or should be…

Ive noticed that some aren’t wrapping. I have to highlight the row and then double click the row on the side rule. Then it wraps.

I want to be able to ensure ALL of the cells within the document are wrapped- how can I do this?

Thanks

 

[dave3009]

Hi There

Try selecting the whole document (Ctrl+a)

Then go to Format>>Cells>>Alignment>>Check Text Wrap

HTH


Dave

 

[Lewiy]

Is it actually that it's not wrapping, or just the the row height is not automatically adjusting to make the wrapped text visible?

 

[dave3009]

So perhaps

Format>>Column>>Autofit Selection

Would be a better option

 

[collinsc]

Cheers

neither of those worked.

it is : row height is not automatically adjusting to make the wrapped text visible

tried it on one- it elongated the cell- when i pulled the column width back in the text disappeared- i checked it was wrapped... and it was.
so i had to select the row and double clicked it.

maybe its one of those strange quirks. i prob should have set the whole page as 'text wrap' from the start- as ive been individually doing columns. (did not know at the start though thtat it would need wrapping).

 

[dave3009]

Then perhaps

Format>>Row>>Autofit

Would be the answer

KR


Dave

 

[collinsc]

nah- didnt really work- im gonna have to keep my eyes open and do it manually.

cheers for the posts

 

[dave3009]

I can't understand why

Your issue was that you had text that wasn't being shown due to row height, column width or cell size generally.

Do you want all cells to read on one line regardless of string length or do you want them to read on several rows within a cell depending on what you have set the column width to.

KR


Dave

 

[collinsc]

the latter.... i want them to read on several rows within a cell depending on what you have set the column width to.

which common sense would say your suggestion of Format>>Column>>Autofit Selection should work...

but it didnt... it extended the column

and the rows did likewise with rows