Best Answer

In Excel 2007 and newer, click on the Review tab and select Unprotect Sheet. If you see Protect Sheetinstead of Unprotect Sheet, then the worksheet is not password protected.

In Excel 2003 and earlier, follow this menu string:

Tools --> Protection --> Unprotect Sheet

If the worksheet has a password, you will need to enter the password to unprotect the worksheet. If there is no password, just leave the password section blank.

User Avatar

Wiki User

2010-01-26 12:16:43
This answer is:
User Avatar
Study guides

How much can you sell a mirraco icon option for

Road wheel torque settings for peugeot 106 1.4

What kind of data do you write on a data table

What tab or dialog box do you use to organize your sources

See all cards
29 Reviews

Add your answer:

Earn +20 pts
Q: How do you unprotect an Excel worksheet?
Write your answer...
Still have questions?
magnify glass
Related questions

If Excel Merge and center is disabled how to enable it?

Unprotect the page where you want to use the Merge and Center command. When a worksheet is protected, you will not be able to use any of the commands that change the appearance of the worksheet.

Can you set password for coluom or row in excel spread sheet?

No, you can not password protect only a part of a worksheet, you must protect the entire worksheet. However, you can format everything, except the section you want to protect, to unprotect. That way, when you turn the worksheet protection on you can set the protection status to allow access only to unprotected cells.

What is an Excel worksheet?

A worksheet is a single page in a workbook.

What is the new of a new worksheet in Excel?

Create a blank worksheet.

How do you change color in Excel spreadsheet when cell protected?

If this feature has been protected then you must "unprotect" the worksheet first. If you do not have the password to do this then I'm afraid you are using a spreadsheet in which the creator did not want you to change such things (and they probably had a good reason to do so).

Is in excel like a notebook?


What is the name of a page on Excel?

A worksheet.

What is like a notebook in excel?


Where is the footer in excel?

at the bottom of the worksheet

Is Excel chart created from selected worksheet data?

Yes, a chart in Excel is created from data that has been selected in the worksheet.

Is Excel a chart or worksheet?

Excel is a spreadsheet application. It can have charts and worksheets in it.

What are the default names of a new worksheet in Excel?

There are 3 sheets when you open a new excel worksheet and they are labelled Sheet1, Sheet2, and Sheet3.

People also asked