[Excel Infographic] Understanding Absolute & Relative Addresses in Excel

Matthew Steele

Here’s a look at Excel cell references in a formula and how they compare with houses on your street.
Infographic_Excel_Relative_Absolute_References

Related posts:

  1. Quickly insert a total sum in Excel One of the advantages in Excel is the ability to use formulas to quickly calculate averages, totals, etc as well...
  2. $617 Billion Fat Finger Error – How to avoid errors in Excel A trader in Tokyo found himself in a hopelessly embarrassing situation after it was found that he had keyed in...
  3. Convert a number into written words in Excel (great for automating your cheques) Recently a subscriber sent me in an email with a template they use to print cheques with a printer, rather...
  4. Excel Timesheet Template – free for my LinkedIn connections An Advanced Excel Timesheet Template for my LinkedIn 1st connections. I’ll be up front, right at the front – I...