HOW TO HAVE DIFFERENT COLUMN WIDTH FOR THE SAME COLUMN

C

CAPTGNVR

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.
 
F

Francois via OfficeKB.com

CAPTGNVR said:
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.
Click to expand...

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
 
C

CAPTGNVR

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
Click to expand...

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

Andy

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.
Click to expand...


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IS IT POSSIBLE TO HAVE A1.J15 COLUMN WIDTH AS 10 AND A15.J30 COLUMN WIDTH TO 15? 5
modifying cell width within same column, but on different rows 2
Worksheet Column Widths Different For Different Users 2
How do set different widths for the same column? 5
how do I set different column widths for same column in one excell 1
how do I create multiple column width in the same column in excel 9
can we make a column width different sizes on the same page? 2
What defines the column width intervals? 1

Top