Easy Copying of a Function Help Please

  • Thread starter Thread starter Homey
  • Start date Start date
H

Homey

I have a problem with copying a function to another 100 or so cells.

The function is something like =A2/B1. That is what is in B2. When I
pull down the handle to copy the function to B3-B100, I want only the
A2 to change to the corresponding Cell and I want B1 to stay the same.
However, both functions change. Thanks.



-Darren
 
Homey said:
I have a problem with copying a function to another 100 or so cells.

The function is something like =A2/B1. That is what is in B2. When I
pull down the handle to copy the function to B3-B100, I want only the
A2 to change to the corresponding Cell and I want B1 to stay the same.
However, both functions change. Thanks.
Click to expand...

Use absolute reference for B1:
=A2/$B$1
 
Lock B1, ie use absolute refs $B$1 instead

Put in B2: =A2/$B$1

Now when you copy down col B,
B1 will stay the same in the formula
while A2 will change correspondingly
 
Thanks to all that responded. I figured out another way of doing this
right after posting my problem. I named the Cell that I wanted to
stay the same and made reference to the name instead of the cell
address. This worked great, however, in the future I will be using
absolute reference. I knew there had to be an easy way.

-Darren
 
You're welcome Homey!

We appreciate your feedback.

Glad you found out an alternative way
using named cell(s) / ranges, which is also useful.
(e.g: it makes formulas easy to read & understand)

cheers
Max
 
Back
Top