Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
Register  \/ 


Manage Excel workbook passwords used to open files for combining and conversion

In Excel, if you do not want other users to open your workbooks, you can set an opening password to prevent others opening workbooks. However, it will be quite troublesome to enter opening passwords time after time when you need to open multiple such password protected workbooks, says open multiple workbooks and combine, etc. Here, Kutools for Excel provides a useful auxiliary utility, Password Manager, which supports recording and editing workbook passwords, and helps open those password protected workbooks directly when applying Combine Worksheets and File Format Converter utilities.

Applying Password Manager by clicking Kutools Plus > Password Manager.
shot password manager 1

1. Click Kutools Plus > Password Manager to enable the Password Manager dialog.

2. Click Add button shot password manager 2 to display the Kutools for Excel dialog, then type the password into Password textbox, you can click the eye button shot password manager 3 to view the password you typing. Then in the Label textbox, enter the workbook name or other descriptions which help you know which workbook this password is about.
shot password manager 4

3. Click Ok to go back to the main dialog, you can see all passwords you added have been list.
shot password manager 5

Detail Notes:

shot password manager 6: Select a password, and then click this button. In the popping Kutools for Excel dialog, edit the existed password.

shot password manager 7: Select a password, then click this button. Then you can paste this password to other places, supposing worksheet cell, Word document with pressing Ctrl + V keys.

shot password manager 8: Select a password, then click this button to remove it.

shot password manager 9: Check the Show Password checkbox, then the password in the list have been displayed.
shot password manager 10

shot password manager 11: Click Up or Down button to move the selected password.

shot password manager 12: Click this Master password button, you can set a password to protect all passwords you list in this dialog.
shot password manager 13

After setting this master password, you need to type this password while you applying the Password Manager utility each time, or you cannot enter Password Manager’s main dialog.
shot password manager 14

Take attention, if you forget the master password, you can click Remove button to remove the master password, but at the same time, you will lose all added password in Password Manager.
shot password manager 15


If you use the Combine utility of Kutools for Excel to merge some password protected workbooks, you can add the opening passwords into the Password Manager firstly, then apply the Combine utility, the protected workbooks also can be merged successfully. Or you can click Password button in the Combine Worksheets dialog to add opening password directly.
shot password manager 16

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.