You probably know the difference between a relative and an absolute cell reference:
- A relative reference adjusts when you copy the formula.
- An absolute reference never changes.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.