Related Posts Plugin for WordPress, Blogger...

How To Protect Your Excel Workbook with a Password

If you want to protect your Excel files from the eyes of others, you can actually password protect it in Workbook level. With this password protection, when you open the Excel file, Excel will ask you first for a password before you can view the contents of the workbook.

To password protect your Excel workbook, follow these steps:

1) Go to Save As then click the General Options from the Tools options.

How To Protect Your Excel Workbook with a Password

2) At the General Options, enter the password key at the Password to open and modify. Make sure to remember your password else you need an Excel password unlocker.

How To Protect Your Excel Workbook with a Password

This Excel trick will be applicable to Excel 2007 and higher versions.

If you like this post, buy me a cup of coffee.

Share This Post Digg This Furl Reddit Fav This With Technorati Yahoo MyWeb Stumble This


  1. Marriage and Beyond  

    April 6, 2013 at 8:22 AM

    Great tip for those who would want to make their file secure. :)

  2. Chubskulit Rose  

    April 6, 2013 at 8:25 AM

    You know, I did a secretarial job w in school when I was still in Pinas but I never liked using excel lol.

  3. jheylo  

    April 6, 2013 at 11:13 AM

    ops sorry! I really didn't see this article earlier. I saw the other one.

    Anyway, I used to do this when i was still working as a data encoder way way back. I had to put password in every file i saved because there were other workers who uses my computer. It's better to be safe than sorry right?

  4. Makoy  

    April 6, 2013 at 11:15 AM

    Yes this is very important especially for files with confidential information like your budget or even salary information.

  5. marie  

    April 6, 2013 at 11:32 AM

    this is great ideas however never done this I've only see this one of my friend study Computer encoder and computer programming a good tip for securing your files. - Cheap domain name registration, renewal and transfers - Free SSL Certificates - Web Hosting