ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I change the width of some cells but not others? (https://www.excelbanter.com/excel-worksheet-functions/12982-how-do-i-change-width-some-cells-but-not-others.html)

MikeR

How do I change the width of some cells but not others?
 


Roger Govier

Hi Mike

You can only change the width of a whole column.
However, you can use Format=Cells=Alignment=Merge to give the appearance
of a cell having the width of the two cells beneath it.

--
Regards
Roger Govier
"MikeR" wrote in message
...




Bob Phillips

or (better), use CellsFormatAlignment and pick Center across selection
from the Horizontal dropdown (merge cells are problematical)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Roger Govier" wrote in message
...
Hi Mike

You can only change the width of a whole column.
However, you can use Format=Cells=Alignment=Merge to give the

appearance
of a cell having the width of the two cells beneath it.

--
Regards
Roger Govier
"MikeR" wrote in message
...







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

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