#1   Report Post  
dbrumit
 
Posts: n/a
Default 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   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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   Report Post  
Gregg Riemer
 
Posts: n/a
Default

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   Report Post  
dbrumit
 
Posts: n/a
Default

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   Report Post  
dbrumit
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM
Counting the Contents of Two Columns Molochi Excel Discussion (Misc queries) 6 December 22nd 04 08:13 PM
Pivot Table Creating New Columns that Subtract Two Existing Columns den4673 Excel Discussion (Misc queries) 3 December 17th 04 01:31 PM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 05:40 PM
How can I find the common names in two columns of names? hako Excel Discussion (Misc queries) 2 December 8th 04 01:59 AM


All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"