How to Password Protect an Excel File [Easy ways]

-

Excel spreadsheet is one of the office software we commonly use to record data at work. In order to protect the security and integrity of some important Excel spreadsheet data, the easiest way is to add a password to the Excel file to avoid unauthorized opening or tampering with the file, which can lead to data leakage or data loss.In this article, we will guide how to password protect an Excel file in a variety of situations.



Part 1: How to Password protect an Excel file from opening

If you want to prevent people from accessing your entire Excel file, the most effective way is encrypt Excel file with a password, which only takes a few seconds, so let's get started!

Way 1: Encrypt an Excel Document in MS Office

Step 1: Open the Excel document you need to encrypt, navigate to the "Save As" dialog box: File > Save as > This PC.


Step 2: Click the drop-down arrow in the "Tool" option box,then  select "Genaral Options", after entering and confirming your password, click "OK ", and your Excel file will be encrypted.

Or you can choose the following path to encrypt your Excel sheet: File > Info > Protect Workbook > Encrypt with Password.



Way 2: Encrypt an Excel file with iSunshare SafeFile Genius

MS Office can't encrypt multiple Excel files at one time, and it's easy for password recovery software to extract Excel password and get access to the files. So I suggest you to know about the professional file encryption tool: iSunshare SafeFile Genius, it can safely encrypt your private files and folders with a password, including office files,images, videos, audios, etc. Download it now to get 30 days free experience.

Step 1: Download and install iSunshare SafeFile Genius on your computer, and after running it, click the "Encrypt" button on the software interface.


Step 2: Click the file icon in the upper right corner and select the Excel file you need to encrypt.

If you want to encrypt the entire folder of Excel files,you can put them all in the same folder,then you click on the folder icon and select the folder to encrypt.


Step 3: After selecting the files, click "Next" to set the password, set and confirm the password, then click the "Encrypt" button to protect your excel files.


Part 2: Protect the contents of hidden Excel files with a password

Excel offers considerable flexibility in password protection. If you are trying to prevent the contents of your Excel file from being viewed, then in addition to encrypting the entire file, you can also choose to set a password to protect the contents of the part of the file that needs to be hidden and kept confidential.

Step 1: In the lower left corner you can see all the tabs of the Excel worksheet, select the tab where the form needs to be hidden, right-click it, click on the option box that appears "Hide" option, you selected the file will be hidden.


Step 2: To strengthen the security of hidden files so that only people who know the password have permission to "Unhide" the contents of the file, you need to add password protection to the Excel workbook: navigate to Review > Protect > Protect Workbook to set the password.Then the content of the excel file you choose to set the password to hide will be displayed blank,it will be difficult for others to browse this part of information without password.


Part 3: How to password protect an excel file but allow read-only

You want people who read your documents to not be able to modify your file data? It's easy! As long as you set your Excel file to read-only, then you can guarantee the integrity of your document data. There are many ways you can password protect an excel file but allow read-only, here is the most common way：first select the Excel file whose contents you need to set read-only , then navigate to Review > Protect > Unprotect Sheet.After enter and confirm password, your Excel file will be set to read-only.


Conclusion

The above is about how to password protect an Excel file in several ways, as shown above, you only need to go through a few simple steps to encrypt your Excel file, if MS Excel is a necessary tool for your office, then I suggest you should add password protection for your Excel file to prevent the leakage of important data.

Comments

Post a Comment

Popular posts from this blog

How to Encrypt and Decrypt Excel File [The Latest Guide]

-
Image
Excel as one of the main software of Microsoft Office, its main function is to organize data and statistics. In our daily life and work, Excel is widely used, so the security of the important data existing in Excel files is a matter of concern, how to prevent the contents of Excel from being viewed at will? A common method is to encrypt Excel files , so after encrypting Excel, how to decrypt it? In this article, we will guide you on how to encrypt and decrypt Excel files. Option 1：How to Encrypt Excel File by microsoft office Part1：How to Encrypt Excel File by microsoft office Step 1: Open the Excel file that needs to be encrypted and click the " File " option in the upper left corner. Step 2: After entering the file management function, click on " Info ", then select the option " Protect workbook " in the Information column, click on the option and a drop-down menu will appear, in the menu bar you will see "Click on it, then enter and confirm your ...
Read more

How to Bypass Samsung FRP Lock With or Without PC

-
Image
  Q:   "I forgot my Google account password and worst of all, I just did a factory reset on my Samsung phone before I realized I couldn't remember the password, and now I'm stuck on the FRP screen and can't access my phone, what can I do?" Google Account Verification, also known as Factory Reset Protection (FRP), is a Google security feature for devices running Android 5.1 or later. The feature requires users to enter the appropriate Google Account credentials to access the device again after performing a factory reset. In this article, we will guide you on how to bypass the FRP lock on Samsung, with or without a computer. Can You Bypass FRP Lock on Samsung without Password? If your Samsung device has been locked by FRP after a factory reset, you may be worried if there is a way to unlock it. The answer is yes. As long as your email or phone number is still valid, you can easily bypass google account   lock  by verifying your account information. On the other hand...
Read more

How to Unlock 'Support Apple Com iPhone Passcode' Screen

-
Image
  A few days ago, when I took my iPhone out of my pocket, it showed security locked with a "support.apple.com/iphone/passcode" URL. This meant that I was blocked from accessing the device, which was really frustrating. Luckily, I managed to remove the security lock from my iPhone at home by following the solution provided by Apple's official and some other guides. Therefore, I have compiled this experience and I hope this information will be useful for you. Understanding Causes: Your device screen displays an " iPhone unavailable   warning, and a support.apple.com/iphone/passcode   link," which is a security measure. After a failed passcode attempt (usually six), your device enters a secure lockdown mode to protect your data from unauthorized access. The maximum number of chances to enter an incorrect passcode is 10, and then your iPhone is completely locked.  Even if this is because you forgot to lock the screen and accidentally entered the wrong number, there ...
Read more