Easy: Paste values over formulas
RunningTotal looks right today but holds pasted numbers. Change a signup — totals stay stale. Restore =B5 and =C5+B6 patterns.
RunningTotal आता बरोबर दिसते पण pasted values आहेत. Signup बदला — total जुन्याच. Formulas परत आणा.
RunningTotal सही दिखता है पर pasted values हैं। Signup बदलो — total पुराना। Formulas वापस लाओ।
Why → What → How
Why: Paste Values is useful for snapshots and deadly inside templates.
What: Six weeks; broken C column is values. Fixed uses running formulas. Grand links to C10.
How:
- Open Template.
- Click a RunningTotal — formula bar shows a number.
- Replace with formulas.
- Change W3 signups — total should move.
Ravindra Bagale’s Tip
Templates must keep formulas. Snapshot? Copy sheet or Paste Values to a separate Archive.
Ravindra Bagale’s Tip – मराठी
Template मध्ये formulas ठेवा. Snapshot वेगळ्या sheet वर Paste Values.
Ravindra Bagale’s Tip – हिंदी
Template में formulas रखो। Snapshot अलग sheet पर Paste Values।
Bugs explained (with mini examples)
Bug 1 — Paste Values on RunningTotal
Bug 2 — False confidence
Practice tasks (12)
- Task 1. Is C7 a formula or value in broken file?Hint: Value.
- Task 2. Write C5 formula.Hint: =B5.
- Task 3. Write C6 formula.Hint: =C5+B6.
- Task 4. Fill through C10.Hint: Yes.
- Task 5. Edit B7 — does C10 move (fixed)?Hint: Yes.
- Task 6. Interview sentence.Hint: “Someone paste-valued the running total.”
- Task 7. Why archive sheets exist.Hint: Snapshots.
- Task 8. Grand formula.Hint: =C10.
- Task 9. Protect formula cells.Hint: Optional.
- Task 10. Show formula view (Ctrl+`).Hint: Audit.
- Task 11. Bonus: Table with running total column.Hint: Modern.
- Task 12. Document “do not paste values here”.Hint: Note in A13.
In-browser formula check
Type the fixed formula you would put in the named cell. We check formula text — open the workbook for full recalculation.
Step-by-step solution (try first)
- C5==B5; C6==C5+B6 fill down.
- Change a signup to prove it updates.
Quick quiz