Question about Computers & Internet

1 Answer

Hou to unprotect in excel sheet

Pls help me

Posted by on

  • Sanju Raval Jan 24, 2008


    Mr Aimiel..

    Pls help me This problem...

    See this Jpg format problem..

    Then modify the D11 cell to show this excel error, So pls help me canfast..

    I wait here...


    Sanjay Ravala



1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 265 Answers


We first need to know which version of Microsoft Office you are using, since different methods will exist for different versions. It is Office 2000, 2003, 2007 or some other version?



Posted on Jan 23, 2008

  • Aimiel Ireman Jan 24, 2008

    You need to copy and paste the data into an un-protected sheet. That should allow you to make whatever changes to the sheet you would like.



1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

I want to use protected sheet unprotected

You can re open password protected excel sheet by using Stellar Phoenix excel password recovery software (or any other software known to you).

Apr 19, 2012 | Microsoft Word 2000 for PC

1 Answer

How i can crack the password of excel sheet..............


Have tried downloading the password.xla? If not, below is the link:

Just add this xla to your addins and then open your excel document. The sheet will be automatically be unprotected.

Feb 09, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

In one of my excel files, I found that the Merge Icon is Inactive, In tried all moods and options, but the Icon is still inactive, I also tried the ''format painter'' to make cells merged but it not...

This can be caused by the worksheet being protected. Check on the Review tab in the Changes group and see if the Protect Sheet or Unprotect Sheet icon is visible. If the Unprotect sheet icon is visible, then the sheet is protected and that would cause the merge cells icon to be inactive.

Apr 22, 2009 | Microsoft Excel 2003 (06503995)

2 Answers

Excel work sheets delete,pls how is it restore

Easiest way would be to use the Undo function to work your way back to the point prior to deleting the worksheets. If you can't back up through the list that far, you could close the file WITHOUT SAVING IT, then reopen the original file again. If you have already saved the document after deleting the worksheets, you will have to restore it from a backup (you do perform backups, right?) and continue working fro there.

Apr 15, 2009 | Microsoft Computers & Internet

1 Answer

Unprotect an Excel sheet

Print or convert it to pdf then you may copy/paste from the pdf to a new unprotected sheet.

Doesnt work for formula.

Feb 18, 2009 | Computers & Internet

1 Answer

Tools protect workbook& sheet

Open the protected sheet... Go to edit and click select all. Go back to edit and click on copy. Open a new excel sheet, go to edit and click on paste. Now you have the copy of the protected sheet without the protection.

Jan 23, 2009 | Steinberg Cubase Studio 4 Upgrade Version...

3 Answers

How to protect a single cell in excel from modification

Found on the internet and it seems to work:

The default setting for each cell is for them to start locked. So, you first need to highlight ALL cells in the sheet, right click, choose format, go to the Protection tab and take the tick out of the Locked box.

Now no cells are locked.

Now you need to select the one cell you want locking. Right click, choose format cells, Protection tab and then put a tick into the Locked box.

Locking the cells does not take place until you have locked the sheet. So go to Tools, Protection and Protect Sheet. Add a password of your choosing, and put a tick into every option available to you, EXCEPT the very top option. "Select locked cells" should NOT have a tick in it.

OK that to confirm, and hey presto, that cell can no longer be selected, edited or erased unless you unprotect the sheet by entering the password you chose.

May 23, 2008 | Microsoft Excel for PC

1 Answer

Hou to link one sheet to another sheet

Hi, So what program are you using, MS Excel?

What do you want to do?

Can you give me any examples?

You could email me something even.

Let me know

Dec 04, 2007 | Computers & Internet

4 Answers

Forgot password

Try this link It should help you unlock the Excel file and break the password. Good luck

Sep 02, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

667 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers


Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides