Cell Alias??

[Epoh Rio]

Is there a way that I can use one cell as a quotient for a formula in a
column without editing the formula each time?

Example:

A12= 1.04

C15 =A15-B1
C16=A16-B1
C17=A17-B1
C18=A18-B1

Auto Fill will start filling B1 thru Bx

Can I give B1 an alias that I can refer to in my formula that Autofill
wont try to correct?

 

[Gord Dibben]

Change the formula in C15 to =A15-$B$1 then copy down.

The $ signs anchor B1

For more on this see help on absolute and relative cell refences.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Incomplete answer..........

You could give B1 a name(alias)under Insert>Name>Define.

The your formula would look like =A15-qwerty

qwerty is the name you gave to B1


Gord

 

[Epoh Rio]

Thanks Gord!!