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
Edit a cell
Type into a cell to set a literal or a formula; the formula is stored and its computed value is shown.
Copy, cut, and paste
Copy adjusts references to the paste target; cut moves the range and rewrites every reference into it — inside the moved range or anywhere else on the sheet — to follow, with a dashed border marking a pending cut and no clipboard-permission prompt on paste.