ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   double spacing a column (https://www.excelbanter.com/excel-discussion-misc-queries/14658-double-spacing-column.html)

bce

double spacing a column
 
I need to make a column narrow so that the title is on 2 lines

Peo Sjoblom

You can press alt + enter to get a new line (not new row) and
still use one cell

--

Regards,

Peo Sjoblom

"bce" wrote in message
...
I need to make a column narrow so that the title is on 2 lines




CyberTaz

You can also go to FormatCellsAlignment and check the box for Wrap text.
Column width will control wrapping, whereas Peo's suggestion forces a line
break even in wider columns where wrap would not occur even if turned on. |:)

"bce" wrote:

I need to make a column narrow so that the title is on 2 lines



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

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