adding various numbers to value of one cell

B

Boze

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
 
G

Gord Dibben

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
 
B

Boze

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
 

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

VBA Coding Help for Beginner 0
How can the font and size of (all) citation numbers be altered? 1
Space at end of multi page list to accommodate new entries 1
Finding the proper style field and the numbered paragraph value within the style 0
Copy columns and paste with blank column between 5
Copy unformatted value of cell via macro 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Visio shape text disappears upon copy paste 1

Top