Infolinks

How to add password protection on MS Office Excel, Word, Powerpoint file (2007 / 2010)

In the MS Office Software Suite (2007/2010), you can use passwords to protect and prevent other people from opening or modifying the said file (whether documents, workbooks, and presentations).

(Note: Before doing it, make a strong password and always keep certain record for the password. Keep in mind that Microsoft cannot retrieve forgotten passwords.)

1. Click the Microsoft ButtonAdd password protection on MS Office Excel, Word, Powerpoint file, go to Prepare and then head forth to Encrypt Document then click it.
Add password protection on MS Office Excel, Word, Powerpoint file

2. In Encrypt Dialog prompt, it will ask you to put a password. Enter a password of your choice then click OK.
Add password protection on MS Office Excel, Word, Powerpoint file
*You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.

3. In Confirm Dialog prompt, reenter the password, for verification purposes. Click OK afterwards.
Add password protection on MS Office Excel, Word, Powerpoint file

4. Save the file to save the password. Then try to open the said file. You will see that your file is protected and asking for a password.
Add password protection on MS Office Excel, Word, Powerpoint file

(Note: Stated above steps is applicable for Microsoft Word Document, Excel Spreadsheet, and Powerpoint Presentation)

Is there other way on how to protect your MS Office (Excel, Word, and Powerpoint) file and that able to modify it? – Yes, you can extend it by using the following procedure:

1. Click the Microsoft ButtonAdd password protection on MS Office Excel, Word, Powerpoint file, and then click Save As.
Add password protection on MS Office Excel, Word, Powerpoint file

2. In Save As Dialog prompt, click Tools drop-down menu, then click General Options.
Add password protection on MS Office Excel, Word, Powerpoint file

3. General Options Dialog prompt, Under File sharing section, in the Password to open and Password to modify box, type a certain password to it.
Add password protection on MS Office Excel, Word, Powerpoint file

(Note: It is a better practice to implement Read-only file, making it more secure and protected for any changes of the file/contents, put a check mark to it.)

4. In Confirm Dialog prompt, reenter the password, (both open and modify). Click OK after each confirmation prompt. After that, you may now click Save.
Add password protection on MS Office Excel, Word, Powerpoint fileAdd password protection on MS Office Excel, Word, Powerpoint file
(Note: If you want to open the file with password protection on modifying, then choose only the Password to modify. When you open the file, you will see that you have an option to open the file in read-only state. Were as, if you enable the Password to open, you cannot view the file contents without putting the password of opening the file.)
Add password protection on MS Office Excel, Word, Powerpoint file
*If you only enable password to modify the output would be this.

(Note: Stated above steps is applicable for Microsoft Word Document, Excel Spreadsheet, and Powerpoint Presentation)

Can I put password protection certain cell or range cells?
Yes, you can put a password protection on certain cell or range cells, preventing it from modifying.

1. Open the spreadsheet, and then click the Review tab. From there, click Protect Workbook drop-down menu, and under Restrict Editing click the Protect Structure and Windows.
Add password protection on MS Office Excel, Word, Powerpoint file

2. In Protect Structure and Windows Dialog prompt, under the Protect workbook for, enable the Structure and Windows (put a check mark on it).
Add password protection on MS Office Excel, Word, Powerpoint file
(Note: You may put a password as optional, but skip that, I’ll show you a better way on how to put appropriate password on it.)

3. Next is to select certain cell or range cells, again, on the Review tab, click Allow Users to Edit Ranges. It will show you the Allow Users to Edit Ranges, from there, click New.
Add password protection on MS Office Excel, Word, Powerpoint file

4. In New Range dialog prompt, type your own title of range, then put a range password. Click OK afterwards.
Add password protection on MS Office Excel, Word, Powerpoint file

5. In the Review Tab, click on Protect Sheet, put check mark on Protect worksheet and contents of locked cells. Under Allow all users of this worksheet to, select your own preferences on how the user can manipulate the worksheet. Click several options as you want or you may choose all.
Add password protection on MS Office Excel, Word, Powerpoint file
Under the Password to unprotect sheet, type a password on it. It will ask for confirmation to reenter the password, so type it. Click OK afterwards.

6. Save your file, and then try to re-open it. Go to the cell where you put a range password. Try to modify it, and you will be ask for a password.
Add password protection on MS Office Excel, Word, Powerpoint file

(Note: Stated above steps is applicable for Microsoft Excel Spreadsheet)

Feel free to comment here if you found one interesting to share or your own experience. That’s all! I hope this guide and tips helps you out! Cheers! 😀

(Disclosure: Microsoft (Windows and MS Office Suite – Excel, Word, Powerpoint) Logo/Images/Pictures has a respective copyright. We used it for demonstration purpose only.)

BUY MICROSOFT OFFICE 2007, 2010 AT AMAZON:

Related Entries / Links / Sources / Articles / Sources:
MS Office Help Support – Password protect documents, workbooks, and presentations – Official Site

Related Posts Plugin for WordPress, Blogger...
Share
3 thoughts on “Add password on MS Office Excel, Word, Powerpoint file”
  1. Please let me know if you’re looking for a article writer for your blog. You have some really great articles and I think I would be a good asset. If you ever want to take some of the load off, I’d love
    to write some content for your blog in exchange for a
    link back to mine. Please shoot me an email if interested.
    Kudos!

  2. I just want to say I am beginner to blogging and definitely liked you’re web page. Most likely I’m want to bookmark your blog . You actually have really good posts. Thanks a bunch for revealing your blog.

  3. I simply want to tell you that I’m beginner to blogging and site-building and definitely loved your website. Probably I’m want to bookmark your blog . You certainly come with beneficial articles and reviews. Cheers for sharing your website.

Leave a Reply

Your email address will not be published. Required fields are marked *

Infolinks