Organize a workbook without breaking its formulas

Rename a linked source, make an independent copy, arrange the tabs and hide the original while its calculation keeps working.

Explain the current workbook

These checks read applied worksheet cells. Editor fields prepare a change; use the matching action button to put that change into the worksheet. A saved record describes a checked attempt on this device.

Does hiding a source stop its calculation?Should editing the copy’s input change the original input?Copied total in Next Plan B5

No current lesson check.

Dataset

Loading your interactive spreadsheet…

Work with the actual tabs

WorksheetNew name

Tab positionSelected plan’s base B2

Actual worksheet order, visibility and values
Position	Name	Visibility	B2	B5	B5 formula	Tab color

Report’s applied formula:

Freeze all formulas

Create, reference and recover a worksheet

Reset before this separate exercise. A new sheet starts empty; a duplicate starts with a copy of another sheet’s contents. Deleting a source removes its cells and breaks references to it. Hiding keeps those cells and references available.

Create Scratch Plan. Enter the number 200 in B2, then the formula =B2+10 in B3.
Select Report and enter ='Scratch Plan'!B3 in B3. Both B3 results should be 210.
Select Scratch Plan and apply tab color #22577A. Delete it and inspect Report B3.
Use this lab’s Undo, Redo, then Undo again. The same source, formulas, reference and tab color should return. Check the recovered workbook and download it.

Recovery here uses this browser workbook’s history. Reset or reload replaces that workbook. Save a separate copy before deleting a sheet in your own spreadsheet application.

Blank sheet nameWorksheetTab color

CellEntry typeValue or formula

Selected cell: B2 =

Report B3:

0 undo action(s), 0 redo action(s) in the current workbook.

Observed worksheet lifecycle actions (0)

These are original local teaching workbooks. Reset restores the dataset. Keep one visible worksheet and no more than eight sheets in this lab. Downloads capture the current workbook. Native Excel edit/save compatibility remains a separate check.