Formating columns

[dbrumit]

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" <[email protected]> wrote in message
news:[email protected]...
> 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

[Rutgers_Excels]

Have you thought about merging the Column A & Column B cells for rows 1-30?

[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

[swatsp0p]

The last post has the right idea, however to speed up the process, once you have formatted cells A1:B1 as merged, with the cursor in A1, click on the Format Painter on the toolbar (the paintbrush), then click and drag A2:B30 and release. All rows will now be merged A:B

2nd option is to copy the merged cell (A1), highlight A2:B30, then Paste Special>Formats (Same result as above)

HTH

[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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>