The equipment intake sheet needs six editable daily inputs in B3:B8. Keep the calculated results in column C outside the editable area.

Define DailyInput before protecting the sheet

In Ulet choose Review → Allow Edit Ranges. Add DailyInput for B3:B8 and confirm the dialog. Choose Review → Protect Sheet and save the workbook.

The DailyInput exception covers B3:B8 only.

Illustrated protection setup. Put result formulas outside the exception.

Reopen and test both sides of the boundary

Try a sample value in B3 and verify it is accepted. Try to replace the formula in C3 and verify it remains protected. Remove the sample input before sharing. If the form grows by one row, review the exception and test its new edge.

An input is accepted in B3 and the C3 formula remains protected.

Illustrated saved-copy test. Remove the sample input before sharing.

Microsoft’s reference for editable areas on a protected worksheet