Manage Excel workbook passwords used to open files for combining and conversion
Kutools for Excel
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.Demo
Applying Password Manager by clicking Kutools Plus > Password Manager.
1. Click Kutools Plus > Password Manager to enable the Password Manager dialog.
2. Click Add button to display the Kutools for Excel dialog, then type the password into Password textbox, you can click the eye button 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.
3. Click Ok to go back to the main dialog, you can see all passwords you added have been list.
: Select a password, and then click this button. In the popping Kutools for Excel dialog, edit the existed password.
: 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.
: Select a password, then click this button to remove it.
: Check the Show Password checkbox, then the password in the list have been displayed.
: Click Up or Down button to move the selected password.
: Click this Master password button, you can set a password to protect all passwords you list in this dialog.
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.
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.
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.
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.
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.