Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |