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.

    Matt B

Participate now!

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