Whenever you copy a formula to a new location, the formula automatically adjusts to its new location. For example, suppose you have the following formula in cell D3:
=B3 * C3
If you copy this formula down to cell D4, Excel will automatically change this formula to read:
=B4 * C4
This is called a Relative Cell Reference. When a formula is copied to a new location, it will reference the new cells based on their relative location to the original cells containing the formula. Relative Cell References are the default type of references in Excel – which means you don’t need to do anything! Any time you copy or move a formula to a different locations, Excel automatically updates the relative references.
Tomorrow, we’ll look at how to create Absolute References.
Similar Posts:
- None Found
