$a$1
I think this is what you are asking. The sheet it is on doesn't really matter. To hold the value as you copy down any rows you just use $ sign in front of the affected row or column in the formula.
ie A1*$B$1 is in C1 if you copy the formula down to c2 and beyond you get
A2*$B$1 in C2
A3*$B$1 in C3
toss the sheet reference in front and your done.
|