0
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.
Wiki User
∙ 14y ago
Wiki User
∙ 11y agoThis can not be done. If the password is forgotten, there is no option USING THAT SPREADSHEET. However, you can copy and paste the data into another program and save it that way. The copy and paste is not always straightforward - if you copy and paste back into Excel, you may end up keeping the password requirement. It is dependent on what cells you select to copy, and the program you copy into. In a worst possible case, you have to copy and paste into a text editor, and retrieve the data from there.
Wiki User
∙ 9y agoThere are protection options for cells, worksheets and the workbook in Excel. These can be turned on and off. You will find the options on the Tools menu in versions of Excel up to 2003 and on the Review Tab from versions 2007 onwards. You may need a password, depending on how it was protected initially.
Add your answer:
Earn +20 pts
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.
Is landscape the default page orientation in Excel?
No. Portrait is the default page orientation in Excel.
What is the name for each page in an Excel spreadsheet?
In MS Excel, each page is called a worksheet.
How do you unprotect memorycard?
You cant because its protected all the time no one can unprotect a memory card sorry.
What is the name of a page on Excel?
A worksheet.
How do you change default margins on Excel spreadsheet?
How to change default page margins in excel.
How do you unprotect a VHS tape?
3
Excel inserts that show the boundaries of what will print on each page of the printed workbook.?
When you print a worksheet or use the Page Setup dialog box, Excel inserts_____ breaks that show the boundaries of what will print on each page
How do you unprotect your Twitter account?
You can't, you can only unprotect them on the web version.
What is the place where one printed page ends and the next begins in excel?
page break
What does worsheet mean?
a page in Excel or a sheet that you work on
I have made an excel sheet and want to lock certain cells to where they can not be typed in. Is there a way to do this to where I type in some cells and lock other cells?
Change the cell formatting to unprotect for the cells in which you want to type.Turn on protection for the entire sheet.
