In the Advanced Attributes dialog box, select the 'Encrypt contents to secure data' checkbox and click 'OK'.Įnter and confirm your desired password, then click 'OK' again. In the Properties window, go to the 'General' tab and click on the 'Advanced' button. Right-click on the folder and select 'Properties'. To do this, open the folder that contains your workbooks in File Explorer.

If you're using Microsoft Office 365 or Excel 2016, you can take advantage of Microsoft's built-in security features to protect your workbooks. Using Microsoft's Built-In Security Features Your workbooks are now protected with a password.

Enter and confirm your desired password, then click 'OK'. Select the folder that contains your workbooks, then click on 'Lock this Folder'. Then, launch the program and click on 'Lock Folders'. To use Folder Lock, first download and install the software on your computer. One example of such software is Folder Lock, which allows you to lock and encrypt files and folders on your computer with a password. Using Third-Party SoftwareĪnother option for protecting an entire folder of workbooks is to use third-party software that offers folder protection. Next, open the newly created zip file and click on 'File > Add a Password'. This will create a new zip file with all of your selected workbooks inside. Then, right-click on them and select 'Send To > Compressed (zipped) Folder'.

To create a password-protected zip file in Windows, first select all of the workbooks that you want to include in the zip file. This way, you only have to remember one password instead of multiple passwords for each individual workbook. If you have a lot of workbooks that you need to protect, one option is to put them all into a password-protected zip file. And yet another way is to use Microsoft's built-in security features. Another way is to use a third-party software program that offers folder protection. One way is to use a password-protected zip file. There are a few different ways that you can protect an entire folder of workbooks in Excel.

How to make an excel password protected