HOW TO HAVE DIFFERENT COLUMN WIDTH FOR THE SAME COLUMN
 

DEAR ALL
This I posted previously and did not receive good response bcos of
poor explanation. Simply said I have say first 20 rows of column b for
cargo figures and next 20 rows of column b for description and
explanations. Can anyone help me in how to get say b1.b20 column
width to 10 and b21.b40 column width as 25. I got advice to merge
cells etc which i cant do bcos the adjacent columns i need for
different numbers. So pls advice how to have two different widths for
the same column.

HOW TO HAVE DIFFERENT COLUMN WIDTH FOR THE SAME COLUMN
 

As I recall, you were told that it can NOT be done.

--
Don Guillett
SalesAid Software

"CAPTGNVR" wrote in message
oups.com...
DEAR ALL
This I posted previously and did not receive good response bcos of
poor explanation. Simply said I have say first 20 rows of column b for
cargo figures and next 20 rows of column b for description and
explanations. Can anyone help me in how to get say b1.b20 column
width to 10 and b21.b40 column width as 25. I got advice to merge
cells etc which i cant do bcos the adjacent columns i need for
different numbers. So pls advice how to have two different widths for
the same column.

HOW TO HAVE DIFFERENT COLUMN WIDTH FOR THE SAME COLUMN
 

CAPTGNVR wrote:
DEAR ALL
This I posted previously and did not receive good response bcos of
poor explanation. Simply said I have say first 20 rows of column b for
cargo figures and next 20 rows of column b for description and
explanations. Can anyone help me in how to get say b1.b20 column
width to 10 and b21.b40 column width as 25. I got advice to merge
cells etc which i cant do bcos the adjacent columns i need for
different numbers. So pls advice how to have two different widths for
the same column.

Since you don't want to use the cell merge method, I'm afraid you can't.

you will have to redesign your spreadsheet to get the result you want

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1

HOW TO HAVE DIFFERENT COLUMN WIDTH FOR THE SAME COLUMN
 

On Feb 12, 11:53 pm, "Francois via OfficeKB.com" <u18959@uwe wrote:
CAPTGNVR wrote:
DEAR ALL
This I posted previously and did not receive good response bcos of
poor explanation. Simply said I have say first 20 rows of column b for
cargo figures and next 20 rows of column b for description and
explanations. Can anyone help me in how to get say b1.b20 column
width to 10 and b21.b40 column width as 25. I got advice to merge
cells etc which i cant do bcos the adjacent columns i need for
different numbers. So pls advice how to have two different widths for
the same column.

Since you don't want to use the cell merge method, I'm afraid you can't.

you will have to redesign your spreadsheet to get the result you want

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200702/1

OK AGREED MR.DON AND FRANCOIS
Now I will consider this thread as closed. Thnks n sorry for posting
this again.

HOW TO HAVE DIFFERENT COLUMN WIDTH FOR THE SAME COLUMN
 

This I posted previously and did not receive good response bcos of
poor explanation. Simply said I have say first 20 rows of column b for
cargo figures and next 20 rows of column b for description and
explanations. Can anyone help me in how to get say b1.b20 column
width to 10 and b21.b40 column width as 25. I got advice to merge
cells etc which i cant do bcos the adjacent columns i need for
different numbers. So pls advice how to have two different widths for
the same column.


If you want the second 20 rows just for reference, put them in a
different worksheet with the columns the desired width. And then use
the Camera tool to show a picture of that range under the first 20 rows.

That's how I get things to print on the same page with different column
widths.