Simple. Set up 8 columns as follows: first column is 1 wide, next column is
3 wide, next column is 1 wide, next column is 3 wide, etc. Put the data that
is 3 wide into the 3 wide column. For the 4 wide data: highlight the adjacent
1 wide and 3 wide cells such that a black box forms around the two adjacent
cells. Then execute Format Cells Alignment and check the Merge Cells box
and hit ok. What was previously two cells 1 wide and 3 wide now becomes a
cell that is four. And, this won't effect the other data that is three wide!
If you need to accomodate negative numbers, or formatting with commas, then
you will need for the 8 columns to be a little wider, such as alternating 2
wide and 4 wide, or perhaps 2.5 wide and 4.5 wide. but you can experiemnt
with.
--
big-bob


"Vish" wrote:

I have two ranges of information one below the other. The column width needs
to be changed for it to work. Think of it as the top range with 4 columns of
3 cms and the bottom range with 3 columns of 4 cms each. Although the total
width of the range is the same, the columns do not match. I heard of the
picture function, where you bring the info from somewhere else and past is as
a picture. Is that an option? Is that the only option?

thanks

"spocky" wrote:

It may help if you could advise what you are trying to achieve?


Biff wrote:
You can't have different column widths within the same column. The entire
column must be the same width.

You could try merging 2 cells from adjacent columns but merging cells can
cause problems with some operations like sorting, filtering, etc. if you
haven't accounted for that in your design.

Biff

"Vish" wrote in message
...
I need to create spreadsheets where the width of the same column needs to
change for different rows. How do I do it?

Thanks