How to password protect an excel file but allow read only
A free Office suite fully compatible with Microsoft Office
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 :
Click on the Menu tab in the top left corner of Excel, then choose Save as.
Encrypting the file
Choose the Encrypt” option while saving
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.
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
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
Now after this whenever anyone to whom you send this file online has to enter the password you assigned to open
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
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to add text to beginning or end of all cells in Excel
- 5. How to color cell based on value in Excel?
- 6. How to compare two excel sheets and highlight differences