Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

mac000

macrumors 6502a
Original poster
Sep 6, 2005
679
0
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?
 
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.
 
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
 
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.
 

Attachments

  • Numbers_formula_fill.png
    Numbers_formula_fill.png
    163.9 KB · Views: 165
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.

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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.