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:
- Select locked cells : Select locked cells
- Select unlocked cells : Select the 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 automatic filters
- Use PivotTable & PivotChart : Use PivotTable & PivotChart
- Edit objects : Edit the object
- 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!
You should read it
- How to create a password protection for Excel sheets
- How to hide and hide sheets in Excel and show them again
- How to display sheet tabs in Excel
- How to hide the Sheet Tabs (sheet bar) in Excel
- How to Unprotect an Excel Sheet
- How to hide and show Sheet in Excel
- Recover deleted Sheet in Excel
- Show Sheet Tab in Excel when hidden
- Shortcut switch Sheet in Excel
- How to separate sheets into separate Excel files
- How to Unprotect Excel Sheet
- How to copy sheet from Excel file to another Excel file
Maybe you are interested
Set location in Google Sheets
Parentheses in Google Sheets
Excel 2016 - Lesson 12: Formatting pages and printing spreadsheets in Excel
Here's What to Do Before Sharing an Excel Spreadsheet
Tips for formatting cells in Excel for professional spreadsheets
Google Sheets Functions to Simplify Your Budget Spreadsheets