How to Make an Excel Sheet Password Protected

Are you looking for ways to secure your Excel files from unauthorized access? One method is to password protect your Excel sheet using a simple trick. In this article, we will explore how to make an Excel sheet password protected without using any third-party software.

Step 1: Open the File Explorer window and locate the password-protected Excel worksheet. Right-click on it and choose 'Open with' to open the file in its native application.

Step 2: Click on the 'File' tab, then select 'Download As' and choose 'Microsoft Excel'. This will download a copy of your Excel file as an editable .xlsx file.

Step 3: Now, you need to change the file extension from XLSX to ZIP. To do this, right-click on the downloaded file, choose 'Send to', and select 'Compressed (zipped) folder' as shown below.

Step 4: After extracting the ZIP file, open the folder labelled 'xl' and subsequently locate the 'sheet.xml' file. Right-click on it and choose 'Open with' to open the XML file in a text editor or any other program that can read XML files.

Step 5: When the selected program opens the XML file, identify the 'sheetProtection' code section and delete it as shown below.

Step 6: After deleting the protection code, go back and select all the files you extracted from ZIP. Right-click on them and choose 'Extract All' to extract the files again.

And that's it! Your Excel sheet is now password protected using this simple method. Note that this method only works if your Excel file has a weak password or no password at all. If your file has a strong password, you

How to make an excel sheet password protected