WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to lock excel file from editing

July 25, 2022
3.9K Views

Do you have confidential information that you do not want other people to be able to change? If this is the case, you will need to be familiar with the process of protecting Excel files from being edited. This could be a very crucial step in the process of preserving the safety of your data. In the following paragraphs, we will demonstrate how to carry out the task. It is a fairly straightforward process that can be completed in just a few minutes. Don't put it off any longer; start putting these steps into action right away! 

How to Lock Excel File from Editing?

1.Take this table as an example. We click Menu and select Options in the drop-down list.

2.A dialogue box will pop up. Click Security, where we can find File encryption options for this workbook and File sharing options for this workbook.

 

3.Once you choose the security option and you want to encrypt the entire table, enter the password in the Document password edit box.

Password retrieval is not possible so be careful while choosing the password.

In first option choose the password wisely and then repeat the same password in second box and third box is for the hint you have to set for your memory so that the you can remember the password. Once you enter the password and set the hint then click ok and enjoy the security of your file.

How to lock excel file from Editing: Can be edit with Password?

1.Take this table as an example. We click Menu and select Options in the drop-down list.

2.A dialogue box will pop up. Click Security, where we can find File encryption options for this workbook and File sharing options for this workbook.

 

3.Once you choose the security option and you want to encrypt the entire table, enter the password in the Document password edit box. Once you enter the password then repeat the same password and click ok your excel file is locked and protected with password that anyone who have the password can only edit the file.

How to lock excel file from Editing can be allowed to read?

1.Take this table as an example. We click Menu and select Options in the drop-down list.

2.A dialogue box will pop up. Click Security, where we can find File encryption options for this workbook and File sharing options for this workbook.

 

3.Once you choose the security option and you want to encrypt the entire table, enter the password in the Document password edit box.

Password retrieval is not possible so be careful while choosing the password.

In first option choose the password wisely and then repeat the same password in second box and third box is for the hint you have to set for your memory so that the you can remember the password. Once you enter the password and set the hint then click ok and enjoy the security of your file.

Now as you have chosen the password now select the read only option and click ok now your file can only be readied.

It is explained in this article how to lock Excel file from editing. At the WPS Academy's website, you may find out more about the WPS office. There is also a free version of WPS Office that anyone may download and use to edit Word, Excel, and PowerPoint documents. Only individuals who come to this page will be able to take advantage of this offer.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.