Friday, July 11, 2014

How to set password in Microsoft excel file at open file in your computer

Posted by jaysukh Patel
Done added

This time security is requiring losing data and cheating by unknown people. So one of them is set password in your Microsoft excel file. So in this tutorial I try to set maximum option to make your excel file secure and password protected. In previously I share on how to recover data in Microsoft office document file from unexpected close.

Useful: Set minimum auto save time in Microsoft office document.
Save your word file in PDF format directly without any software.

Here you can saved your excel data in two different ways gives In below, Total secure and partial security

Access password: Set password to open file in your computer
Read only security: Make your file read only

Password set in excel file to protect data
Password set in excel file to protect data
Set password to open your Microsoft excel file
Below step you have to follow for open file in secure way. To open file you must have to enter password.

Step 1
Click on review from the top tab,
Go review > Protect Workbook > Protect structure and windows
Enter password that you have to enter open excel file.
Set password to open Excel file from windows device
Set password to open Excel file from windows device
Re-enter same password for verification match

Re enter password for open excel file
Re enter password for open excel file
Step 2
Click on office button (from top left corner of the screen),
Go, office button > Prepare > Encrypt document
Enter password same that entered in step 1
Make your excel file more secure with encrypt document option
Make your excel file more secure with encrypt document option
- Enter password second time for verification.
Set password for encrypt excel doc
Set password for encrypt excel doc

Set password for read only access

Steps to Make your file read only: To edit or change password require to do so follow the below steps.

Step 1
Go review > Protect Sheet
After that you can see dial box with multiple options, From there you have to enter password which you want to set,
Set password in Excel to protect data
Set password in Excel to protect data
Reenter password dialog box to verify password.
Re enter password to set password in Excel
Re enter password to set password in Excel

Above security protect your data, no one can add and delete data from your Microsoft office excel file.
Excel protected with editing in file
Excel protected with editing in file
Related search,
Make excel sheet password protected,
How to hide data in excel from unknown users

Don't miss: Convert Gmail email in PDF format directly.

If you like this how to guide, Don’t miss to share with your friends. You have any problem related to this article than comment in below comment box.

0 comments:

Post a Comment