|  | Formatting Question | | |
| | | JimS |  |
|  Posted: Sun Aug 31, 2008 9:54 pm Post subject: Formatting Question |  |
I have a table on the top off my spreadsheet that calculates data..
Underneatht the table is the data entry part of the spreadsheet.
Is it possible to make the columns underneath the table a different
width than the columns directly above it in the table? |
| |
| | | smartin | |
| | Posted: Sun Aug 31, 2008 10:30 pm Post subject: Re: Formatting Question | |
JimS wrote:
| Quote: | I have a table on the top off my spreadsheet that calculates data..
Underneatht the table is the data entry part of the spreadsheet.
Is it possible to make the columns underneath the table a different
width than the columns directly above it in the table?
|
JimS,
You can't make a column (or row) have different measurements in
different places in a worksheet. I hesitate to mention combining cells
might be an option, because it is a poor one. Much better is to keep the
data entry area and the analysis area in separate worksheets (tabs). |
| |
| | | JimS | |
| | Posted: Mon Sep 01, 2008 12:01 am Post subject: Re: Formatting Question | |
| Quote: | Much better is to keep the
data entry area and the analysis area in separate worksheets (tabs).
|
About this. I've been doing some seraching and I can't find an easy
way (without using macros) to copy my table from one sheet and have it
appear exactly as it is in another sheet. (I've even tried using ASAP
utilities.)
I want it to work so that when I enter data on the main sheet it will
automatically update the table in the new sheet.
Does anyone know of a tutorial I can read about doing things like
this?
Thanks |
| |
| | | smartin | |
| | Posted: Mon Sep 01, 2008 12:21 am Post subject: Re: Formatting Question | |
| |  | |
JimS wrote:
| Quote: | Much better is to keep the
data entry area and the analysis area in separate worksheets (tabs).
About this. I've been doing some seraching and I can't find an easy
way (without using macros) to copy my table from one sheet and have it
appear exactly as it is in another sheet. (I've even tried using ASAP
utilities.)
I want it to work so that when I enter data on the main sheet it will
automatically update the table in the new sheet.
Does anyone know of a tutorial I can read about doing things like
this?
Thanks
|
Hi again JimS,
To fix the position you are in now you can just select and "cut" the
data entry rows, and "paste" them in another worksheet. The formulae you
have in the analysis area should follow the change automatically, and
the formatting of the data area you cut and paste should also follow.
If you want to set up new worksheets in this manner, just plan it out
ahead of time. Place data in one worksheet, do analysis (summaries,
etc.) in another. |
| |
| | | Harlan Grove | |
| | Posted: Mon Sep 01, 2008 12:37 am Post subject: Re: Formatting Question | |
JimS <jim...@msn.com> wrote...
| Quote: | I have a table on the top off my spreadsheet that calculates data..
Underneatht the table is the data entry part of the spreadsheet.
Is it possible to make the columns underneath the table a different
width than the columns directly above it in the table?
|
No.
You could set the standard column width to 2, 3 or 4 then merge cells
across different numbers of columns to achieve the appearance of
different column widths, but working with data in merged cells is far
more trouble than it's worth. |
| |
| | | JimS | |
| | Posted: Mon Sep 01, 2008 4:33 am Post subject: Re: Formatting Question | |
| | | |
You're right that works, but why won't it let me "copy" and paste the
table into the new worksheet?
On Sun, 31 Aug 2008 22:21:02 -0400, smartin <smartin108@gmail.com>
wrote:
| Quote: | JimS wrote:
Much better is to keep the
data entry area and the analysis area in separate worksheets (tabs).
About this. I've been doing some seraching and I can't find an easy
way (without using macros) to copy my table from one sheet and have it
appear exactly as it is in another sheet. (I've even tried using ASAP
utilities.)
I want it to work so that when I enter data on the main sheet it will
automatically update the table in the new sheet.
Does anyone know of a tutorial I can read about doing things like
this?
Thanks
Hi again JimS,
To fix the position you are in now you can just select and "cut" the
data entry rows, and "paste" them in another worksheet. The formulae you
have in the analysis area should follow the change automatically, and
the formatting of the data area you cut and paste should also follow.
If you want to set up new worksheets in this manner, just plan it out
ahead of time. Place data in one worksheet, do analysis (summaries,
etc.) in another. |
|
| |
| | | smartin | |
| | Posted: Mon Sep 01, 2008 4:04 pm Post subject: Re: Formatting Question | |
| | | |
When you use copy instead of cut, formulas that refer to the old range
will not change.
JimS wrote:
| Quote: | You're right that works, but why won't it let me "copy" and paste the
table into the new worksheet?
On Sun, 31 Aug 2008 22:21:02 -0400, smartin <smartin108@gmail.com
wrote:
JimS wrote:
Much better is to keep the
data entry area and the analysis area in separate worksheets (tabs).
About this. I've been doing some seraching and I can't find an easy
way (without using macros) to copy my table from one sheet and have it
appear exactly as it is in another sheet. (I've even tried using ASAP
utilities.)
I want it to work so that when I enter data on the main sheet it will
automatically update the table in the new sheet.
Does anyone know of a tutorial I can read about doing things like
this?
Thanks
Hi again JimS,
To fix the position you are in now you can just select and "cut" the
data entry rows, and "paste" them in another worksheet. The formulae you
have in the analysis area should follow the change automatically, and
the formatting of the data area you cut and paste should also follow.
If you want to set up new worksheets in this manner, just plan it out
ahead of time. Place data in one worksheet, do analysis (summaries,
etc.) in another.
|
|
| |
| | | Shane Devenshire | |
| | Posted: Tue Sep 02, 2008 5:19 am Post subject: Re: Formatting Question | |
Hi Jim,
I know this won't help, but I saw a spreadsheet at Apple that would allow
you to do this. Of course it was a Mac product, not Excel.
Cheers,
Shane
"JimS" <jimx22@msn.com> wrote in message
news:jlbmb450h7vgrn03ao70k8norijetqn2u4@4ax.com...
| Quote: | I have a table on the top off my spreadsheet that calculates data..
Underneatht the table is the data entry part of the spreadsheet.
Is it possible to make the columns underneath the table a different
width than the columns directly above it in the table? |
|
| |
| | | Harlan Grove | |
| | Posted: Tue Sep 02, 2008 5:33 pm Post subject: Re: Formatting Question | |
"Shane Devenshire" <shanedevensh...@sbcglobal.net> wrote...
| Quote: | I know this won't help, but I saw a spreadsheet at Apple that would allow
you to do this. Of course it was a Mac product, not Excel.
.... |
So what Apple-specific spreadsheet product was it? Or do you enjoy
nearly off-topic coyness? |
| |
|
|
