Home > Microsoft Office > Microsoft Office How To

How to remove password from Excel – 2 easy methods

Here are two methods that can help you quickly remove a password from Excel!

Reviewed By: Kevin Pocock

Last Updated on July 15, 2024
How to remove password from Excel
You can trust PC Guide: Our team of experts use a combination of independent consumer research, in-depth testing where appropriate - which will be flagged as such, and market analysis when recommending products, software and services. Find out how we test here.

If you want to know how to remove password from Excel, you’ve come to the right place.

Password protection in Excel is one of the most valuable features from a security perspective. With the increase in cybercrime, staying protected is a must, and one of those defenses is simple to use, i.e. password protection. But what if you no longer need to keep a password on a certain file? Do you have to go through a hectic process? Or is there an easy way to remove a password from Excel?

This is where we come in. In this guide, we will walk you through two methods that can help you quickly remove password from Excel. So, without wasting another second, let’s dive in!

1

How to remove password from Excel quickly using Info menu

Here’s how you can remove password from an Excel file using the Info menu.

Step

1

Open the file

First, open the Excel file that is protected by a password.

Step

2

Go to Info

Next, click on the File option that can be found in the top left corner, below the AutoSave button.

Learn how to add an email address to a Microsoft Excel spreadsheet and remove a password from Excel.

Then, click on the Info button.

Step

3

Remove the password

Finally, click on the Protect Workbook box, select Encrypt with Password, and then remove the password from the box.

How to encrypt the contents of this file in Microsoft Word and remove a password from Excel.

Once done, click OK, and the file will be no longer protected by a password.

If you’re using a Mac, then you’ll have to click on Passwords after going to the File section. Then, you’ll need to delete the passwords from the box that will appear and click on OK to remove them from the Excel file.

2

How to remove password from Excel using Save As

Another way to remove a password from Excel is using the Save As option.

 

Step

1

Go to Save As

After opening the password encrypted file, click on File, and then select Save As.

The save as button in Microsoft Word allows users to save their documents with ease. It enables individuals to create a new file or overwrite an existing one, ensuring their work is securely stored. With

Step

2

Select Browse

Next, click on Browse and open the folder where you want to save the file.

Step

3

Go to General Options

Now click on Tools to open a drop-down list, and select General Options.

General options

Step

4

Remove the password and save the file

Delete the password from both Password to open and Password to modify options, and click OK.

How to backup a password in windows xp and remove a password from excel.

Now save the file, and the password will be removed.

Final thoughts

This was everything you needed to know about how to remove passwords from Excel. The two methods we mentioned should work flawlessly and will help you remove the password protection quickly. However, if there’s confidential data in your file, we’d recommend keeping it secure.

You can learn more about Excel and its features through these helpful guides:

Kevin is the Editor of PC Guide. He has a broad interest and enthusiasm for consumer electronics, PCs and all things consumer tech - and more than 15 years experience in tech journalism.