Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I create multiple column width in the same column in excel
I need to create spreadsheets where the width of the same column needs to
change for different rows. How do I do it? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I create multiple column width in the same column in excel
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I create multiple column width in the same column in excel
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. -- big-bob "Vish" wrote: I need to create spreadsheets where the width of the same column needs to change for different rows. How do I do it? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I create multiple column width in the same column in excel
In , Biff
spake thusly: 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- ========================================= In , Biff spake thusly: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I create multiple column width in the same column in excel
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I create multiple column width in the same column in excel
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I create multiple column width in the same column in ex
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I create multiple column width in the same column in ex
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I create multiple column width in the same column in ex
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. "big-bob" wrote: 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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I create multiple column width in the same column in ex
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? -- big-bob "Vish" wrote: 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. "big-bob" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Create a stacked, clustered column layout in excel? | Charts and Charting in Excel | |||
Can I make column width and row height equal (a grid) in Excel? | Excel Discussion (Misc queries) | |||
How do I create a column label in Excel? | New Users to Excel | |||
Create an if-then formula in Excel to limit column total? | Excel Discussion (Misc queries) |