HOW DO I CHANGE THE WIDTH OF ONLY A FEW CELLS
i am trying to change the width of cells a18 through a42 on my worksheet but
when i try the entire worksheet changes to that cell width how do i change only a part of my worksheet to creat what i want |
No can do but you can merge cells to make wider or merge other cells to make
them wider. -- Don Guillett SalesAid Software "english" wrote in message ... i am trying to change the width of cells a18 through a42 on my worksheet but when i try the entire worksheet changes to that cell width how do i change only a part of my worksheet to creat what i want |
Width is a property of the column and cannot be changed within that column.
Workarounds..... 1. Select A18:B42 and FormatCellsAlignmentHorizontalCenter Across Selection. 2. Use a text box to hold your data. 3. Merge A18 and B18 then copy that formatting down to row 42. NOTE: merging cells can cause no end of problems with sorting, filtering, copying, pasting and other functions I can't think of right now. Gord Dibben Excel MVP On Mon, 21 Mar 2005 08:55:01 -0800, "english" wrote: i am trying to change the width of cells a18 through a42 on my worksheet but when i try the entire worksheet changes to that cell width how do i change only a part of my worksheet to creat what i want |
All times are GMT +1. The time now is 09:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com