How do I keep one cell constant in a formula even when copying
 

I'm doing a spreadsheet that refers back to a specific cell. My problem is
that when I copy the original formula it moves away from that specific cell.
I need to create a formula that will keep a specific cell in place and allow
the rest of the formula change as I copy it elsewhere.

How do I keep one cell constant in a formula even when copying
 

Hi!!
excel rookie

How r u
Friend, its quite easy

just prefix $ sign at the row or colum number which u want to fix
eg

u hv enterd farmulae in column A1 as

=(B1+C1)
if u want to fix B1 just freeze it as

$B$1
its quit simple

Abhishek kedia



"excel rookie" wrote:

I'm doing a spreadsheet that refers back to a specific cell. My problem is
that when I copy the original formula it moves away from that specific cell.
I need to create a formula that will keep a specific cell in place and allow
the rest of the formula change as I copy it elsewhere.

How do I keep one cell constant in a formula even when copying
 

Hi Rookie,

Just use the $ sign in your formula

$A1 - holds A and allows 1 to change
A$1 - holds 1 and allows A to change
$A$1 - holds both