How to password protect an excel file but allow read only

July 22, 2022
12.3K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

Password protection is important for any type of spreadsheet.  Protecting a Word document is easy. What about Password protecting Excel? Not so much. Password Protecting an Excel workbook is actually quite simple and easy to do.

 Creating a password-protected excel file is straightforward.  This post will help you get your hands on the best method for securing your excel sheets with passwords. Let’s dive in, but before that’s let us explain why password protecting your excel file is important

How to password protect an excel file

You can password protect an Excel worksheet with a simple click of a button. This is especially useful if you have multiple people working on your spreadsheet and you want to keep it away from them, without wasting any further time let’s dive deep into how to protect an excel file

This method works best with versions 2010/2013/2016.

Saving the file :

  1. Click on the Menu tab in the top left corner of Excel, then choose Save as.

Encrypting the file

  1. Choose the Encrypt” option while saving

  1. Under the security tab, your password in the box that appears below it, re-enter to confirm that password. Choose OK when done entering it.

  1. Click on the ok button at the bottom of the window, then go back to the original excel file, and there you will see a lock icon next to each cell that has been secured by a password

Additional Security

  1. Furthermore, you can also check the read-only, this is a very handy option while working online because it makes the content of your worksheet, noneditable for your colleagues working with

  2. Now after this whenever anyone to whom you send this file online has to enter the password you assigned to open

  3. Now you have learned how to successfully password protect an excel file

Note: Always use a password that you will not forget because there is no way of recovering a forgotten password

How to remove Password protect from excel file

If you want to remove password protect from excel file then follow the steps given below.

1: First of all go to the location where you want to open your excel file and click on the save as option

2: Now click the encrypt option, here you will see the password of your file ,remove that password.

3: Now click on “save” button and now it will be opened as normal excel document without any password protection on it.

How to password protect single sheet in excel

Sometimes instead of password protecting the whole worksheet ,you want to protect only one sheet ,here’s how you can do this

1.Open your work sheet

2.Under the review tab click “Protect sheet”

3. Lock this sheet with the password of your choice

Did you learn about how to password protect an Excel file? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets and PowerPoint Slides.

You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience