ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formating columns (https://www.excelbanter.com/excel-discussion-misc-queries/3448-formating-columns.html)

dbrumit

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

Bernard Liengme

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




Gregg Riemer

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


dbrumit

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


dbrumit

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