Skip to main content
SheetTutor.
Copy and fill principles
  1. Compare. Copy B2 right. The Jan column stays Jan, so the first row repeats.
  2. Fill. Fill right: Jan → Feb → Mar. Monthly[[Region]:[Region]] keeps Region fixed.
  3. Complete. Fill down. $A2 keeps column A and follows each region row.

This project uses ordinary copy and fill on the applied formulas. The explicit controls below add Table-aware fill to the worksheet. Ctrl-fill and moving a formula between Tables are outside this exercise.

Teaching · read-only · Report!A1

Step 1 / 5Read the actual monthly records

Inspect
More

Each record supplies a Region and three numeric months. Repeated regions are separate records; SUMIFS adds every matching record. Teaching is read-only; switch to Your turn to edit.

Source!C2 · (blank)
No formula applied

Loading your interactive spreadsheet…

1. Apply a report formula

2. Preview a copy or fill

B2 → C2:D2. Table column names stay the same.

Current complete report

Swipe sideways to compare all three months.

Region
—No formula—No formula—No formula
—No formula—No formula—No formula
—No formula—No formula—No formula
Inspect every source record

3. Change the inputs and check again

Edit Source rows 2–8, columns B–E, or Report region labels A2:A4. Changes go into the real worksheet and can be undone.

Checks compare all nine results with independent source totals and changed-input calculations. Browser checks and downloaded workbook inspection do not certify native Excel edit/save behavior.