In my excel 2010 worksheet, I have entered a formula `=+H8+N8*AA7`

where AA7 is a permanent number where as H20 & N20 will change.

But if I copy this formula to the below row, it pastes as `=+H8+N8*AA9`

, the next row `=+H8+N8*AA11`

and then again to `=+H8+N8*AA13`

etc.

In this formula, I always need to multiply the H & N column by AA7. But AA7 keeps on changing. Please give the reason & a solution.

Thanks.