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 wrote:
> 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 <jim...@msn.com> wrote...
>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.

>>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

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.

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.

When you use copy instead of cut, formulas that refer to the old range
will not change.

JimS wrote:
> 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.
>

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...
> 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?

"Shane Devenshire" <shanedevensh...@sbcglobal.net> wrote...
>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?