How can I Unlock cell/worksheet?

  • Thread starter Thread starter Lyn
  • Start date Start date
L

Lyn

I received a spreadsheet that has been used as a form and only the cells
where information is to be populated are accessible. I thought I could do a
Save As or even copy all the contents and paste them into a new spreadsheet
so I can alter the cells that are not accessible, but I am unable to do this.
I cannot contact the originator for an editable version. How can I work
around this?
 
You can try unprotecting it. That will do it if they did not password protect it.
In Excel 2007, go to Home>Cells>Format and select Unprotect.
 
It does not ask for a password when I open it, but when I try to do as you
have suggested, "Cell" is grayed out so I don't have the option to change it.
Any other suggestion?
 
While that's interesting, I didn't find anything that I could understand to
help me with this issue. Can you dumb it down?
 
If you can prove to me that you are authorized to do this, send to me and I
will unprotect for you.
 
Back
Top