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.

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




wrote in message
...
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.

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

On Thu, 17 Jan 2008 20:31:07 GMT, wrote:

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.

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

" wrote:

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.