ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   WRAP a text line over several columns without merging cells (https://www.excelbanter.com/excel-worksheet-functions/18677-wrap-text-line-over-several-columns-without-merging-cells.html)

Conrad S

WRAP a text line over several columns without merging cells
 
This would be a general improvement to allow wrapping text over several
columns without the need to merge these cells. merging has limitations.

RagDyer

Have you tried "Center Across Selection"?

Select the range, then:

<Format <Cells <Alignment tab,
Expand the "Horizontal" window, and click on the last option
"Center Across Selection".
You could also click on "Wrap Text" if you wish.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Conrad S" <Conrad wrote in message
...
This would be a general improvement to allow wrapping text over several
columns without the need to merge these cells. merging has limitations.



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

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