ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Left justify across cells with word-wrap without merge (https://www.excelbanter.com/excel-programming/293354-left-justify-across-cells-word-wrap-without-merge.html)

Sean Bartleet

Left justify across cells with word-wrap without merge
 
Hi,

Is it possible to left justify across several cells in a row with
word-wrap on, similar to the "centre across selection" justification
option. I know that you can achieve this by merging the cells. One of
the problems I have with merging the cells is that the row height does
not automatically adjust to accommodate the text. The other problems I
have with merge are too numerous to mention, suffice it to say that I
believe that this feature should be declared illegal or at the least
banished.

Is it possible to do this programmatically?

I am using Excel 2002

Any assistance will be appreciated.

Thanks

Sean Bartleet

Frank Kabel

Left justify across cells with word-wrap without merge
 
Hi Sean
AFAIK this is not possible

--
Regards
Frank Kabel
Frankfurt, Germany

Sean Bartleet wrote:
Hi,

Is it possible to left justify across several cells in a row with
word-wrap on, similar to the "centre across selection" justification
option. I know that you can achieve this by merging the cells. One of
the problems I have with merging the cells is that the row height

does
not automatically adjust to accommodate the text. The other problems

I
have with merge are too numerous to mention, suffice it to say that I
believe that this feature should be declared illegal or at the least
banished.

Is it possible to do this programmatically?

I am using Excel 2002

Any assistance will be appreciated.

Thanks

Sean Bartleet




All times are GMT +1. The time now is 11:22 AM.

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