adding various numbers to value of one cell

  • Thread starter Thread starter Don Guillett
  • Start date Start date
D

Don Guillett

one way>copy c1>select the cells to goto>edit>pastespecial>add
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Add ^ to a row of cells containing letters 3
Copy columns and paste with blank column between 5
reffering another cell value which contains RAND() 0
Enter various number of blank lines in cells 2
MACRO RUN random percentage and copy of column values 1
UnSelect the copied to range after copy... 4
Eliminate blanks while copy row and transpose 11
Copy row info but not in normal column sequence 6

Back
Top