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.

An example selects C5:C8 for manual counts and leaves the formulas in D5:D8 outside the range.

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.

The empty count cells retain their fill and a test input of 3 produces 36 in the adjacent calculated cell.

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.