Periodically when I'm cutting and pasting in Excel/OpenCalc, I need to keep one cell constant, and vary another cell.

| A | B | C | D | E | F |

1 | Constant | Value | Formula | EveryRow | ModFormula | |

2 | **5** | 1 | =A2+B2 | 5 | =D2+B2 | |

3 | | 2 | =A2+B3 | 5 | =D3+B3 |

4 | | 3 | =A2+B4 | 5 | =D4+B4 |

5 | | 4 | =A2+B5 | 5 | =D5+B5 |

So, in the above formula, I want to keep A2 constant, and use it in all the formulas in column C.

When I cut and past the formula in column C2, it automatically increments the cells for both columns A&B.

One possibility is to create a column D, and put my constant value in every cell.

Then I can cut and past my formula E2. But, that means creating a whole bunch of unnecessary cells.

However, is there a more elegant way to do it, so it automatically increments the cells in one column, but not the next?