adding various numbers to value of one cell

  • Thread starter Thread starter Don Guillett
  • Start date Start date
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
 
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
 
Thank you both. Those worked great!

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
 
Back
Top