Thread: IS IT POSSIBLE TO HAVE A1.J15 COLUMN WIDTH AS 10 AND A15.J30 COLUMN WIDTH TO 15?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default IS IT POSSIBLE TO HAVE A1.J15 COLUMN WIDTH AS 10 AND A15.J30 COLUMN WIDTH TO 15?
Column widths and Row heights are properties of the entire Column and Row.

Have a look at FormatCellsAlignmentHorizontalCenter across Selection.

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


Gord Dibben MS Excel MVP

On 5 Feb 2007 13:10:16 -0800, "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.

Reply With QuoteReply With Quote