View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Can I have different column widths below each other

Hi

I'm afraid you can't.
A column width is the same for the entirety of the whole column.
You can give the "appearance" of part of a column being wider by one of
two methods
Merge cells - as you have already done, but beware because merge cells
has a nasty habit of "biting" you when you want to do other things.

Or
Mark a range of cells, FormatCellsAlignmentHorizontalCentre across
Selection.

--
Regards

Roger Govier


"Dizzy Des" wrote in message
...
I want to have different column widths below each other on the same
worksheet, I have tried highlighting the block of columns I want to
change &
specifying the different width but it changes all the columns above &
below
the columns I want to change. Some of the columns I want to change are
made
up by merging cells to make a wider cell.