Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change number of columns mid page?
I would like to use a specific number of columns of varying widths at the top
of a page then, part way down the page, change to a different number of columns at different widths and use data from cells in each group for calculations in either group. Is this possible? |
#2
|
|||
|
|||
Width is a property of the column.
Cannot be changed in mid-page. Explain what you would like to see/do. Perhaps there are work-arounds. One table in columns A through G and another table in columns H through P or whatever. Two separate sheets with a table on each, although calculations across sheets become more unwieldy. Calculations are not dependent upon column width but rather cell content so your calcs could be done in any case. Gord Dibben Excel MVP On Mon, 22 Nov 2004 11:35:08 -0800, "Bluemax" wrote: I would like to use a specific number of columns of varying widths at the top of a page then, part way down the page, change to a different number of columns at different widths and use data from cells in each group for calculations in either group. Is this possible? |
#3
|
|||
|
|||
Thanks Gord. I appreciate your inputs. What I'm trying to do is to log in
information which requires four columns and about 1/2 page. I then want to accumulate data, which requires six columns, in the bottom half of the page. Xcel will do some calculations and change the information in the top half. The columns in the bottom half will have an acculmation of dat over a period of time then be replaced one row or a few cells at a time continuously updating the information in the top half of the sheet. Any further thoughts? Bluemax "Gord Dibben" wrote: Width is a property of the column. Cannot be changed in mid-page. Explain what you would like to see/do. Perhaps there are work-arounds. One table in columns A through G and another table in columns H through P or whatever. Two separate sheets with a table on each, although calculations across sheets become more unwieldy. Calculations are not dependent upon column width but rather cell content so your calcs could be done in any case. Gord Dibben Excel MVP On Mon, 22 Nov 2004 11:35:08 -0800, "Bluemax" wrote: I would like to use a specific number of columns of varying widths at the top of a page then, part way down the page, change to a different number of columns at different widths and use data from cells in each group for calculations in either group. Is this possible? |
#4
|
|||
|
|||
To change the information in the top half I would assume you need formulas in
these cells. Formulas that derive their results from data in the six columns below. If you do not use formulas you would need VBA code to move data from the bottom half to top half. Where does you bottom half accumulation of data come from? Manually entered? External feed? A few more details would be nice. Gord On Mon, 22 Nov 2004 19:29:02 -0800, "Bluemax" wrote: Thanks Gord. I appreciate your inputs. What I'm trying to do is to log in information which requires four columns and about 1/2 page. I then want to accumulate data, which requires six columns, in the bottom half of the page. Xcel will do some calculations and change the information in the top half. The columns in the bottom half will have an acculmation of dat over a period of time then be replaced one row or a few cells at a time continuously updating the information in the top half of the sheet. Any further thoughts? Bluemax "Gord Dibben" wrote: Width is a property of the column. Cannot be changed in mid-page. Explain what you would like to see/do. Perhaps there are work-arounds. One table in columns A through G and another table in columns H through P or whatever. Two separate sheets with a table on each, although calculations across sheets become more unwieldy. Calculations are not dependent upon column width but rather cell content so your calcs could be done in any case. Gord Dibben Excel MVP On Mon, 22 Nov 2004 11:35:08 -0800, "Bluemax" wrote: I would like to use a specific number of columns of varying widths at the top of a page then, part way down the page, change to a different number of columns at different widths and use data from cells in each group for calculations in either group. Is this possible? |
#5
|
|||
|
|||
Thanks again Gord. Data in bottom section is manually entered. Formulas in
both top and bottom sections use the data for calculations. Maybe I just use six columns all the way and let it look wierd? "Gord Dibben" wrote: To change the information in the top half I would assume you need formulas in these cells. Formulas that derive their results from data in the six columns below. If you do not use formulas you would need VBA code to move data from the bottom half to top half. Where does you bottom half accumulation of data come from? Manually entered? External feed? A few more details would be nice. Gord On Mon, 22 Nov 2004 19:29:02 -0800, "Bluemax" wrote: Thanks Gord. I appreciate your inputs. What I'm trying to do is to log in information which requires four columns and about 1/2 page. I then want to accumulate data, which requires six columns, in the bottom half of the page. Xcel will do some calculations and change the information in the top half. The columns in the bottom half will have an acculmation of dat over a period of time then be replaced one row or a few cells at a time continuously updating the information in the top half of the sheet. Any further thoughts? Bluemax "Gord Dibben" wrote: Width is a property of the column. Cannot be changed in mid-page. Explain what you would like to see/do. Perhaps there are work-arounds. One table in columns A through G and another table in columns H through P or whatever. Two separate sheets with a table on each, although calculations across sheets become more unwieldy. Calculations are not dependent upon column width but rather cell content so your calcs could be done in any case. Gord Dibben Excel MVP On Mon, 22 Nov 2004 11:35:08 -0800, "Bluemax" wrote: I would like to use a specific number of columns of varying widths at the top of a page then, part way down the page, change to a different number of columns at different widths and use data from cells in each group for calculations in either group. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I WANT TO SET PRINT RANGE TO NUMBER OF COLUMNS | Setting up and Configuration of Excel | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) | |||
insert a page number into a cell? | Excel Worksheet Functions | |||
EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions |