Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Protecting Your Data

If a worksheet contains cells you do not want changed, you can lock them so that they cannot be edited or deleted. You can also add a password to a sheet or workbook to protect the entire sheet or workbook.

If you have columns and rows that you do not want anyone to see or change, you can hide the columns and rows and then display them again whenever you wish.

Locking Cells

To set cell protection, perform the steps in the To Do exercise. You want to lock all the cells in your worksheet except for the numbers for March in column D.

To Do: Lock Cells

1.	In the Summary sheet, select cells D4:D8. You want to protect these cells from being locked.
2.	Choose Format, Cells. The Format Cells dialog box appears.
3.	Click the Protection ...