Focing a cell to be used

N

NAUBryan

Is it possible to keep a cell used when you drag an equation to multiple cells?
1200*a1^(b1)
1200*a2^(b1)
..
..
..
1200*an^(b1)
the way it stand now, draging the equation leads to both cells roaming. I
want to fix one cell. The question is how.
 
B

bapeltzer

Use an absolute reference. Where you now have b1, use $b$1.
(There are also mixed references. $b1 would keep the column fixed as you
copy across; b$1 would keep the row fixed as you copy down).
 

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

Top