O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required