ExcelBanter

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

RobertLees

Text Wrap
 

Hi

Can I enter more text than will fit into the cell width I have set, and
cause the text to expand the cell vertically to accomodate this long
text?

Thanks
Robert


--
RobertLees
------------------------------------------------------------------------
RobertLees's Profile: http://www.excelforum.com/member.php...o&userid=26580
View this thread: http://www.excelforum.com/showthread...hreadid=398963


dominicb


Good morning RobertLees

You sure can. Make sure the cell you want to affect is the active
cell. Press ctrl + 1, select Alignment and check the wrap text box.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=398963



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

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