Playground
Fill a formula across cells
Drag to extend a formula; references adjust automatically.
What it does
Drag the fill handle at the bottom-right of a selection (or press Ctrl+D to fill down, Ctrl+R to fill right) to extend a formula. Relative references shift automatically, and TrueCalc recomputes every filled cell.
Try it
Verified behavior
Matches Google Sheets: In Google Sheets, filling "=A1+1" down from A2 yields "=A2+1", "=A3+1", "=A4+1" — relative references shift by row, producing a column of values.
Filling a formula down adjusts relative references
Given
- A1 =
10 - A2 =
=A1+1
When I fill from A2 to A5
Then
- A3 shows
12 - A4 shows
13 - A5 shows
14 - A3 has formula
=A2+1 - A4 has formula
=A3+1 - A5 has formula
=A4+1