How Do You Protect Excel Cells From Modification?
Protect cells if you want people to look at your work, but you don’t want to risk their messing up your formulas. These steps work with Microsoft Excel 97. Start Microsoft Excel and open the file you want to change. Drag mouse and highlight the cells you want to protect. Open the Format menu and select Cells. Select the Protection tab. Click the Locked option. Select OK to accept the changes. Open the Tools menu and select Protection, then select Protect Sheet. Click OK.
Related Questions
- How do I protect or lock an Excel worksheet? How do I protect / lock an Excel worksheet, but still have some cells or ranges unprotected or unlocked?
- Is modification sufficient to protect a bacterial chromosome from a resident restriction endonuclease?
- How do I protect spreadsheet in Microsoft Excel but leave a few cells able to change?
