Click and drag a formula

R

robdanjoe

How do i click and drag a formula while keeping one of the values constant?

ie:
A1*C1
A1*C2
A1*C3

etc,
 
S

Sheeloo

Just put a $ before the letter and/or number you don't want to change.
$A1*C1
will keep A constant
A$1*C1
will keep 1 constant and so on.

Remember that normally letter changes if your drag to right and number
changes when you drag down...

So if you are dragging down
A$1 is same as $A$1 but different when dragged right
 

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

How do i keep it like this, A1:c1/b1, A2:c2/b1, A3: c3/b1? 4
Math Functions Not Working Properly 3
conditional formating - dragging a cond. format over an entire col 3
Excel functions 0
How do I increment the row and column of a cell in a formula? 2
Is there a formula that can do this? 3
Copy Excel functions formula and auto refresh refresh 3
drag a formula downa column keeping one value the same? 2

Top