Question about Computers & Internet

1 Answer

Hou to unprotect in excel sheet

Pls help me

Posted by on

  • Sanju Raval Jan 24, 2008

    Hy

    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...



    Thanks

    Sanjay Ravala

×

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 265 Answers

Sanju,

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?

Thanks,

Aimiel

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.

×

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

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

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

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..............


Hi,

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

http://www.straxx.com/excel/password.html

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
SeaJade

Dec 04, 2007 | Computers & Internet

6 Answers

Forgot password


Try this link http://www.download.com/Free-Word-Excel-Password-Wizard/3000-2092_4-10249516.html?tag=lst-0-1 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

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 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

Loading...