How to 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.
Things You'll Need
- Excel Book
- Microsoft Excel
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.
Tips & Warnings
- Using a password is optional.
- If you are tracking changes, you will need to protect your workbook and not your worksheet.