iWork '09/Numbers question

Discussion in 'Mac Apps and Mac App Store' started by mac000, Oct 19, 2009.

Most Liked Posts
  1. mac000, Oct 19, 2009

    mac000 macrumors 6502a

    Joined:
    Sep 6, 2005
    #1
    Hi guys - I'm trying to use numbers to calculate some data and there is a lot of data so I'm trying to use a SUM formula to add up my rows. I'm trying to copy the SUM command down the column but I want Numbers to copy down the formula down Column H without me dragging the formula.

    I know in Excel I could drag the formula down a few cells then use the SHIFT and END key to copy the formula through the whole column, is there a way to do this in Numbers '09?
     
    share
    + Quote Reply
  2. Gav2k, Oct 19, 2009

    Gav2k macrumors G3

    Gav2k

    Joined:
    Jul 24, 2009
    #2
    Not at my mac at the mo but highlight the top number then use shift and down to highlight the row keepgoing till you get. To your total box then you can calculate the row.
     
    share
    + Quote Reply
  3. mysterytramp, Oct 20, 2009

    mysterytramp macrumors 65816

    mysterytramp

    Joined:
    Jul 17, 2008
    Location:
    Maryland
    #3
    It doesn't appear to be, and it appears Numbers could be a lot better in the navigation department. You should use the "Provide Numbers Feedback" command and suggest changes to Apple.

    mt
     
    share
    + Quote Reply
  4. PeggyD, Oct 20, 2009

    PeggyD macrumors 6502a

    Joined:
    Jan 9, 2007
    Location:
    Covington, WA, USA
    #4
    I didn't answer before because I wasn't very sure what you're asking. I'm still not, but I think I have an idea. You're looking for a way to "fill down." In my screenshot I have a number in each cell in column A & B & the formula to sum the two in column C. I only had to put the formula in cell C1 then click & drag the tiny circle in the lower right of the cell down to fill as many cells as I want. You can see by the formula list at the bottom of the picture that each one has summed the respective row.
     

    Attached Files:

    share
    + Quote Reply
  5. mac000, Oct 20, 2009

    mac000 thread starter macrumors 6502a

    Joined:
    Sep 6, 2005
    #5
    Thanks. Yeah I have a sheet with 500 rows so I wanted to auto fill that last column down 500 rows. Thanks for helping, if there is a shortcut someone please let me know.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page