Lesson 1 of 7
1. The Absolute Basics: Fixing Cells for Faster Fills
Understanding absolute references (e.g., $A$1) is crucial for efficient formula copying. When you drag a formula down or across, a relative reference (A1) changes, but an absolute reference stays put. This means you can point to a tax rate or a conversion factor in a single cell and apply it consistently across hundreds of rows without retyping.