How do I protect my data in Excel 2007 worksheets from changes? You can lock and hide cell content i.e. the formulas from users by simply protecting the worksheet with a password. First of all you have to lock the cells before you can protect them; and be default all cells in Excel are locked. So all you have to do is find the cells, if any, that you want to allow users access and unlock them before you set your protection with a password. This can be useful when you want employees to enter their hours for the day, but not letting them have access to the other parts of the spreadsheet, like changing the structure of the database. See this in action and watch the training videos!

Purchase the training video and you can see this in action for yourself!