ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wrap Text (https://www.excelbanter.com/excel-discussion-misc-queries/67395-wrap-text.html)

Dee

Wrap Text
 
I have a spreadsheet that I want to apply "wrap text". When I highlight the
column and go to format, cells, alignment etc. to apply the wrap text, the
text does not wrap automatically, the text looks cut off and I have to go and
double click on the row to make it expand. Is there a way to do this all at
once. It's a fairly long spreadsheet.

Thanks in advance for your help.

Regards,

Dee

Dave Peterson

Wrap Text
 
You can select all the rows you need then just autofit the rowheight at once.

Select the range
format|row|autofit

Dee wrote:

I have a spreadsheet that I want to apply "wrap text". When I highlight the
column and go to format, cells, alignment etc. to apply the wrap text, the
text does not wrap automatically, the text looks cut off and I have to go and
double click on the row to make it expand. Is there a way to do this all at
once. It's a fairly long spreadsheet.

Thanks in advance for your help.

Regards,

Dee


--

Dave Peterson


All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com