When you enter the A1 part, press your <F4 key, and you will notice that A1
changes to $A$1. If you copy $A$1*to the adjacent cell, it will copy as
$A$1*C1, and if you copy $A$1*C1 to the cell below, it will change to
$A$1*C2. If you press <F4 repeatedly, it will change the $ signs to $A1 and
A$1. Doing this will "anchor" either the column or the row indicator.

"dave" wrote:

hi there - i'd like to multiply a variety of cells by the same cell - so, i'd
like to multiply the information in cell A1 by the information in b1 through
b10 and c1 through c10 and d1 through d10.

is there a way to set up the formula so that when i copy and paste the a1*b1
to the cell next to it, it says a1*c1 or when i copy and paste below instead
of a2*b2 it pastes a1*b2 and then a1*c3 etc etc

thanks
dave