Excel Issue while Copying Formula

[Ameya]

Hi,
I am facing an issue while i am copying a formula from one Cell to another. For example

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.

Can any one help me out with this issue.

[Macarenas]

I was also facing similar kind of issue before copy the formula horizonitally Copy as =$a$2*b$1

So the calculation in b2 would be a2*b1

The calculation in c2 would be a2*c1

It worked for me Hope it worked for you too.