Counts show all available guides. Filters combine to narrow your results.
Simplify a complex taskGuide
Understand which parts of a formula move when you copy it
Track which coordinates move when a formula is copied to a new cell.
Illustrative resourceNot tool-testedAdults working with non-sensitive spreadsheet references information
What you’re working towards
A copy-by-copy reference map showing relative and fixed coordinates, with explicit expected formulas for several destinations. This is an authored practice example; no consumer AI run has been recorded.
Your choice also saves this guide’s current worked-example checkmarks. Only this browser; no account or sync. View saved guides
Saving needs JavaScript. Reading and downloading this guide does not save it.
Make a start
One step at a time.
2 steps
Start with the synthetic worked example or other non-sensitive inputs. Run one prompt at a time in your chosen AI tool. Replace any bracketed placeholders with the requested material, check each reply, and supply the source or earlier outputs that step needs. Paste them again if the tool lacks that context.
Start with the synthetic example, then adapt each prompt to your task.
01
Try the complete example
Open a new chat in a text AI assistant you already have permission to use. Paste all of Input from this guide, then the prompt below, in one message. Do not paste Output: that is the illustrative answer for comparison. Expect a written result that will track which coordinates move when a formula is copied to a new cell. Different wording is fine; the source facts and rules must agree. Check it yourself: D3 must be =$B$1*C3 and evaluate to 20 under the supplied values. E2 must be =$B$1*D2 and evaluate to 48 because the original D2 equals 12. The fixed $B$1 reference stays unchanged; both destination formulas are copied from original D2, not from each other. If a check fails, paste: “This part is wrong: [quote it]. My source says: [quote the exact line]. Return the complete corrected result and explain the change.” Recheck before saving; if the source itself is incomplete, keep that part unresolved.
Your starting prompt
For each independent copy from D2, calculate row and column offsets, translate every reference using the supplied dollar-sign rule and return the exact formula and value. Explain the sideways dependency on D2 and distinguish formula text from spreadsheet execution.
Use only the complete synthetic input pasted above. Return the finished written result. Keep missing facts unknown. Do not send, publish, order or change another service.
02
Use your own input
For your own version, open a new chat. Paste the prompt below after replacing every bracketed field. Replace related IDs, quantities, dates, rules and limits together; none of the practice facts carries over. Expect the same named deliverable using your source. Review it yourself: mark dollar-fixed rows/columns before applying each source-to-destination offset; confirm behavior in a disposable sheet if using a real application. If a check fails, paste: “This part is wrong: [quote it]. My source says: [quote the exact line]. Return the complete corrected result and explain the change.” Recheck before saving; if the source itself is incomplete, keep that part unresolved.
Your starting prompt
Explain ordinary copying of my original A1-style formula to every supplied destination. Apply my stated reference convention coordinate by coordinate, show row/column offsets and exact resulting formulas, and calculate values only from supplied data and dependencies. Keep absolute and mixed references distinct. Do not cut, move, edit a workbook or claim app execution.
MY INPUT
Original cell and full formula: [replace with your own complete non-sensitive details, or state unknown]
Destination cells: [replace with your own complete non-sensitive details, or state unknown]
Spreadsheet reference convention: [replace with your own complete non-sensitive details, or state unknown]
Relevant example values: [replace with your own complete non-sensitive details, or state unknown]
No workbook mutation: [replace with your own complete non-sensitive details, or state unknown]
Use only MY INPUT for facts and constraints. Ask for an essential missing fact or conflicting rule before deciding; do not import practice-example names or numbers. Return the complete result plus unresolved questions and a source-based check list. Do not send, publish, buy, schedule or change another service.
Optional: improve the result
Separate fixed columns from fixed rows
Use a mixed-reference example under the same explicit convention. This optional extension uses only the synthetic example. Return to the sample chat, or paste its full Input into a new chat first. Do not transfer the changed sample values to your own input.
Advanced prompt
In a separate synthetic example, D2 contains =$B1*C$2. Copy it independently to D3, E2 and E3. Show each offset and resulting formula only; do not invent values for cells that were not supplied. Explain which coordinate each dollar sign fixes.
Show, then try
See the shape of the result.
This input is synthetic. The output is a written illustration of the intended result, not a verified AI-tool run.
01 / The starting point
Synthetic input
Synthetic practice input. All names, products, records and policies below are invented.
Synthetic A1-style sheet, explained as text only. Column letters name columns and row numbers name rows. A dollar sign immediately before a coordinate fixes that coordinate during ordinary copying; a coordinate without a dollar sign shifts by the source-to-destination offset. This exercise uses copying, not cutting or moving cells.
B1 = 4; C2 = 3; C3 = 5.
Original formula in D2: =$B$1*C2
Independently copy the original D2 formula to D3 and to E2. Preserve the original D2 formula. Calculate resulting values only where the supplied values and formulas determine them. No other cells are needed. Do not edit a workbook or claim an application was tested.
Copies text only. For image or file tasks, use the source files named in the steps too.
Illustrative answer authored for this guide; not a recorded AI response.
How the references work
$B$1 fixes both column B and row 1, so it remains $B$1 in both copies.
C2 has neither coordinate fixed, so both its row and column can shift with the copy.
Original D2
Formula: =$B$1*C2
Value from supplied inputs: 4 × 3 = 12.
Copy D2 → D3
Offset: 0 columns, +1 row.
$B$1 stays $B$1; C2 becomes C3.
Resulting formula: =$B$1*C3
Value: 4 × 5 = 20.
Copy D2 → E2
Offset: +1 column, 0 rows.
$B$1 stays $B$1; C2 becomes D2.
Resulting formula: =$B$1*D2
D2 still contains the original formula and evaluates to 12, so E2 = 4 × 12 = 48.
Dependency to notice
The sideways copy now depends on the calculated D2 cell rather than directly on the C2 input. Fixed references stop coordinates moving; they do not freeze the value stored in the referenced cell. These are expected formulas and arithmetic under the supplied convention, not observed spreadsheet results.
These checks use the worked example and its particular facts. With your own material, check your actual names, numbers, sources and rules; do not reuse the sample’s values as the answer.
Unsaved checks stay in this tab and reset when you reload. If you choose Save guide, its current example checkmarks are kept in this browser when storage is available.
!
A few things to watch for.
Copying and moving are different operations. This explanation covers only the explicitly supplied copying convention.
A fixed coordinate is not a frozen value. If its cell changes, dependent formulas can change.
Before adapting in a real application, test in a disposable sheet and inspect actual formulas; do not assume a text explanation proves app behavior.