How to lock Excel files from editing

You want to send an Excel file that can only be read by the recipient and cannot change the data information in the file. In this article, TipsMake.com would like to show you how to lock Excel files from editing correctly.

You want to send an Excel file that can only be read by the recipient and cannot change the data information in the file. In this article, TipsMake.com would like to show you how to lock Excel files from editing correctly.

How to lock Excel files from editing Picture 1How to lock Excel files from editing Picture 1

Method 1: Set a password for a certain Sheet in Excel file

Step 1 : You open the Excel file and go to the Sheet page to be secured:

(1) Right-click on a sheet cell.

(2) Select Protect Sheet.

How to lock Excel files from editing Picture 2How to lock Excel files from editing Picture 2

Step 2 : Enter the security password and click OK .

How to lock Excel files from editing Picture 3How to lock Excel files from editing Picture 3

Step 3 : Confirm the password again. Then click OK.

How to lock Excel files from editing Picture 4How to lock Excel files from editing Picture 4

Step 4 : Then you can see the tools are all gray. You cannot edit any parameters or data on this Sheet without a password.

How to lock Excel files from editing Picture 5How to lock Excel files from editing Picture 5

To be able to edit this sheet, you put your cursor in the sheet cell then click the mouse to select Unprotect Sheet .

How to lock Excel files from editing Picture 6How to lock Excel files from editing Picture 6

For how to lock this sheet page, you can edit the Excel file if there is something wrong. However, there are many ways to break the security code, from there, you can still edit Excel files.

To face that phenomenon, we can install the entire Excel file into Read-only mode through method 2.

Method 2: Set Readonly mode for Excel file

Step 1 : You open the Excel file you want to change the mode. Select File on the toolbar.

How to lock Excel files from editing Picture 7How to lock Excel files from editing Picture 7

Step 2 : Then you select Save As and double-click select This PC .

How to lock Excel files from editing Picture 8How to lock Excel files from editing Picture 8

Step 3 : Click the Tools sectionin the right corner of the window, then select General Options .

How to lock Excel files from editing Picture 9How to lock Excel files from editing Picture 9

Step 4 : Check the Read-only recommended line and select OK .

How to lock Excel files from editing Picture 10How to lock Excel files from editing Picture 10

Step 5 : Go back to the Save As window, select a location to save the file, name the file and then select Save .

How to lock Excel files from editing Picture 11How to lock Excel files from editing Picture 11

Thank you for watching the article!

5 ★ | 1 Vote