Auto-fill names and dates across sheets with parameters and Find & Replace

Swap a parameter value across many sheets at once by finding its formula and replacing it everywhere.

1. To swap a parameter value across many sheets, double-click the field to see its formula, copy it, open Find & Replace from the toolbar, paste the formula in Find and enter the replacement value, then Replace All.

   ✓ Checked in the product on 16 October 2026

2. Find & Replace updates all sheets at once and is useful for dates that change.

   ✓ Checked in the product on 16 October 2026