How to Lock Excel Files from Editing

This guide explains how to lock Excel Files from Editing, with clear steps, practical tips, and important checks before you begin.

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.

Step 2 : Enter the security password and click OK .

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

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

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

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.

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

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

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

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

Thank you for watching the article!