Can I make 1 cell the SUM of other cells in the row, for whole column?

[ato_zee]

D581 has the formula =SUM(G581:X581)
and so on for other rows, done by Select
then Copy, then selecting many rows in
col D. Then Paste -> formulas.
This of course has to be repeated to
extend the same formula to apply to
more rows.
Can I just select Column D then
apply the formula once and it applies
to all rows of col D?
Excel 2007
The formula tab doesn't see to help.

 

[Peo Sjoblom]

Select as long as you want it to go, then press Ctrl + d

or drag the lower right corner of the formula cell and copy down


--


Regards,


Peo Sjoblom

 

[Gord Dibben]

Select D581 and hover the cursor over the lower right corner of the cell.

You will see a black cross appear.

Click on that cross and drag down as far as you wish.

The formula will increment to adjust G581:X581 to 582, 583, 584 etc.


Gord Dibben MS Excel MVP

 

[hjc]

Or try this:

- Select the last cell in column D that already contains the formula you
want to copy. You can easily reach that cell if you click on any cell in
column D, then press <End> followed by the Down Arrow (if you are above the
cell you want to get to), or the Up Arrow (if you are below it)
- Place the cursor over the lower right corner of the cell (the cursor
should change to a black cross)
- Double click.

This method will copy the formula in the selected cell as far down (in
column D) as the bottom of the block of cells in column C (or in column E if
column C is blank.) I don't know for sure whether this will work in your
case, since column D is the sum of columns G through X, and you don't say
whether there is anything in columns C or E (or if they happen to be a
different length than columns G through X), but it works very nicely when the
column containing the formula is adjacent to the block of data used in the
formulae!

I hope you find this useful -- I sure do, especially if I need to copy the
formula to thousands of rows, but not all the way to the bottom of the
spreadsheet, since it saves a lot of 'paging down' to select the range I want
to copy to.

Regards,
Hugh John