How to put password for excel sheet | word


How to put password for excel sheet | word


Microsoft excel and word are the most popular applications in computers. Excel and word are very useful applications and almost every computer user using now days. Excel is used to store and retrieve numerical data in a format of rows and columns. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions.

MS Word is a most popular word-processing program used mainly for creating documents such as letters, brochures, learning activities etc. There are many useful and helpful features available in Ms word to make it easier for study and work.

If we store some important data in excel or word we need security for that. If we leave it like that anyone can open that excel sheet or word and see the data who has access to our computer. For such kind of cases we have to put password for our excel sheets or word documents so that no one can open our excel sheets or word documents. It should ask for password if anyone open our password protected excel sheets or word document. we can simply put password for our excel sheets and word documents and we can remove the same password also.



Procedure to put password for excel sheet 2007 | word 2007:

Step 1) Open your excel sheet or word document
Step 2) Click on Office Button (File Option)
Step 3) Go to “Prepare”
Step 4) Go to Encrypt Document
Step 5) Enter the password which you want to put and click on “OK”
Step 6) Re-enter the same password and click on “OK”
Step 7) Save the document

Check the below screen shot to put password for excel sheet 2007,

how to put password for excel sheet 2007


Now, if you open this password protected excel sheet or word document it will ask you to enter the password like below image. You have to enter the password to see the data.

Procedure to put password for excel sheet 2013 | word 2013:

Step 1) Open your excel sheet or word document
Step 2) Go to “File” option
Step 3) Go to “Info”
Step 4) Click on “Protect Workbook”
Step 4) Click on “Encrypt With Password”
Step 5) Enter the password which you want to put and click on “OK”
Step 6) Re-enter the same password and click on “OK”
Step 7) Save the document

Check the below screen shot to put password for excel sheet 2013,


how to put password for excel sheet 2013


Word documents also has same procedure, by using above instructions we can put password for excel sheet and word documents. After put the password for excel sheet or word documents if you open that documents they should ask for password like below screen shot.

password protected excel sheet word document

Now we have to enter the password for this excel sheet or word document to open and see the data.
No one can open these type of password protected excel sheets or word documents without the password.

Procedure to remove the password for excel sheet 2007 | word 2007:

Step 1) Open your excel sheet or word document by using the password
Step 2) Click on Office Button (File Option)
Step 3) Go to “Prepare”
Step 4) Go to Encrypt Document
Step 5) Remove the password which have added
Step 6) Click on "Ok"
Step 7) Save the document

Procedure to remove the password for excel sheet 2013 | word 2013:

Step 1) Open your excel sheet or word document by using password
Step 2) Go to “File” option
Step 3) Go to “Info”
Step 4) Click on “Protect Workbook”
Step 4) Click on “Encrypt With Password”
Step 5) Remove the password which you added
Step 6) Click on “OK”
Step 7) Save the document

By following the above methods we can put passwords for excel sheets and word documents. We can secure our data easily by putting the passwords for excel sheets and word documents.


EmoticonEmoticon