Hi all,

I have a question about excel - I've been trying to get this to work for awhile now and can't figure it out. In my spreadsheet, I have a cell a2 with a number in it. In b1 I have another number (row 1, b-h have different #'s).

b2 = a2*b1.

Now, if I copy (ctr+insert) b2 to b3 = the calculation changes from a2*b1 to b2*c1 - which is not what I want.

I want a2 to always be the cell used - so if I copy (ctr+insert) b2 to b3 it should be a2*c1.

How do I do this?