Copying formulas

D

DQ1

Can't seem to find this tip, probably calling it the wrong name. Want
to copy a formula (x/y) from cell to cell, but keep the denominator (y)
pointed at the same cell each time.
 
G

GeorgeF

Put a dollar sign in front of the constituents of the fixed cell. For
example, in a simple fractional equation
=A2/$B$23
The contents of cell B23 will always be the divisor as the equation is
copied to other cells.
GeorgeF
 
D

David Hepner

Try this:
x/$y

You can also click on the formula and press the F4 key. Keek hitting F4 to
toggle through all options.
 
Top