How to lock & protect Excel workbook from editing

Excel spreadsheets are widely used for online collaboration in companies big and small, especially since the release of the latest version. For example, if you want to share an Excel file so that multiple users can work on it simultaneously, the 365 version includes powerful co-authoring features to collaborate online. However, let’s say that you only want certain parts to be editable because there are complex formulae or reference cells that should not be modified. This is where knowing how to lock specific cells in Excel comes in handy – all users will be able to view all data but can only edit specific parts.

In this article, you’ll learn how to lock an Excel spreadsheet from editing according to the level of protection you’d like to apply. There are 5 different protection methods, including “Mark as Final”, protecting it with a password with a read-only status, and protecting specific cells. If you’d rather share only part of the data, Sheetgo, an AI-powered data automation platform, can transfer filtered Excel data to another workbook and keep that copy updated automatically.

How to protect an Excel workbook from editing?

One of the great advantages of using Excel spreadsheets is that it offers different layers of protection and different ways to do so. Here, you’ll learn how to protect an Excel workbook using 5 quick and efficient methods.

Protect an Excel workbook from editing by using Mark as Final

The “Mark As Final” is a protection feature for your whole workbook. This is how you can protect an Excel workbook from editing by others.

1. Open the Excel file you’d like to “Mark As Final”. Go to File > Info > Protect Workbook > Mark as Final.

How to lock Excel file — Protect Workbook menu on the Info screen with Mark as Final highlighted

2. Click “OK” to save with that status.

How to lock Excel file — Excel dialog saying the workbook will be marked as final and saved

3. Excel reminds you about the “Mark As Final” status and how to know if a file has been set to “Final” by checking the status bar, located at the bottom. Click “OK” to continue.

How to lock Excel file — Excel notice that the document has been marked as final, over the client list

4. Check the status by reopening the file. Excel should now prompt you with the following warning message. To edit, you simply need to click on “Edit Anyway”.

How to lock Excel file — Marked as Final bar above the spreadsheet with the Edit Anyway button

As you can see, more than a full protection measure, it’s a warning for other users to avoid editing since you can easily remove the “Mark As Final” status by clicking on “Edit Anyway”, as shown above. If you want to protect your workbook from editing completely, then you will have to protect it with a password.

Protect an Excel workbook from editing with a password

If you encrypt your Excel Workbook with a password, you’re restricting others from opening the file. Unless you provide them with the password, they won’t be able to view or edit the data.

1. Open your Excel file and go to File > Info > Protect Workbook > Encrypt with Password.

Lock an Excel file with a password — Encrypt with Password highlighted in the Protect Workbook menu

2. Enter the password and click “OK” to save. Make sure that you read Microsoft’s “Caution” message about passwords.

Lock an Excel file with a password — Encrypt Document dialog with a password typed in above the Caution note

3. Re-enter the password to confirm. Click “OK”.

Lock an Excel file with a password — Confirm Password dialog asking to reenter the password

4. To check that this method worked, reopen your workbook. Excel should automatically prompt a message to enter a password.

Lock an Excel file with a password — Password prompt saying CLIENTS 2023.xlsx is protected

Check out how to password-protect an Excel file to gain a more in-depth understanding of how protection works in Excel. Once your file is password-protected, you might be interested in learning how to remove a password from Excel.

If you want to try out more advanced methods of protecting and unprotecting your file, read protect and unprotect a sheet in Excel, which illustrates how it can be done using the Visual Basic for Applications (VBA) feature.

Protect an Excel workbook from editing but allow read-only

Allowing other users to open as “Read-Only” is a weaker level of protection since any user can still open the file and enable editing themselves. However, just like “Mark As Final”, it can serve as a precautionary measure for your team to be more careful when editing.

1. Open the Excel workbook you’d like to protect with “read-only” and head over to File > Info > Protect Workbook > Always Open Read-Only.

Open an Excel file as read-only — Always Open Read-Only highlighted in the Protect Workbook menu

2. Any user who tries to open the file will get the following warning message. To continue editing, simply click on “Edit Anyway”.

Open an Excel file as read-only — Read-Only bar above the spreadsheet with the Edit Anyway button

As you’ve seen, you simply need to click on “Edit Anyway” to be able to make changes. However, it’s useful to learn how to remove this feature as there may be other reasons why you may want to remove read-only from Excel.

Protect the structure of an Excel workbook from editing

Protecting the structure of your workbook will restrict others from deleting current sheets or adding new ones; in other words, it restricts others from using structural commands. This is how you can protect your Excel workbook from structural edits.

1. Go to File > Info > Protect Workbook > Protect Workbook Structure.

Lock an Excel workbook structure — Protect Workbook Structure highlighted in the Protect Workbook menu

2. Enter a password and click “OK”.

Lock an Excel workbook structure — Protect Structure and Windows dialog with a password and Structure checked

3. Confirm the password by entering again. Click “OK” to finish.

Lock an Excel workbook structure — Confirm Password dialog over the client spreadsheet

4. Double-click on a sheet name to rename, and Excel should prompt you with the following message.

Lock an Excel workbook structure — Excel warning that the workbook is protected and cannot be changed

After applying this option, anyone can open your Excel document, but they can’t access its structural commands, including adding a sheet, changing the name, or deleting any existing sheets.

Protect specific cells in an Excel workbook from editing

To protect specific cells, you will need to protect the sheet. This is how to protect an Excel sheet from editing and copying specific cells.

1. Select the cell range you want to lock from editing. Right-click on the selected range and then click on “Format Cells” from the drop-down menu.

Lock cells in Excel — right-click menu on the selected Loan Amount column with Format Cells highlighted

2. Go to the “Protection” tab and check the box next to the “Locked” option. As Microsoft warns you, you’ll need to protect the sheet so this has an effect. Click “OK” to proceed.

Lock cells in Excel — Protection tab of the Format Cells dialog with the Locked box checked

3. Go to the “Review” tab and click on “Protect Sheet”.

Lock cells in Excel — Protect Sheet button on the Review tab with the Loan Amount column selected

4. Enter the password and make sure the option “Protect worksheet and contents of locked cells” is enabled. Click “OK”.

Lock cells in Excel — Protect Sheet dialog with a password and Protect worksheet and contents of locked cells checked

5. Re-enter the password to confirm and click “OK” to finish.

Lock cells in Excel — Confirm Password dialog asking to reenter the password to proceed

Conclusion

As users become more specialized in their use of spreadsheets, so do the features of these types of applications. Excel is used by many to store key information that may be linked to external sources using complex formulae. In these cases, an accidental edit to a sheet or cell can have major consequences. Thankfully, there are many ways to protect an Excel workbook.

You should now know how to protect your Excel workbook from editing using 5 different methods. For more in-depth information on Excel protection, take a look at our related blog posts:

If someone has already changed a file you meant to lock, you can restore a previous version of the Excel file. Working in Google Sheets instead? Here’s how to protect cells or pages in Google Sheets.

You may also like…

Excel version control — stacked XLS file icon in teal on a dark navy background

The beginner’s guide to Excel version control

Discover what Excel version control is, the version control features Excel has to offer, and how to use them to share, merge, and review Excel changes.

How to remove password protection from Excel — Excel icon next to a padlock with a masked password on a light blue background

How to remove a password from Excel (multiple methods)

Learn how to remove password protection from Excel: unlock a file or a sheet when you know the password, and what to try if you’ve forgotten it.

Excel reference another sheet — two Excel logos joined by a chain link on a light blue background

How to reference another sheet or workbook in Excel?

Learn the Excel reference another sheet formula and how to pull a cell, a range, or whole columns from another worksheet or another workbook.