How to Protect the Files in Excel
This prevents other users from accessing data in your Excel files. Users can able to open the file if he/ she has a valid password. Users cannot even view the file without a password.
Step 1: Click on the file option.
Step 2: Select on info option on the left side menu bar.
Step 3: Click on protect workbook option.
Step 4: Now select the option Encrypt with password as shown:
Step 5: Create a password and enter it on encrypt document dialog box.
Step 6: Reenter the password
Step 7: Then click on ok.
Now your file is protected with a password. Whenever other users want to open it, it will ask for a password first then only it will open.
These are some ways you can protect your sheet from other users.
How to Protect Sheet in Excel
Protect Sheet in Excel with Password- Quick Steps
Step 1: Right Click on the Worksheet Tab
Step 2: Select Protect Sheet
Step 3: Enter Password
Step 4: Select the Actions you want to allow the Users
Step 5: Click Ok
When sharing an Excel file with others, it’s often important to protect a worksheet to prevent unauthorized changes. In this article, you’ll learn how to protect a sheet with a password in Excel, as well as how to unprotect it when needed.