Windows – Excel formula – Absolute reference to cell

microsoft excelmicrosoft-excel-2010windows

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.

Best Answer

Use the $ sign to force the cell reference (AKA absolute cell reference).

If want to keep both cell and column type $AA$7 (regardless of where you drag the formula too).

EG =+H8+N8*$AA$7

You may also need to use the Indirect keyword.

Further examples of the absolute cell reference.

Related Question