How to password-protect an Excel document on a Mac

There are lots of Excel documents you might want to keep private: spreadsheets with financial information, a Christmas gift list, a list of countries you’re thinking of taking over. Fortunately, you can put a password on any Excel document, so even if people have access to your computer they won’t be able to get into your private documents.You password-protect an Excel document via the Save As… box. You can do it when you first save the document, or you can do a Save As… down the road. Either way, you’re going to see a box like this:

Excel Password Protect 04

Click the Options button. That leads you to this window:

Excel Password Protect box
(Naturally it is completely different from what you see when you click Options in Microsoft Word. If you want to know how to password-protect a Microsoft Word document, click here.)

If you set a password for opening the document you’ve really done all you need. You can probably come up with a situation where you’d want one password for opening the document and another one for editing but I think generic viagra vs cialis that situation would be unusual. Anyhow, enter a password for opening the document, click OK, and you’ll see this box:

Excel Password Protect 06

Enter the password (this is to double-check that you really know what the password is) and you’re all set. From then on, double-clicking the document results in a box like this:

Excel protected 1

Enter the password and you’re in. Get it wrong and you’re kept out. Easy as pie. The password is stored in the document, so if you email the document to someone he’ll need to enter the password to open it up.

That’s all there is to it. But remember the password, because if you forget it, you’re sunk. I don’t know anyone who can hack into a locked Excel document– I don’t think it is possible. Maybe you should make a spreadsheet of passwords. Password-protect that one too.

Tell a friend and help my blog get famous. Every “share” helps. Yours could be the one that puts me over the top.

Did this article help you?

Maybe you'd like to contribute to the
Christian Boyce coffee fund.

Want some some quick iPhone how-tos?
Visit me at

Looking for quick tips about Macs?
See my One-Minute Macman website!

Please use the “Sharing” buttons to share what’s interesting with your friends. It helps your friends and it helps me too. Thank you very much!

Christian signature
Christian Boyce

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑