Appleworks Spreadsheet Questions

Discussion in 'Mac Help/Tips' started by King Cobra, Sep 13, 2002.

  1. King Cobra macrumors 603

    Mar 2, 2002
    I don't have Microsoft Orfice v. X and I plan to spend $400 (or whatever it is) when Appleworks can do a lot of what Excel can do.

    But I can't seem to find out how to do two things:

    (1) Selecting Column A and Column C, w/o Column B,
    (2) Selecting Column C and Row 2 (I think this is done similar to #1)
    (3) Dragging forumlas (ex.: =$B$4+0.5*C4) down through a column

    For those confused with #3, remember that in Excel, there is sometimes a little box at the lower right corner of the cell, which can be dragged down to transfer the formulas, or whatever. I'm stuck using the option-Click, but that only does a selected number of cells at a time.

    I searched the Appleworks Help and the Forums to see if the specific topic was brought up earlier, but I can't find anything directly and accurately relating to what I need help with.
  2. GeeYouEye macrumors 68000


    Dec 9, 2001
    State of Denial
    Don't Bother with AW Spreadsheet

    I don't know about those particular issues, but AW is limited to something like 86 rows. For that reason alone, sorry as I am to say it, Excel is the superior product.
  3. King Cobra thread starter macrumors 603

    Mar 2, 2002

Share This Page