![]() |
Formating columns
Hi, I need help changing the column widths.
Column A has a width setting of 15 for rows 1 - 30 but I want rows 31 - 35 to have a width setting of 5 Thank you |
Columns cannot have different width in different row.
If you want to make a table use Word (or wood!) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "dbrumit" wrote in message ... Hi, I need help changing the column widths. Column A has a width setting of 15 for rows 1 - 30 but I want rows 31 - 35 to have a width setting of 5 Thank you |
It's cumbersome, but you can try the following: Set the width for Column A at
5 and the width for Column B at 25. Then merge cells A1:B1 by highlighting these two cells and clicking on Format - Cells - Alignment and then checking the box next to Merge cells Repeat for cells A2:B2, A3:B3...A30:B30 "dbrumit" wrote: Hi, I need help changing the column widths. Column A has a width setting of 15 for rows 1 - 30 but I want rows 31 - 35 to have a width setting of 5 Thank you |
Thanks for your help
"Gregg Riemer" wrote: It's cumbersome, but you can try the following: Set the width for Column A at 5 and the width for Column B at 25. Then merge cells A1:B1 by highlighting these two cells and clicking on Format - Cells - Alignment and then checking the box next to Merge cells Repeat for cells A2:B2, A3:B3...A30:B30 "dbrumit" wrote: Hi, I need help changing the column widths. Column A has a width setting of 15 for rows 1 - 30 but I want rows 31 - 35 to have a width setting of 5 Thank you |
Thanks
"Bernard Liengme" wrote: Columns cannot have different width in different row. If you want to make a table use Word (or wood!) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "dbrumit" wrote in message ... Hi, I need help changing the column widths. Column A has a width setting of 15 for rows 1 - 30 but I want rows 31 - 35 to have a width setting of 5 Thank you |
All times are GMT +1. The time now is 04:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com