How to lock Excel Sheet, set a password for the sheet in Excel

Lock Sheet, set password for Data Sheet in Excel to create security for your data file, do not let anyone edit or add data. TipsMake.com will guide you how to do in our article below.

To lock an Excel sheet, right-click the sheet's name in the lower left corner of the Excel interface.

After the options panel is displayed, click on the Protect Sheet row .

The Protect Sheet function window will appear so you can set up the surrounding functions related to locking the sheet password.

Enter the password to lock the Excel sheet into the Password to unprotect sheet box . You need to remember this password because if you forget then you will have no way to find or recover.

The checkmarks selected in the Protect Sheet options panel are:

1. Select locked cells : Select locked cells
2. Select unlocked cells : Select the unlocked cells
3. Format cells : Format cells
4. Format columns : Format columns
5. Format rows : Format rows
6. Insert columns : Insert columns
7. Insert rows : Insert rows
8. Insert hyperlinks : Insert hyperlinks
9. Delete columns : Delete columns
10. Delete rows : Delete rows
11. Sort : Sort
12. Use AutoFilter : Use automatic filters
13. Use PivotTable & PivotChart : Use PivotTable & PivotChart
14. Edit objects : Edit the object
15. Edit scenarios : Edit scenarios

With two default options, Select locked cells and Select unlocked cells will help you create a security that does not allow editing with locked sheets and also allows you to unlock later sheets with a password if necessary.

Excel will need you to enter the password again to make sure there is no mistake in the first time typing the mistake. Click OK to confirm the settings.

After creating the password for Excel sheet key, you must remember to save the file again to confirm all changes made to your Excel file.

Currently, if you try to import data into a locked Excel file, you will receive a notice that you cannot change the content of that data sheet.

While other sheets do not have a password, you can still change its contents as usual.

To change the contents of a locked data sheet, you need to unlock the data sheet.

Right-click on the sheet name to unlock. The options panel has just shown up and you click on the Unprotect Sheet row .

Enter the correct password in the Password to unlock the locked sheet.

Currently you can change the content in the newly unlocked Data Sheet.

Thank you for reading our article on how to lock Excel sheet, set password for Excel sheet of TipsMake.com us. Wish you can do it successfully!