3 种密码保护 Excel 文件的方法: (3 Ways to Password Protect an Excel File: )我们都熟悉Excel文件,它用于创建填充数据的工作表。有时我们将高度机密和重要的业务数据存储在我们的Excel文件中。在这个数字时代,我们发现所有重要的东西,如社交账户、电子邮件和设备都受到密码保护。如果您非常依赖为任何重要目的创建 Excel 文档,那么您应该能够像使用密码保护的其他重要内容一样保护该文档的安全。
你不认为excel文件如果存储重要内容应该用密码保护吗?在某些情况下,您不希望任何人访问您的重要文档,或者只是希望对您的文档提供有限的访问权限。如果您希望只有您授权的特定人员才能读取和访问您的 Excel 文件,则需要使用密码对其进行保护。以下(Below)是一些保护您的 Excel 文件和/或限制收件人访问的方法。
3种(Ways)密码保护(Password Protect)Excel文件的方法(Excel)
方法一:添加密码(加密Excel)(Method 1: Adding a Password (Encrypting Excel))
第一种方法是使用选定的密码加密整个 Excel 文件。这是确保文件安全的最简单方法。您只需导航到“文件”选项,您将获得保护整个 Excel 文件的选项。
步骤 1 – 首先,点击“文件(File)”选项
第 2 步 – 接下来,点击“信息(Info)”
第 3 步 – 单击“保护工作簿(Protect Workbook)”选项
第 4 步 – 从下拉菜单中单击“使用密码加密(Encrypt with password)”选项。
第 5 步 – 现在将提示您输入密码。选择一个唯一密码以使用此密码来使用和保护您的 Excel 文件。(protect your excel file with this password.)
注意:当您提示输入密码时,请确保您选择了一个复杂且唯一的密码组合。值得注意的是,保留常用密码很容易受到恶意软件的攻击和解密。您需要记住的更重要的一点是,如果您忘记了此密码,您将无法访问 Excel 文件。恢复受密码保护的 excel 文件是一个繁琐的过程。因此,建议您将此密码存储在安全的地方或使用密码管理器来保存此密码。(you store this password somewhere safe or use a password manager to save this password.)
下次打开文件时会提示输入密码。此密码将保护和保护单个 excel 文件,而不是保存在系统上的所有 excel 文档。
方法 2:允许只读访问(Method 2: Allowing for Read-Only Access)
在某些情况下,您可能希望某人必须访问 Excel 文件,但如果他们想对文件进行任何编辑,则需要输入密码。加密 excel 文件非常简单易行。但是,在保护您的 excel 文件时,excel 总是为您提供一些灵活性。因此,您可以轻松地向其他人提供一些受限访问。
第 1 步 – 单击文件(File)
第 2 步 – 点击“另存为(Save As)”选项
第 3 步 – 现在单击另存为(Save As)对话框下底部的工具。( Tools)
第 4 步 – 从 工具(Tools)下拉列表中选择常规选项。(General option.)
第 5 步 – 在这里您会找到两个选项“密码打开(password to open)”和“密码修改(password to modify)”。
当您设置密码打开(set a password to open)时,每次打开此excel文件时都需要输入此密码。此外,一旦您将密码设置为 modify(set the password to modify),每当您想对受保护的 Excel 文件进行任何更改时,都会提示您输入密码。
方法 3:保护工作表(Method 3: Protecting a Worksheet)
如果您的 excel doc 文件中有多个工作表,您可能希望限制对特定工作表的访问以进行编辑。例如,如果一张关于您的业务销售数据的工作表是您不想被访问此 excel 文件的人编辑的,您可以轻松地输入该工作表的密码并限制访问。
第 1 步 - 打开您的 excel 文件
第 2 步 - 导航到评论部分(Review section)
第 3 步 – 单击保护表选项。(Protect Sheet option.)
系统将提示您设置密码(You will be prompted to set a password)并选择带有复选框的选项以访问工作表的特定功能(options with tick boxes to give access for particular functionality of the sheet)。每当您选择任何密码来保护您的 Excel 文件时,请确保它是唯一的。另外,您应该记住密码,否则恢复文件对您来说将是一项繁重的任务。
受到推崇的:(Recommended:)
结论:(Conclusion:)
大多数工作场所和企业都使用 excel doc 文件来存储其高度机密的数据。因此,数据的安全和保护非常重要。为您的数据增加一层安全性不是很好吗?是的,当您拥有受密码保护的设备时,您的社交帐户受密码保护,为什么不在您的 Excel 文件中添加密码并为您的文档添加更多安全层。上述(Above)方法将指导您保护整个 Excel 工作表或限制访问权限,或者只是为文件用户提供一些受限功能的访问权限。
3 Ways to Password Protect an Excel File
3 Ways to Password Protect an Excel File: We all are familiar with Excel files that it is used to create sheets filled with data. Sometimes we store highly confidential and important business data in our excel files. In this digital era, we find that all important things such as social accounts, email, and devices are password protected. If you very much rely on creating excel documents for any important purpose, you should be able to keep that document secure like other important stuff you secure with a password.
Don’t you think that excel files should be protected with a password if it stores important content? There are some occasions when you do not want anyone to access your important documents or simply want to give limited access to your document. If you want that only a particular person you give authorization to, can read and access your excel files, you need to protect it with a password. Below are some methods to secure your excel files and/or give restricted access to the recipient.
3 Ways to Password Protect an Excel File
Method 1: Adding a Password (Encrypting Excel)
The first method is encrypting your entire excel file with a selected password. It is the easiest way to keep your file secure. You simply need to navigate to “File” option where you will get the option to protect your entire excel file.
Step 1 – First, click on the “File” Option
Step 2 – Next, click on “Info”
Step 3 – Click on the “Protect Workbook” option
Step 4 – From the drop-down menu click on the option “Encrypt with password”.
Step 5 – Now you will be prompted to type a password. Choose a unique password to use and protect your excel file with this password.
Note: When you prompted to type a password make sure that you choose a combination of a complicated and unique password. It is noticed that keeping the usual password can be easily attacked by malware and decrypted. One more important point that you need to keep in mind is that if you forget this password you would not be able to access the excel file. Recovering the password protected excel file is a cumbersome process. Therefore, it is recommended that you store this password somewhere safe or use a password manager to save this password.
When you open the file next time, it will prompt you to enter the password. This password will protect and secure the individual excel file, not all the excel docs saved on your system.
Method 2: Allowing for Read-Only Access
There can be instances when you want someone to have to access the excel files but need to put the password if they want to make any edit on the file. Encrypting the excel file is pretty much straightforward and easy to do. However, excel always gives you some flexibility when it comes to protecting your excel file. Thus, you can easily provide some restricted access to other people.
Step 1 – Click on File
Step 2 – Tap on the “Save As” option
Step 3 – Now click on Tools at the bottom under Save As dialog box.
Step 4 – From Tools drop-down select General option.
Step 5 – Here you will find two options “password to open” & “password to modify”.
When you set a password to open, you will be required to enter this password whenever you open this excel file. Also, once you set the password to modify, you will be prompted a password whenever you want to make any changes in the protected excel file.
Method 3: Protecting a Worksheet
In case you have more than one sheet in your excel doc file, you may want to restrict access to the particular sheet for editing. For instance, if one sheet is about your business sales data that you do not want to be edited by the person who has accessed this excel file, you can easily put the password for that sheet and restrict the access.
Step 1- Open your excel file
Step 2 – Navigate to the Review section
Step 3 – Click on the Protect Sheet option.
You will be prompted to set a password and select the options with tick boxes to give access for particular functionality of the sheet. Whenever you choose any password to protect your excel file, make sure it’s unique. Plus, you should remember that password otherwise recovering the file will be a hectic task for you.
Recommended:
Conclusion:
Most of the workplaces and businesses use excel doc files for storing their highly confidential data. Therefore, the security and protection of the data matter a lot. Would not it be great to add one more layer of security for your data? Yes, when you have a password protected device, your social accounts are password protected why not add a password to your excel file and add more layer of security for your documents. Above mentioned methods will guide you to either protect the entire excel sheet or restrict the access or simply give access with some restricted functionality to the users of the file.