Text Wrap

collinsc

Board Regular
Joined
Sep 13, 2006
Messages
240
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
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Hi There

Try selecting the whole document (Ctrl+a)

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

HTH


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

Format>>Column>>Autofit Selection

Would be a better option
 
Upvote 0
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).
 
Upvote 0
Then perhaps

Format>>Row>>Autofit

Would be the answer

KR


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

cheers for the posts
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,267
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top