How To Set Password In Excel File
If you feel the current password for your Excel workbook isn't secure enough, or if you think the password is unnecessary, y'all tin can modify or completely remove it. However, the steps are a flake different betwixt Windows and Mac.
Change or Remove an Excel Workbook Password on Windows
To modify or remove the password of an Excel workbook, you're going to need to know the current password in order to open the document to brainstorm with. Go ahead and open the workbook and enter the countersign.
Once y'all've opened the workbook, click the "File" tab.
Next, click "Info" in the left-manus pane.
On the Info screen, click "Protect Workbook" to show a drop-down card.
Now click the "Encrypt with Password" option near the acme of the carte du jour.
The Encrypt Document dialog box will appear. To change the password, type the new password in the text box and then click "OK." Or, to remove the password, delete the password in the textbox, leave the textbox blank, and so click "OK."
If you lot removed the password, and then all you demand to practise now is save your workbook. If you changed the password, y'all'll be asked to confirm the new password. In that case, retype the password in the text box and then click "OK" to ostend.
Exist certain to save your workbook afterwards changing or deleting the password.
If y'all've unlocked your workbook but withal want certain parts to exist difficult to change, don't forget that you can hide tabs in Excel.
RELATED: How to Hide Worksheets/Tabs and Entire Workbooks in Excel
Change or Remove an Excel Workbook Password on Mac
You can change or remove a password from an Excel workbook on Mac, as well. To do and so, you'll need the current countersign of the workbook.
Open the workbook and then click "File" in the desktop's card bar.
Next, click "Passwords" nigh the bottom of the driblet-downward menu.
The File Passwords dialog box will appear. To remove the passwords, delete the passwords from each text box, leave each box blank, and then click "OK." To change the passwords, enter the new password in each text box and and so click "OK."
If you removed the passwords, all that's left to practise is save the workbook. If y'all changed the countersign, yous'll be asked to ostend the new passwords. Enter the new countersign in the text box for each option (a divide dialog box will appear for each option) and so click "OK."
Exist certain to salvage after removing or changing the countersign.
If you removed the password, anyone tin access the workbook. If you changed the password, you'll need to give the new password to every recipient of the workbook. Worried about a sure role being edited? You can even lock specific cells while allowing other parts of the workbook to be modified.
RELATED: How to Lock Cells in Microsoft Excel to Forestall Editing
The above article may incorporate chapter links, which aid support How-To Geek.
How To Set Password In Excel File,
Source: https://www.howtogeek.com/762434/how-to-change-or-remove-a-workbook-password-in-excel/
Posted by: chamberssoored1961.blogspot.com
0 Response to "How To Set Password In Excel File"
Post a Comment