'anchoring' or 'grounding' part of a formula
Use absolute references for your anchor cell: $A$1 (note the dollar
signs--this is an absolute reference, so that if you have =$A$1*B1 and copy
down you will get $A$1*B2, etc.
To keep only the column as an absolute reference, use $A1.
To keep only the row as an absolute reference, use A$1.
Finally, the reference you're using below is called a relative reference.
--
Brevity is the soul of wit.
"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
|