Thread: How do I copy a formula with the cell increasing by increments?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jaxboo Jaxboo is offline
external usenet poster
  
Posts: 4
Default How do I copy a formula with the cell increasing by increments?
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.
Reply With QuoteReply With Quote