Locking select worksheets

  • I've created a spreadsheet for tracking my weekly time at work, it has serveral worksheets for summaries and totals, etc. there are about 6 worksheets total out of the 6 there are only 2 that a user should manually manipulate, all others are altered based on the info entered on the those two. I have to roll this out to my team, and want to know if there is a way I can lock the 4 worksheets that do not need manual intervention but will still function as needed (updating when the 2 worksheets are changed).


    Note: Might be good to also know if I can lock portions of the editable worksheets as well, things like headers/Titles, etc. ?


    Thanks in advance for any help

  • Re: Locking select worksheets


    Format=>Cells=>Protection=>Locked


    You could just make all cells on the worksheet locked apart from the ones you require to change, then protect the worksheet.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!