Protecting a Worksheet

To preserve all your hard work—particularly if others use your files—protect it with a password. You can protect a sheet or an entire document. In each case, you’ll be asked to supply a password, and then enter it again when you want to work on the file. Passwords are case sensitive, so be sure to supply your password as it was first entered. If you forget a password, there is no way to open the file, so it’s very important to remember or write down your password(s). Keep your password in a safe place. Avoid obvious passwords such as your name, your company, or your favorite pet.

Apply a Password to a Worksheet

Image Click the ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.