Read Time: 8 mins url-selector#selectionChanged"> English Español Bahasa Indonesia Македонски јазик Pусский українська мова Tiếng Việt
When it comes time to lớn skết thúc your Excel spreadsheet, it"s important khổng lồ protect the data that you"re sharing. You might want lớn tóm tắt your data, but that doesn"t mean it should be changed by someone else.
Bạn đang xem: Cách khóa sheet trong excel
Spreadsheets often contain essential data that shouldn"t be modified or removed by the recipient. Luckily, Excel has built-in features 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 prsự kiện them from being opened by unauthorized users.Protect individual sheets & the workbook structure, to prsự kiện the insertion or deletion of sheets in the workbook.Protect cells, to specifically allow or disallow changes to lớn 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 lớn vì chưng is remove the option khổng lồ change your spreadsheets altogether.
How 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, & more.
Want a step-by-step walkthrough? Cheông xã out my steps below khổng lồ find out how khổng lồ use these techniques. You"ll learn how to lớn protect your workbook in Excel, as well as protecting individual worksheets, cells, và how khổng lồ work with advanced settings.
We start with broader worksheet protections, then work down to lớn narrower targeted protections you can apply in Excel. Let"s get started learning how khổng lồ protect your spreadsheet data:
1. Password Protect an Excel Workbook File
Let"s start off by protecting an entire Excel tệp tin (or workbook) with a password to prevent others from opening it.
This is a breeze khổng lồ vày. While working in Excel, navigate khổng lồ the File tab choose the Info tab. Cliông chồng on the Protect Workbook dropdown option and choose Encrypt with Password.
As is the case with any password, choose a strong and secure combination of letters, numbers, and characters, bearing in mind that passwords are case-sensitive.
It"s important lớn note that Microsoft has really beefed up the seriousness of their password protection in Excel. In prior versions, there were easy workarounds lớn bypass password protection of Excel workbooks, but not in newer versions.
In Excel 2013 & beyond, the password implementation will prsự kiện these traditional methods to bypass it. Make sure that you store your passwords carefully và safely or you risk permanently losing access to lớn your crucial workbooks.
Excel Workbook - Mark as Final
If you want lớn be a bit less forceful with your spreadsheets, consider using the Mark as Final feature. When you mark an Excel file as the final version, it switches the file to read-only mode, & the user will have to lớn re-enable editing.
To change a file lớn read-only mode, return lớn the File > Info button, và click on Protect Workbook again. Cliông xã on Mark as Final và confirm that you want khổng lồ mark the document as a final version.
Marking a file as the final version will add a soft warning to lớn the top of the tệp tin. Anyone who opens the tệp tin after it has been marked as final will see a notice, warning them that the tệp tin is finalized.
Marking a file as the final version is a less formal way of signaling that a tệp tin 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 lớn access the workbook, but limit the changes they can make khổng lồ 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 to lớn the Review tab on Excel"s ribbon & cliông chồng on Protect Workbook. Xem thêm: Có Nên Mua Lg V10 Hàn Cũ Có Thực Sự Nên Mua? Tự Nhiên Nhớ Lg V10
Once this option is turned on, the following will go into lớn 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 & drop the sheet tabs lớn reorder them in the workbook.Of course, trusted users can be given the password lớn unprotect the workbook & modify it. To unprotect a workbook, simply clichồng on the Protect Workbook button again & đầu vào the password to unprotect the Excel workbook.
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 sầu been password protecting an entire workbook or the structure of an Excel tệp tin. In this section, we dig into how to protect your cells in Excel with specific settings you can apply. We cover how to lớn allow or block certain types of changes to lớn be made lớn parts of your spreadsheet.
To get started, find Excel"s Review tab, & cliông xã on Protect Sheet. On the pop-up window, you"ll see a huge set of options. This window allows you khổng lồ fine-tune how you want khổng lồ protect the cells in your Excel spreadsheet. For now, let"s leave sầu the settings at their mặc định.
This option allows for very specific protections of your spreadsheet. By default, the options will almost totally loông chồng down the spreadsheet. Let"s add a password so that the sheet is protected. If you press OK at this point, let"s see what happens when you attempt khổng lồ change a cell.
Excel throws off an error that the cell is protected, which is exactly what we wanted.
Basically, this option is crucial if you want to lớn ensure that your spreadsheet isn"t changed by others who have access to lớn the file. Using the protect sheet feature is a way that you can selectively protect the spreadsheet.
To unprotect the sheet, simply clichồng on the Protect Sheet button & re-enter the password to remove the protections added lớn the sheet.
Specific Protections in Excel
Let"s take a second look at the options that show when you start khổng lồ protect a sheet in Excel workbooks.
The Protect Sheet thực đơn 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 sầu a protection, check the respective sầu 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 lớn change the spreadsheet:
Chechồng the Format cells, columns, and rows boxes khổng lồ 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 add more data, while protecting the original cells.The important box khổng lồ leave sầu checked is the Protect worksheet và 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 sầu 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 to master.
Recap và Keep Learning More About Excel
Locking up a spreadsheet before you skết thúc it is crucial lớn protecting your valuable data and 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 becoming an advanced Excel user. Protecting your workbooks is a specific skill, but there are lots of ways lớn improve sầu your performance. As always, there"s room to lớn grow your Excel skills further. Here are some helpful Excel tutorials with important skills khổng lồ master next:
How vì you protect your important sydneyowenson.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.