View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default IS IT POSSIBLE TO HAVE A1.J15 COLUMN WIDTH AS 10 AND A15.J30 COLUMNWIDTH TO 15?

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



CAPTGNVR wrote:

On Feb 6, 5:15 am, wrote:
On Feb 5, 1:10 pm, "CAPTGNVR" wrote:

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.


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


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.


--

Dave Peterson