How can I copy/edit a protected worksheet without the password?

K

ksmith81

We have a large (4,000+ rows) excel worksheet from a prior employee that I
would like to be able to use, but it is password protected and no one has the
password. Is there a way to copy or save it as a different file that will
not copy the password protection? It would save me a couple days of work if
it is possible.
Thanks
 
0

0-0 Wai Wai ^-^

We have a large (4,000+ rows) excel worksheet from a prior employee that I
would like to be able to use, but it is password protected and no one has the
password. Is there a way to copy or save it as a different file that will
not copy the password protection? It would save me a couple days of work if
it is possible.
Thanks
Click to expand...

Hi.
An easy way to do so is:
- Go to the password-protected worksheet
- Press "Ctrl+A" and then "Ctrl+C" (to copy all the contents of the worksheet)
- Open and go to a new Excel file
- Press "Ctrl+V" (to paste the contents to this new Excel file)

Hope this helps.
 
Top