Read Time:8 minѕLanguageѕ:url-ѕeleᴄtor#ѕeleᴄtionChanged" data-ᴄontroller="url-ѕeleᴄtor">EngliѕhEѕpañolBahaѕa IndoneѕiaМакедонски јазикPусскийукраїнська моваTiếng ViệtWhen it ᴄomeѕ time to ѕend уour Eхᴄel ѕpreadѕheet, it"ѕ important to proteᴄt the data that уou"re ѕharing, You might ᴡant to ѕhare уour data, but that doeѕn"t mean it ѕhould be ᴄhanged bу ѕomeone elѕe" /> Read Time:8 minѕLanguageѕ:url-ѕeleᴄtor#ѕeleᴄtionChanged" data-ᴄontroller="url-ѕeleᴄtor">EngliѕhEѕpañolBahaѕa IndoneѕiaМакедонски јазикPусскийукраїнська моваTiếng ViệtWhen it ᴄomeѕ time to ѕend уour Eхᴄel ѕpreadѕheet, it"ѕ important to proteᴄt the data that уou"re ѕharing, You might ᴡant to ѕhare уour data, but that doeѕn"t mean it ѕhould be ᴄhanged bу ѕomeone elѕe" />

Protect a worksheet

post-promotion-placement#checkSidebarAdDisplayCondition" data-controller="sticky-ad post-promotion-placement">
Read Time:8 minsLanguages:url-selector#selectionChanged" data-controller="url-selector">EnglishEspañolBahasa IndonesiaМакедонски јазикPусскийукраїнська моваTiếng Việt

When it comes time to send your Excel spreadsheet, it"s important khổng lồ protect the data that you"re sharing. You might want to nội dung your data, but that doesn"t mean it should be changed by someone else.

Bạn đang xem: Protect a worksheet

Spreadsheets often contain essential data that shouldn"t be modified or removed by the recipient. Luckily, Excel has built-in features to lớn protect your spreadsheets.

In this tutorial, I"ll help you make sure that your Excel workbooks maintain data integrity. Here are three key techniques you"ll learn in this tutorial:

Password protect entire workbooks to lớn prevent them from being opened by unauthorized users.Protect individual sheets and the workbook structureto prevent the insertion or deletion of sheets in the workbook.Protect cells, khổng lồ specifically allow or disallow changes to key cells or formulas in your Excel spreadsheets.

Even users with the best intentions may accidentally break an important or complex formula. The best thing to vì chưng is remove the option to lớn change your spreadsheets altogether.

How to lớn Protect Excel: Cells, Sheets, và Workbooks (Watch và Learn)

In the screencast below, you"ll see me work through several important types of protection in Excel. We"ll protect an entire workbook, a single spreadsheet, and more.


*


Want a step-by-step walkthrough? check out my steps below to lớn find out how to lớn use these techniques. You"ll learn how lớn protect your workbook in Excel, as well as protecting individual worksheets, cells, and how to work with advanced settings. 

We start with broader worksheet protections, then work down lớn narrower targeted protections you can apply in Excel. Let"s get started learning how to protect your spreadsheet data:

1. Password Protect an Excel Workbook File

Let"s start off by protecting an entire Excel file (or workbook) with a password khổng lồ prevent others from opening it.

This is a breeze to lớn do. While working in Excel, navigate to the File tab choose the Info tab. Click on the Protect Workbook dropdown option & choose Encrypt with Password.

As is the case with any password, choose a strong & secure combination of letters, numbers, và characters, bearing in mind that passwords are case-sensitive.

*
Browse khổng lồ the tệp tin > Info tab, & choose Protect Workbook > Encrypt with password.

It"s important to cảnh báo that Microsoft has really beefed up the seriousness of their password protection in Excel. In prior versions, there were easy workarounds to bypass password protection of Excel workbooks, but not in newer versions.

*
Set a complex password for security"s sake, but make sure to lớn store it safely.

In Excel 2013 và beyond, the password implementation will prevent these traditional methods to lớn bypass it. Make sure that you store your passwords carefully và safely or you risk permanently losing access khổng lồ your crucial workbooks.

Excel Workbook - Mark as Final

If you want khổng lồ be a bit less forceful with your spreadsheets, consider using the Mark as Final feature. When you mark an Excel tệp tin as the final version, it switches the tệp tin to read-only mode, and the user will have lớn re-enable editing.

To change a tệp tin to read-only mode, return lớn the File > Info button, and click on Protect Workbook again. Click on Mark as Final and confirm that you want khổng lồ mark the document as a final version.

*
Mark a file as the final version lớn leave a gentle warning for users of that file. 

Marking a file as the final version will add a soft warning to lớn the đứng đầu of the file. Anyone who opens the tệp tin after it has been marked as final will see a notice, warning them that the file is finalized. 

*
*
*
When a tệp tin is marked as the final version, the workbook will show this

Marking a tệp tin as the final version is a less formal way of signaling that a file shouldn"t be changed further. The recipient still has the ability to click Edit Anyway and modify the spreadsheet. Marking a tệp tin as the final edition is more lượt thích a suggestion, but it"s a great approach if you trust the other file users.

2. Password Protect Your Excel Sheet Structure

Next up, let"s learn how khổng lồ protect the structure of an Excel workbook. This option will ensure that no sheets are deleted, added, or re-arranged inside of the workbook.

If you want everyone to be able to access the workbook, but limit the changes they can make to lớn a file, this is a great start. This protects the structure of the workbook, and limits how the user can change the sheets inside of it.

To turn on this protection, go lớn the Review tab on Excel"s ribbon & click on Protect Workbook.

Xem thêm:

*
*
*
Find the reviews tab, click on Protect Workbook, and set a password lớn protect the structure of your Excel workbook.

Once this option is turned on, the following will go into effect:

No new sheets can be added khổng lồ the workbook.No sheets can be deleted from the workbook.Sheets can no longer be hidden or unhidden from the user"s view.The user can no longer drag and drop the sheet tabs to reorder them in the workbook.

Of course, trusted users can be given the password lớn unprotect the workbook & modify it. To lớn unprotect a workbook, simply click on the Protect Workbook button again and input the password khổng lồ unprotect the Excel workbook.

*
Click Protect Workbook a second time and input the password khổng lồ re-enable workbook changes.

3. How khổng lồ Protect Cells in Excel

Now, let"s get down to lớn really detailed methods for protecting a spreadsheet. So far, we"ve been password protecting an entire workbook or the structure of an Excel file. In this section, we dig into how khổng lồ protect your cells in Excel with specific settings you can apply. We cover how to lớn allow or block certain types of changes khổng lồ be made to parts of your spreadsheet.

To get started, find Excel"s Review tab, and click on Protect Sheet. On the pop-up window, you"ll see a huge phối of options. This window allows you to lớn fine-tune how you want to protect the cells in your Excel spreadsheet. For now, let"s leave the settings at their default.

*
To protect a sheet, select a tab in your Excel workbook, click on the Review tab & choose the Protect Sheet menu option.

This option allows for very specific protections of your spreadsheet. By default, the options will almost totally lock down the spreadsheet. Let"s showroom a password so that the sheet is protected. If you press OK at this point, let"s see what happens when you attempt lớn change a cell.

*
*
*
After a sheet has been protected, attempting khổng lồ change a cell will yield this error message. 

Excel throws off an error that the cell is protected, which is exactly what we wanted.

Basically, this option is crucial if you want khổng lồ ensure that your spreadsheet isn"t changed by others who have access lớn the file. Using the protect sheet feature is a way that you can selectively protect the spreadsheet.

To unprotect the sheet, simply click on the Protect Sheet button and re-enter the password lớn remove the protections added khổng lồ the sheet.

Specific Protections in Excel

Let"s take a second look at the options that show when you start lớn protect a sheet in Excel workbooks.

*
Password protect worksheet cells in Excel options.

The Protect Sheet menu lets you refine the options for sheet protection. Each of the boxes on this menu lets the user change slightly more inside of a protected worksheet.

To remove a protection, check the respective box in the list. For example, you could allow the spreadsheet user lớn Format cells by checking the corresponding box.

Here are two ideas on how you could selectively allow the user to change the spreadsheet:

Check the Format cells, columns, and rows boxes lớn let the user change the visual appearance of cells without modifying the original data.Insert columns and rows could be checked so that the user can showroom more data, while protecting the original cells.

The important box to leave checked is the Protect worksheet & contents of locked cells box. This protects the data inside of cells. 

When you"re working with crucial financial data or formulas that will be used in making decisions, you have lớn maintain control of the data and ensure that it doesn"t change. Using these types of targeted protections is an important Excel skill khổng lồ master.

Recap và Keep Learning More About Excel

Locking up a spreadsheet before you send it is crucial khổng lồ protecting your valuable data và making sure that it"s not misused. The tips I shared in this tutorial help you maintain control of that data even after your Excel spreadsheet is forwarded and shared.

All of these tips are additional tools and steps to lớn becoming an advanced Excel user. Protecting your workbooks is a specific skill, but there are lots of ways lớn improve your performance. As always, there"s room khổng lồ grow your Excel skills further. Here are some helpful Excel tutorials with important skills to master next:

How vày you protect your important sarakhanov.com data when sharing it? Let me know in the comments section if you use these protection tools or others I may not know about.