Password Protect A Excel File

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.


Password Protect A Excel File






Password Protect A Excel File

The Video above explains how to use the Frequency Formula of MS Excel. The Text below is from a Microsoft Excel Support Blog

Password protect documents, workbooks, and presentations

In the 2007 Microsoft Office system, you can use passwords to help prevent other people from opening or modifying your documents, workbooks, and presentations. Keep in mind that Microsoft cannot retrieve forgotten passwords.
For more about passwords, see Create strong passwords.

CAUTION: Keep your password in a safe place. If you lose or forget the password, it can’t be recovered.

What do you want to do?

Set a password in a Word document
Remove password protection from a Word document
Set a password to modify a Word document
Set a password in an Excel spreadsheet
Remove password protection from an Excel spreadsheet
Set a password to modify an Excel spreadsheet
Set a password for a PowerPoint presentation
Remove password protection from a PowerPoint presentation
Set a password to modify a PowerPoint presentation

Set a password in a Word document

To encrypt your file and set a password to open it:

  1. Click the Microsoft Office Button Office button image , point to Prepare, and then click Encrypt Document.Encrypt Document
  2. In the Encrypt Document dialog box, in the Password box, type a password, and then click OK.

    CAUTION: Keep your password in a safe place. If you lose or forget the password, it can’t be recovered.

    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 the Confirm Password dialog box, in the Reenter password box, type the password again, and then click OK.
  4. To save the password, save the file.

 

Remove password protection from a Word document

  1. Use the password to open the document.
  2. Click the Microsoft Office Button Office button image , point to Prepare, and then click Encrypt Document.
  3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  4. Save the file.

 

Set a password to modify a Word document

In addition to setting a password to open a Word document, you can set a password to allow others to modify the document.

  1. Click the Microsoft Office Button Office button image , click Save As, and on the bottom of the Save As dialog, click Tools.
  2. On the Tools menu, click General Options. The General Options dialog opens.
  3. Under File sharing options for this document, in the Password to modify box, type a password.
  4. In the Confirm Password dialog, re-type the password. Click OK.
  5. Click Save.

NOTE: To remove the password, repeat these instructions and then delete the password from the Password to modify box. Click Save.

 

Set a password in an Excel spreadsheet

To encrypt your workbook and set a password to open it:

  1. Click the Microsoft Office Button Office button image , point to Prepare, and then click Encrypt Document.Encrypt Document
  2. In the Password box, type a password, and then click OK.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 the Reenter password box, type the password again, and then click OK.
  4. To save the password, save the file.

 

Remove password protection from an Excel spreadsheet

  1. Use the password to open the spreadsheet.
  2. Click the Microsoft Office Button Office button image , point to Prepare, and then click Encrypt Document.
  3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  4. Save the spreadsheet.

 

Set a password to modify an Excel spreadsheet

In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.

  1. Click the Microsoft Office Button Office button image , click Save As, and on the bottom of the Save As dialog, click Tools.
  2. On the Tools menu, click General Options. The General Options dialog opens.
  3. Under File sharing, in the Password to modify box, type a password.
  4. In the Confirm Password dialog, re-type the password. Click OK.
  5. Click Save.

NOTE: To remove the password, repeat these instructions and then delete the password from the Password to modify box. Click Save.

 

Set a password for a PowerPoint presentation

To encrypt your presentation and set a password to open it:

  1. Click the Microsoft Office Button Office button image , point to Prepare, and then click Encrypt Document.

    CAUTION: Keep your password in a safe place. If you lose or forget the password, it can’t be recovered.

    Encrypt Document

  2. In the Password box, type a password, and then click OK.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 the Reenter password box, type the password again, and then click OK.
  4. To save the password, save the file.

 

Remove password protection from a PowerPoint presentation

  1. Use the password to open the presentation.
  2. Click the Microsoft Office Button Office button image , point to Prepare, and then click Encrypt Document.
  3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  4. Save the presentation.

 

Set a password to modify a PowerPoint presentation

In addition to setting a password to open a PowerPoint presentation, you can set a password to allow others to modify the presentation.

  1. Click the Microsoft Office Button Office button image , click Save As, and on the bottom of the Save As dialog, click Tools.
  2. On the Tools menu, click General Options. The General Options dialog opens.
  3. Under File sharing settings for this document, in the Password to modify box, type a password.
  4. In the Confirm Password dialog, re-type the password. Click OK.
  5. Click Save.

NOTE: To remove the password, repeat these instructions and then delete the password from the Password to modify box. Click Save.








Our Other Services




Read Free Ebooks

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!



Buy Excel Course

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788



Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!


Download Excel Crash Course


This Excel Crash Course contains the list of topics that cover the most important and used features and formula of Excel . This Excel Crash Course lists 43 major topics in Excel so that you can start using Excel like a pro in the shortest possible time.



Learn Photoshop Web Designing


You can Buy the Photoshop Course to learn Photoshop and start a career in Web Designing and Photo Editing. .



Learn HTML CSS


You can Buy the HTML CSS Course to learn HTML CSS and start a career in Web Designing and Photo Editing. .


Download Full list of Excel Shortcuts


This Excel Shortcuts Complete list is to help you become save time and use Excel like a Master level user. Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.

I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.




Full List of Excel Formulas

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on www.Myelesson.org




Convert Numbers to Text in Excel

Now easily convert numbers to Text in Excel with this inbuilt sheet from myelesson.org .  Many times we need the amount in figures to be converted into words. This is a typical requirement for writing checks or any other financial reports. Microsoft Excel does not have standard function available for this requirement. Just download this sheet and then you can convert any number to text in Excel.




List of Most Commonly Asked Excel Questions in Interviews

Here is the list of most asked excel related questions in interviews.  Prepare for this excel questions and you would be able to most of the excel interviews. This list of excel questions covers excel formula, excel analysis, excel reporting, excel charts and more.





Myelesson © 2010 - 2014. All rights reserved.

Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok
Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok