ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to force a wrap text function when the cell is big enough to p (https://www.excelbanter.com/excel-discussion-misc-queries/21794-how-force-wrap-text-function-when-cell-big-enough-p.html)

Jason Bathon

How to force a wrap text function when the cell is big enough to p
 
HOw do I get a cell to force wrap text when the cell is big enough to have it
all on one line, but I want it on 2 or more with out using another cell.

Ron Coderre

At the point in the cell's text where you want it to "break", hold down the
[Alt] key and press [enter] . That will create an end of line character and
cause the text to wrap.

I hope that helps.

Regards,
Ron



All times are GMT +1. The time now is 09:14 PM.

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