How to use same cell as reference?

[Guest]

I hope I can explain this clearly...

What I want is this:

When I type a formula into a cell, and then drag the formula to subsuquent
cells, I want a particular cell reference to remain unchanged rather than
auto enumerating.

Example:

I type this formula into a cell =a2/a1
Normally if I were to drag the formula down the column it would auto
enumerate as such =a3/a2, =a4/a3, etc.

What I would like to do is have the 'a1' reference remain the same as I drag
the formula down the column, like so =a3/a1, =a4/a1, etc.

I hope this is clear, thanks for your time.

 

[Niek Otten]

=a2/$A$1

easiest to achieve by pressing F4 while the cursor is in or near A1

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Jan Karel Pieterse]

Hi Brian,

When I type a formula into a cell, and then drag the formula to subsuquent
cells, I want a particular cell reference to remain unchanged rather than
auto enumerating.

Place a dollar sign before the part you need to stay put:

$A1 forces the A to remain, but the row adjusts
A$1 forces the row to stay, but column will adjust
$A$1 Fixes both.

Toggle between these in the formula bar by clicking in an address and hitting
F4 repeatedly.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Guest]

Thanks much, works like a charm.

EXCEL IS FUN!