How to Lock an Excel File with a Password
(Using Save As)
Protecting your Excel file with a
password helps keep your data safe from unauthorized access. Microsoft Excel
provides a built-in option to add a password at the time of saving the file.
Follow the steps below to secure your Excel workbook easily.
Steps to Set a Password in Excel
1. Open the Excel File
Open the Excel workbook you want to protect.
2. Click on “File” Menu
From
the top menu, click on File and select **Save As**.
3. Choose Save Location
Select the folder where you want to save the file.
4. Open Tools Menu
In the Save As dialog box, look
at the bottom and click on **Tools**.
5. Select General Options
From the Tools dropdown, choose
**General Options**.
6. Enter Your Password
* Enter a password in **Password to open** (to prevent opening the
file), or
* Enter a password in **Password to modify** (to restrict editing).
7. Confirm the Password**
Re-enter the password when prompted and click **OK**.
8. Save the File
Click **Save**. Your Excel file is now protected with a password.
How to Remove the Password from an Excel File
If you no longer want password
protection, you can remove it by repeating the same process.
Steps to Remove Password Protection
1. Open the Password-Protected File
Enter the existing password to open the file.
2. Go to File → Save As
Click File, then select **Save
As**.
3. **Click on Tools**
In the Save As window, click **Tools** at the bottom.
4. Select General Options
Choose **General Options** from the list.
5. Remove the Password
* Delete the text from **Password to open** and/or
* Delete the text from **Password to modify**.
6. **Click OK and Save**
Click **OK**, then **Save** the file.
Your Excel file is now **no
longer protected by a password**.
SCAN HERE
Comments