Easy Copying of a Function Help Please

[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

 

[Paul]

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.

Use absolute reference for B1:
=A2/$B$1

 

[Max]

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

 

[Arvi Laanemets]

Hi


=A2/B$1

 

[Homey]

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

 

[Max]

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