Locking cells in sheet

afantozzi

Hello,

I am trying to determine if there is a way to lock the formulas I have placed in my sheet so that the users cannot override them to hard key in numbers. The formulas have been entered into all of the necessary cells but as it stands, users can simply clear them out to enter the amounts in their own way. We have these formulas as a way to verify accuracy and it is important from an operational standpoint that these are universally applied across all projects, regardless of the project manager.

Does anyone have any recommendations for how to do this? If it is not possible, does anyone have an alternative suggestion they could make?

Ryan Sides

@afantozzi are they all in the same column? If so, you can lock the column so only Admins can edit it. You can also lock entire rows. Otherwise, there's no way to "lock" individual cells.

afantozzi

@Ryan Sides If you look at a screenshot of the template below, the green, orange, grey, and brown columns have formulas. The way the sheet is intended to work, once the appropriate sub's waiver arrives, it is attached to their row in the sheet and the PC Approval column is dated, advancing the workflow to the next approver and so on.

Ryan Sides

@afantozzi Makes sense. So right click on the green through brown column headers and select "Lock Column". Then, make sure the users shared the sheet are Editors, not admins.