IS IT POSSIBLE TO HAVE A1.J15 COLUMN WIDTH AS 10 AND A15.J30 COLUMN WIDTH TO 15?

  • Thread starter Thread starter CAPTGNVR
  • Start date Start date
C

CAPTGNVR

DEAR ALL
FOR EXAMPLE - I have rows of inofrmation . a1.j15 I need column width
only 10 becos only numbers. From a15.j30 I need column width 25 or so
to enter description. Is it possible in Excel bcos if a column width
is selected it is for the entire sheet or is there a way.
 
DEAR ALL
FOR EXAMPLE - I have rows of inofrmation . a1.j15 I need column width
only 10 becos only numbers. From a15.j30 I need column width 25 or so
to enter description. Is it possible in Excel bcos if a column width
is selected it is for the entire sheet or is there a way.
Click to expand...

Yes, select the group of columns you want to change by clicking and
holding down, and dragging accross the column letters. Once they're
selected, drag one of the columns to the desired width - the others
will change too.

HTH
 
Yes, select the group of columns you want to change by clicking and
holding down, and dragging accross the column letters. Once they're
selected, drag one of the columns to the desired width - the others
will change too.

HTH
Click to expand...

Mr. Gromi-- I am sorry that my need was not well explained by me.
What i want to do is from row 1 to 10 i want the column width to 10
and from row 10 to 20 i want the column width to be 20. How to do
it. Hvr, thnks for ur quick repsonse. I will wait for ur reply for
this soon.
 
It's not possible to have multiple widths in the same column.

Your only option is to merge cells. If you select, say, A15 and B15 then
select the white box with the a and arrows on it (next to the dollar sign),
this would merge the 2 cells. But then, columns A and B would be atop your
description of column A. Hope that makes sense...
 
Column widths and Row heights are properties of the entire Column and Row.

Have a look at Format>Cells>Alignment>Horizontal>Center across Selection.

You can select A15:J30 and set to the above.


Gord Dibben MS Excel MVP
 
It's the width for the entire column.

You could fiddle around with merged cells and use more columns. But using
merged cells is more trouble than it's worth (in my opinion).
 

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

HOW TO HAVE DIFFERENT COLUMN WIDTH FOR THE SAME COLUMN 4
Multiple Range Lookup Possible??? (Expert Level Question?) 3
Cell/column auto adjusts width to longest text string 4
Is it possible to have different column widths in same column? 2
How to make row height and column width equal 5
Changing fixed width (column break) defaults when importing text 1
rows and columns on worksheet 1
Determine a cell's width and enter it in the cell 2

Back
Top