Just drag the cell down. Place your cursor on the little square in the right bottom corner of the cell, press and hold the left
mouse button, move the mouse to the last destination cell (still keeping the mouse button pressed) and once you're there, release
it.

You can also copy and paste via the menu; Excel will adjust the cell references automatically.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jaxboo" wrote in message ...
|I would like to take a simple Sum formula such as Sum(b1:b6) and copy it into
| the next cell in an increment so the next cell (below) will read sum(b7:b12)
|
| How would I do this? I have a large number of cells I will be doing this
| with and really do not want to have to go back and forth between worksheets
| to select the cells.