Formatting Question

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

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 said:
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?
Click to expand...

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).
Click to expand...

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
 
You're right that works, but why won't it let me "copy" and paste the
table into the new worksheet?
 
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
 
Shane Devenshire said:
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.
Click to expand...
....

So what Apple-specific spreadsheet product was it? Or do you enjoy
nearly off-topic coyness?
 
Back
Top