Tech Support banner

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

·
Registered
Joined
·
4,890 Posts
Discussion Starter #1
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?
 

·
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
 
1 - 4 of 4 Posts
Status
Not open for further replies.
Top