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.

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.

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

Another note, type =A1 in a cell, then click in the formula bar and hit F4
four times and notice how ther references change.

HTH
Regards,
Howard

"excel rookie" <excel [email protected]> wrote in message
news:[email protected]...
> 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.