Introduction
Relative references help you copy formulas easily by adjusting cell references automatically. This saves time when you want to do the same calculation for many rows or columns without typing each formula.
When you want to add sales numbers for each row in a list without typing each formula.
When calculating total prices by multiplying quantity and price for many products.
When you need to apply the same formula across a column or row with different data.
When creating a simple budget that sums expenses for each month.
When you want to copy a formula down a column to calculate discounts for each item.