The stocktake template has yellow count cells and a separate value column. Reset last week’s counts while keeping the visual cues and calculations the next person needs.
Select the input cells precisely
Work in a copy if the previous counts need to be retained. Select C5:C8 in Ulet Sheets. Verify that the adjacent formula cells in D5:D8 are outside the selection. In Home > Clear, choose Clear Contents. It clears values and formulas inside the selection, so the boundary matters.

Example selection. Check the formula column is outside the clear operation.
Check the empty cells and one calculation
Confirm C5:C8 is blank and the yellow fill remains. Select D5 and check that =B5*C5 is still in its formula bar. If the unit cost in B5 is 12, entering a test count of 3 should give 36. Clear the test count before saving the fresh template.

Example test. Verify both the preserved format and the surviving formula.
When there are separate input ranges, reset and check them one at a time. The next user should see an empty entry area with the same formatting and formulas ready to use.



