How to protect a WorksheetClick on Tools-Protection-Protect Sheet - enter password (optional)By default this will:
It will not prevent:
Locking / Protecting Cell ContentsCell contents are protected or ''Locked'' by default which means that clicking Tools-Protection-Protect Sheet will automatically protect the cell contents.This default can be turned off by
This is useful when there is requirement for unprotected user-input cells and protected formulas cells.Hiding FormulasFormulas are displayed by default in the formula bar. Users can see both the formula and the results of the formula.Formulas can be hidden by:
Protecting objects and scenariosObjects (images, autoshapes, controls) and scenarios are protected by default when worksheet protection is enabled.To leave objects and/or scenarios unprotected click on Tools-Protection-Protect Sheet and uncheck the Object and/ or Scenario checkboxes.Improved Protection in Excel 2002 +"To protect your worksheet in Microsoft Excel prior to the 2002 version, you would lock the cells that you wanted to prevent users from changing. Unfortunately, your users could not perform basic tasks such as inserting rows or columns, or formatting the cells of that same worksheet.Thankfully, the worksheet protection model in Excel 2002 is much richer than earlier versions. You can now allow users to perform basic worksheet tasks such as inserting and deleting cells while the worksheet is protected. You can assign permissions to specific cell ranges, allowing only certain users to edit specific portions of your worksheets. "More details at The Microsoft Developer Network Library', '