HOWTO: Using Excel - How To Use Absolute Addressing
Microsoft Excel, like most spreadsheets, has a really convenient feature. When you copy any given cell into another cell, Excel will automatically adjust the formula references to other cells so refer to cells in the same relative position.
First, a look at Relative Addressing
In the example below, I copied thte formula in cell C2 [...]