Buzz
Locking Data Sheets with a Password in Excel to Ensure Data Security for Your Files, Preventing Unauthorized Editing or Adding Data. Let Mytour Guide You through the Process in Our Article Below.
To lock a sheet in Excel, right-click on the name of the sheet located in the bottom-left corner of the Excel interface.
After the options menu appears, click on the Protect Sheet line.
The Protect Sheet function window will appear for you to configure functions related to password locking.
Enter the password to lock the Excel sheet into the Password to unprotect sheet box. Remember to keep this password secure as forgetting it means you won't be able to retrieve or restore it.
The checkboxes in the Protect Sheet options table are:
- Select locked cells: Choose locked cells
- Select unlocked cells: Choose unlocked cells
- Format cells: Format cells
- Format columns: Format columns
- Format rows: Format rows
- Insert columns: Insert columns
- Insert rows: Insert rows
- Insert hyperlinks: Insert hyperlinks
- Delete columns: Delete columns
- Delete rows: Delete rows
- Sort: Sort
- Use AutoFilter: Use AutoFilter
- Use PivotTable & PivotChart: Use PivotTable & PivotChart
- Edit objects: Edit objects
- Edit scenarios: Edit scenarios
The default options Select locked cells and Select unlocked cells provide security by preventing editing on locked sheets and allowing you to unlock sheets later with a password if needed.
Excel will prompt you to re-enter the password to ensure accuracy. Click OK to confirm the settings.
After creating a password to lock an Excel sheet, remember to save the file again to confirm all changes made.
Currently, if you try to enter data into a locked Excel file, you will receive a notification that you cannot change the content of that data sheet.
While other sheets without passwords can still be edited as usual.
To modify the content of a locked data sheet, you need to unlock that data sheet first.
Right-click on the name of the sheet you want to unlock. The options menu will appear, and you should click on the Unprotect Sheet line.
Enter the correct password into the Password field to unlock the locked sheet.
You can now modify the content on the unlocked data sheet.
Thank you for reading our article on locking Excel sheets and setting passwords by Mytour. We wish you success in implementing these steps!
