

The second way to set a password is not harder than the first one. It can be hacked literally in a matter of seconds. Keep in mind, that book, pages and VBA macros protection are not secure in all Excel versions. You can also use “Info” menu to set the password protection for the book and file pages. It’s the most reliable way of protection, since it’s the hardest to hack.

You’ve just protected your file from opening by encrypting its content with a password.

This way you’ll ensure there are no mistakes in your password. When you finished working with your document.Īs the new window appears, enter your password in it, press OK and enter it one more time. They’re not evident though, but fairly easy. There’re two ways of setting a password on an Excel file. How to set, remove and recover a password to open a file in Excel 2010-2016 Setting a password on an Excel 2007-2019 file Don’t like wasting time? Watch this 2-minute video right now.
