Sunday, March 22, 2020

How to protect your Excel Book Using a Password


There might be some situations come when you need to lock your Excel file. Think of a situation, suppose someone has control over your PC and you have some important data in an Excel file on that PC.

Well, in that situation, there might be some potential risk of losing your important data or risk of alteration and modification of data values.

But, you need not to worry at all, MS-Excel has a built-in option to lock your Excel file which can secure your data.

For that, Go to File menu then select Save As option and from there click on Tools just beside the Save button. Select General Options and type the password for Read-only mode and also put a password for permission to modify the data of that file. 

Finally, reenter both passwords and click OK. And, finally, click the Save button and see the magic! 


Your Excel WorkBook is locked now and only you can get access to this file by entering the passwords. 


Isn’t it easy! So, for securing your important data in Excel file always lock your file by following the above-mentioned steps. 


Here, I am providing some screenshots for better understanding. Have a look at the screenshots sequence and it will clear all your confusions.

(DEMO EXCEL BOOK)
































(PASSWORD PROTECTED EXCEL BOOK)

That’s all for today. Thanks for staying with tutorialabc

No comments:

Post a Comment