Introduction
Relative references in Excel let you copy formulas easily. When you copy a formula with relative references, Excel adjusts the cell addresses automatically. This saves time when working with similar calculations across rows or columns.
When you want to add numbers in a column and copy the formula down to sum each row.
When calculating prices with tax for a list of products and copying the formula for all products.
When you need to multiply quantities by unit prices across many rows without typing each formula.
When creating a simple budget and copying formulas for each month.
When you want to calculate totals for different categories by copying formulas horizontally.