Status
Not open for further replies.
1 - 4 of 4 Posts

#### Chevy

·
##### Registered
Joined
·
4,890 Posts
Discussion Starter · ·
OK ... let's see if I can explain this one ...

Cell Value*
A1 2
A2 3
A3 4

*These are constants

Cell Value
A6 X
B6 X*A1
C6 X*A2
D6 X*A3

I get this far, then highlight B6-D6. Using the right-bottom corener (where your cursor turns to a +) I pull down to, say, row 30.

The result I want is that the formula B6=A6*A1 turns to B7=A7*A1 turns to B8=A8*A1, etc. What I get is an increse in the all parts, ie: B6=A6*A1 turns to B7=A7*A2 ...

Anyone know a better way?

#### Pseudocyber

·
##### Registered
Joined
·
1,393 Posts
Put a \$ into the part of the formula you don't want to change.

Highlight (click) on the cell you want to start with, then shift and click on the last cell (or just drag) and hit Ctrl-D (copy down).

HTH

#### Chevy

·
##### Registered
Joined
·
4,890 Posts
Discussion Starter · ·
Thanks much

This is been driving me nuts for a while!

#### ejcohen3

·
##### Registered
Joined
·
3 Posts
In the formula bar, format the A1 ref as \$A\$1; the dollar signs indicate that this is a constant.

1 - 4 of 4 Posts
Status
Not open for further replies.