How to Create Protected Spreadsheets with Locked and Unlocked Cells
Recently, a question came up: how do you create a protected spreadsheet with a mixture of locked and unlocked cells. I recorded a 7-minute video in which I explain the feature and explore the markup.
In addition to exploring this specific feature, this video demonstrates my approach for researching these types of problems.
You can find the video here:
http://www.youtube.com/watch?v=KN2Q0vWMd8k
-Eric