Boze

In B1 enter =A1+$C$1 and drag/copy down.

If you have data in column A, just double-click on the fill handle of B1 and
will copy down without dragging.

The A1 will increment but the $C$1 will remain absolute.


Gord Dibben MS Excel MVP

On Fri, 1 Jun 2007 12:25:15 -0700, "Boze" wrote:

I need to add different numbers in column A to the value in C1. (A1+C1,
A2+C1, A3+C1, etc). Is there an easy way to get Excel to do this without
having to manually input the formula in each cell?

Thanks