| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy a formula with the cell increasing by increments?
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Round formula up in $5. increments =+(M4*1.1)+M4 | Excel Worksheet Functions | |||
| Formula for Increasing a Cell Reference by a Given Number | Excel Worksheet Functions | |||
| How do I copy a formula with increasing worksheet numbers | Excel Discussion (Misc queries) | |||
| how can I copy dates, etc. without them automatically increasing | Excel Discussion (Misc queries) | |||
| How do I sum a formula and paste it in 7 cell increments? | Excel Discussion (Misc queries) | |||
Threaded Mode
