How to Protect Excel Cells From Modification

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.

Step

Start Microsoft Excel and open the file you want to change.

Step

Drag mouse and highlight the cells you want to protect.

Step

Open the Format menu and select Cells.

Step

Select the Protection tab.

Step

Click the Locked option.

Step

Select OK to accept the changes.

Step

Open the Tools menu and select Protection, then select Protect Sheet.

Step

Click OK.