Cellwise · Formulas that scale

Filling formulas down

Learn why fill-down breaks formulas, and how $ fixes it.

You can write one formula and fill it down a whole table without breaking it.

This lesson has 4 steps of hands-on practice in a live spreadsheet. Every formula you write is also tested on data you haven’t seen, so you know it really works.