[G4] Appleworks/MS Excel

[Jamie Pruden]

Hi Anne,

AW 6 has both features.

To set colors of cells, you must show the toolbox (it's the little red 
toolbox at the bottom of the SS window). Select the cells you'd like to 
color and choose a color from the color palette.

To reference an external spreadsheet, you can enter a formula like:

=Budget.CWK!A2

The entry before the exclamation point is the name of the document 
being referenced and the rest is the cell being referenced. If a 
document name includes a space, put the name of the document in 
quotation marks:

=SUM("Planning Budget"!A2..A31)

There are VERY few things that I do with a spreadsheet that I cannot do 
with AppleWorks. It's not Excel, but it works well for what it does.

smiles,
Jamie


On Apr 8, 2004, at 9:04 AM, Anne Keller-Smith wrote:

> On Tuesday, April 6, 2004, at 11:23  PM, John Erdman wrote:
>
>> I have Appleworks 6 and MS-Office 98 for Mac.  My Appleworks can 
>> import Excel 98 files intact with all formulas correct and active. 
>> Now I must admit that these are pretty simple arithmetic spread 
>> sheets so caveat emptor if you are dealing with a very sophisticated 
>> Excel worksheet.  The trick is not export in Excel but using the 
>> built in import function in Appleworks.
>
> Thanks for your input. Does AW6 have cell background colors? I'm using 
> these quite a bit lately because they
> make my sheets easier to look at. Does AW6 also do worksheets, or not? 
> It would be nice to be able to do totals
> on a master sheet that would link to each monthly budget. Although I'm 
> not doing that now, and I can catch
> mistakes by reviewing each month's totals and transposing them to the 
> next month's sheet, although one might
> say this leads to more (human) errors in the long run.