What is the difference between absolute and relative cell references?
When you copy formulas from one cell to another, Excel automatically adjusts the cell references to the new location. For example, if you copy the formula in cell B6 =SUM(B2:B5) and paste it into cell C6, the formula in cell C6 will adjust to =SUM(C2:C5). This is relative cell referencing where the cell references are relative to the cell’s position. If you want to control which column or row is referenced in a formula, you must use absolute referencing by placing a dollar sign ($) before the column and/or row. For example, if we want to copy a formula that references a value in cell E1, and we always want to reference that cell regardless for where the formula is copied to on the spreadsheet, we would reference the cell as $E$1. The absolute reference may be used in any formula (ex. =B6/$E$1), and when the formula is copied, B6 would change relative to the new location of the formula, but the reference to E1 would remain constant. You may also place the dollar sign ($) just before the
