Skip to main content
SheetTutor.
← All practice

Connect worksheets without losing the source

Build real cross-sheet formulas, edit the linked records and check a complete report.

Clean the intended text, preserve the record

Keep original IDs, names and notes. Normalize only the imported code, then apply exact-prefix, selected-occurrence and positional rules. Check every stage and every retained record.

Retain the original record

Copy the ID, name and note as literal text identities. Leading zeroes, repeated spaces, a leading equals sign and error-looking labels are intentional. Cleanup applies only to the imported code.

Loading your interactive spreadsheet…

Enter Report formulas

The editor draft is applied only when you choose Apply. Checking always reads the formulas currently in the workbook, including edits made directly in the grid.

Record IDOriginal nameNormalized codePrefix removedSelected occurrencePosition editFinal lengthChanged?Original note
BlankBlankBlankBlankBlankBlankBlankBlankBlank
BlankBlankBlankBlankBlankBlankBlankBlankBlank
BlankBlankBlankBlankBlankBlankBlankBlankBlank
BlankBlankBlankBlankBlankBlankBlankBlankBlank
BlankBlankBlankBlankBlankBlankBlankBlankBlank
BlankBlankBlankBlankBlankBlankBlankBlankBlank
Report!B11 · Retained records
Blank
Report!B12 · Changed codes
Blank
Report!B13 · Final text length
Blank

Follow the written workbook references

Inspect the applied Report result selected above. This recalculates the current workbook and captures its values; it does not apply the editor draft or complete the practice.

Edit a literal cell with the form

Use this on a phone or to preserve a text ID such as 001. Source rows must retain their headers and declared area; added records and formulas in data cells withhold grading.

See the applied formula calculate

Select a formula from any worksheet. This copies the complete current workbook for two local calculations; it does not apply the editor draft or complete practice.

This cell has no applied formula. Enter one in the workbook or apply an example first.

Highlighting covers unqualified A1 ranges on the selected worksheet. Use the written-source inspector above to navigate qualified references.

Inspect the current formula

Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.

Calculate observations to inspect arithmetic, comparison, concatenation and reference operators. No operation values have been recorded yet.

These original workflows use fixed source ranges, literal inputs and separate scalar result cells. Price/amount inputs use whole cents within ±1,000,000 (prices nonnegative); quantities are whole numbers 0–10,000. Data and query cells do not accept formulas. The 3-D workflow adds bounded source-order moves and same-layout aggregates. Cross-workbook connections, endpoint moves/deletion, general multi-sheet tracing and native edit/save remain separate capabilities. The text-cleanup workflow instead uses six basic-Latin/NBSP records with bounded text rules. It preserves protected fields, checks each intermediate result and tests ten changed source/control scenarios; it does not infer a universal cleanup policy.

Microsoft: Create a reference to another worksheet ↗