Explain the difference between a relative and an abosolute cell reference How can they be distribute when looking at a spreadsheet?
You can also have an address which is part relative and part absolute – so a formula will always look to a specific row but different columns (if the row is absolute and the column is relative), or the same column but different rows (if the column is absolute and the row is relative). So, if you wanted to use information contained along row 2 of each column, but the formula might be on different rows in different columns, you could make the row absolute and the column relative. so the formula in A7 would use A2, the same formula in B6 would use B2, the same formula in C26 would use C2.
Related Questions
- Explain the difference between a relative and an abosolute cell reference How can they be distribute when looking at a spreadsheet?
- Explain the difference between passing parameters by value and passing parameters by reference with an example?
- Could someone please explain the difference between Job Enlargement and Job Enrichment with easy examples?
