V
Vish
I need to create spreadsheets where the width of the same column needs to
change for different rows. How do I do it?
Thanks
change for different rows. How do I do it?
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
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
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
B
big-bob
Trust me, you cannot do that. Why not set the column width to the widest
amount that you need, and then both the smaller entries and the larger
entries will fit into the same column.
amount that you need, and then both the smaller entries and the larger
entries will fit into the same column.
D
Dallman Ross
Biff said: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 [. . . .]
One other possibility that might be useful to the OP is to use
custom formatting to fake differing column widths. E.g.,
pad numbers on the right for some of the cells.
-dman-
=========================================
S
spocky
Biff said: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
S
spocky
It may help if you could advise what you are trying to achieve?
V
Vish
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
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
B
big-bob
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.
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.
V
Vish
No No. That was just an example. I do not have data exactly like 3s and 4s. I
just have data ranges that I need to put one below the other, but the column
widths are different for each range. If I increase the width of the column to
the widest in one range, I will be wasting the space in the other range.
just have data ranges that I need to put one below the other, but the column
widths are different for each range. If I increase the width of the column to
the widest in one range, I will be wasting the space in the other range.
B
big-bob
my figures were just an example, too. what do you mean by "wasting" the
space? are you trying to write a program where space is super important? what
is your experience level? am I talking with a novice or a real expert (20
year user)? could you give a better example, or explain with lots more detail
the exact requirements?
space? are you trying to write a program where space is super important? what
is your experience level? am I talking with a novice or a real expert (20
year user)? could you give a better example, or explain with lots more detail
the exact requirements?