How to Remove a Password from an Excel 2010 Spreadsheet

Microsoft Excel files are often shared between students and colleagues who are attempting to solve a problem or share information. But occasionally you might encounter a part of an Excel file that you cannot change or edit. This happens when someone applies a password to one of the worksheets in the file.

I have personally used password protection in Excel 2010 in the past when I share a file that contains a lot of formulas. By password protecting the cells that contain the formulas, I can be confident that someone working with the file won’t accidentally delete or change the formulas. But a password that has been added to a worksheet in Excel 2010 can be removed, provided that the person attempting to remove the password knows what the password is. So continue reading below to find out how you can use an Excel worksheet password to unlock the cells in your file.


Unlocking a Worksheet in Excel 2010

The steps in this article will only work if you know the password for the worksheet. You are not able to unlock a worksheet in Microsoft Excel 2010 without the password.

The steps for removing a worksheet password are presented in two formats below. The first format provides short and simple directions for where to find this setting. The second format includes images highlighting where you need to go to perform each action.


Quick Steps

  1. Click the Review tab.
  2. Click the Unprotect Sheet button.
  3. Enter the worksheet password, then click OK.


Steps with Pictures


Step 1: Open the file containing the password that you want to remove in Excel 2010.


Step 2: Click the Review tab at the top of the window.

click the review tab



Step 3: Click the Unprotect Sheet button in the Changes section of the navigational ribbon.

click the unprotect sheet button



Step 4: Type the password into the Password field, then click the OK button.

click the OK button



Do you want to learn how to lock cells in Excel? This article will show you how to choose which cells are locked and unlocked in an Excel 2010 worksheet. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.