Drag Auto complete question

[thunderspeed]

hi all ,
I want to drag down a cell's formula where i need only one of the two cells involved to be changed , meaning I want to drag down and have :

=CX8200*C8
=CX8200*C9
=CX8200*C10
=CX8200*C11
=CX8200*C12

instead of :
=CX8201*C8
=CX8202*C9
=CX8203*C10
=CX8204*C11
=CX8205*C12

 

[VoG]

Try

=CX$8200*C8

 

[Vidar]

Use locked cell reference for the first part:

=$CX$8200*C8

 

[thunderspeed]

thank you guys