• Send Us A Tip
  • Calling all Tech Writers
  • Advertise
Tuesday, June 24, 2025
  • Login
  • Register
TechStory
  • News
  • Crypto
  • Gadgets
  • Memes
  • Gaming
  • Cars
  • AI
  • Startups
  • Markets
  • How to
No Result
View All Result
  • News
  • Crypto
  • Gadgets
  • Memes
  • Gaming
  • Cars
  • AI
  • Startups
  • Markets
  • How to
No Result
View All Result
TechStory
No Result
View All Result
Home How to

How To Remove Password from Excel

by Sandra Theres Dony
July 20, 2022
in How to
Reading Time: 3 mins read
0
Excel
TwitterWhatsappLinkedin

Passwords are often necessary to ensure safety. However there are times when will have to remove the passwords. Even more exasperating is when your memory plays games and you forget the password. In such situations, how will you change password? Worry not. We have got you covered. Given below are the different methods to remove password from excel. Whether you remember the password or not, you can easily remove it by following a few simple steps. Read along to know more.

You might also like

How to mark a game as favorite on Roblox?

How To Beat The Final Boss In Elden Ring Nightreign

How to Increase Carry Weight in Dune Awakening

Excel

How To Remove Password When You Know The Password

Given below are the steps to be followed to remove password from an excel file if you are the one who set the password.

Removing Password From The Info Panel

  1.  Open the encrypted excel while
  2. Click OK after entering the password
  3.  Click the File tab located on the upper left corner of the opened excel sheet
  4.  In order to open the drop-down menu, tap on the Info and Protect Workbook in the left-hand panel
  5.  From the drop-down list, choose Encrypt with password. After this delete the password in the text field.
  6.  Click OK after deleting the existing password, and you are good to go.

Removing Password From The Review Tab

  1. Open the encrypted excel file
  2. Click OK after entering the excel password
  3. Click the Review tab on the main ribbon menu of the opened Excel spreadsheet
  4. After clicking the Unprotect Sheet, enter the password
  5.  Without entering a new password, select Protect Sheet and then click OK. This will let you remove the password while ensuring that the workbook is locked from editing
  6.  Go to File>Save

Removing Password When You Don’t Know The Password

There are times when you want to access an excel file but your memory fails you or you just don’t know the password. In such situations, you can follow the steps given below. However don’t forget to create a backup copy of your excel file before trying to remove the password. Because as the saying goes, it is always better to be safe than sorry.

Converting An Excel File Into A Zip File
  1.  Right click on your document. In order to convert the file, rename the extension from “.xlsx.” to “.zip”.
  2. Click Yes if you get a warning enquiring if you want to go through with changing the password.
  3. Right click on the file and click Yes to extract the contents of the Zip file
  4.  Now you will see a window that shows the folder where the files will be extracted. Select Extract All.
  5. Open the “XL” folder in the extracted file
  6. Open the “worksheets” folder inside the “XL” folder
  7.  A set of XML files will appear. These are all the excel worksheets within the spreadsheet that is password protected.
  8. If you want to modify the XML file, all you have to do is open one XML file in the notepad. Then search for a line with ‘protection.”
  9. Now, select everything between and including “<“and”>” characters. Then delete it.
  10. After clicking the File menu in the notepad, clcik Save.
  11. Repeat the same process with every XML file. Ensure that the files are modified.
  12. If you want to add the modified XML file into the zip file, just select all the files from the extracted files.
  13. Now right click and then select Send to>Compressed folder
  14.  Rename the newly created zip file extension from “.zip” to “.xlsx”.
  15. Click Yes when you get a warning asking whether you want to change it
  16. Now you can open the Excel file.

 

 

Tags: EXCELHow to
Tweet54SendShare15
Previous Post

According to a poll seven in ten Americans have favorable view of NASA

Next Post

Syska SW300 POLAR Smartwatch with Health Tracking, Heart Rate Monitor – Complete Review

Sandra Theres Dony

Content writer at Techstory, dealing with topics, Artificial Intelligence, Virtual Reality and Augmented Reality.

Recommended For You

How to mark a game as favorite on Roblox?

by Afeefa Ansari
June 24, 2025
0
Roblox

Do you want to mark some games as favorites so that it is easier to find them? Well, Roblox has a few ways that can help you do...

Read more

How To Beat The Final Boss In Elden Ring Nightreign

by Khilav Jadav
June 24, 2025
0
How To Beat The Final Boss In Elden Ring Nightreign

Elden Ring Nightreign’s final boss, Heolstor the Nightlord, is a brutal test of patience, skill, and adaptability. Whether you’re playing solo or with a team, this two-phase battle...

Read more

How to Increase Carry Weight in Dune Awakening

by Khilav Jadav
June 24, 2025
0
How to Increase Carry Weight in Dune Awakening

Surviving the harsh deserts of Arrakis in Dune: Awakening means mastering one crucial skill: managing your carry weight. Whether you're hauling precious spice, scavenging rare minerals, or stocking...

Read more
Next Post
Syska SW300 POLAR Smartwatch with Health Tracking, Hear Rate Monitor - Complete Review

Syska SW300 POLAR Smartwatch with Health Tracking, Heart Rate Monitor - Complete Review

Please login to join discussion

Techstory

Tech and Business News from around the world. Follow along for latest in the world of Tech, AI, Crypto, EVs, Business Personalities and more.
reach us at [email protected]

Advertise With Us

Reach out at - [email protected]

BROWSE BY TAG

#Crypto #howto 2024 acquisition AI amazon Apple bitcoin Business China cryptocurrency e-commerce electric vehicles Elon Musk Ethereum facebook flipkart funding Gaming Google India Instagram Investment ios iPhone IPO Market Markets Meta Microsoft News NFT samsung Social Media SpaceX startup startups tech technology Tesla TikTok trend trending twitter US

© 2024 Techstory.in

No Result
View All Result
  • News
  • Crypto
  • Gadgets
  • Memes
  • Gaming
  • Cars
  • AI
  • Startups
  • Markets
  • How to

© 2024 Techstory.in

Welcome Back!

Login to your account below

Forgotten Password? Sign Up

Create New Account!

Fill the forms bellow to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In
Are you sure want to unlock this post?
Unlock left : 0
Are you sure want to cancel subscription?