so
[Music]
hello friends
welcome back to our channel
forgot password for your protected excel
sheets
no problem
in this video i have explained how to
remove the password from a protected
excel sheet without using any recovery
software
all you need is a zip program like
winrar or winzip
i'll give you the link of zip program in
the description
also please comment and tell us if you
have faced such a situation and what you
did to recover it
so let's begin
here this is my excel file
i have different sheets here
if you can see my second sheet here is
protected
if i'm trying to make any changes
i get a message saying the cell or chart
you're trying to change is on a
protected sheet
to make a change unprotect the sheet
you might be requested to enter a
password
but
i have forgotten my password
in certain situation how can we recover
it
i'll give you a simple trick
just close this file
and
change
extension of the file from
excel to
zip
save enter
it gives you a message saying if you
change a file name extension the file
might become unusable are you sure you
want to change it
say yes
now
open the zip file click on excel
and worksheets
here
simply
copy sheet2 from the zip file to your
desktop you move this file to the
desktop because our sheet2 is the
protected one
now we will open this
file
with notepad
and
using ctrl f
search for the word protect
here
is giving us
the word protect
i simply select the line
from this bracket
till the end of the bracket
and delete this line
close this file it asks if you want to
change
and save it
now
from our
zip folder we will
delete sheet 2
and move the edited sheet 2
to the zip fold
close this
again
change
the extension of the file from zip
to excel
it asks you again if you want to
change the file because if you change
the extension the file might become
unusable click on yes
now if you open it
and
click on sheet 2 and try to make changes
it's allowing you to make your changes
the protection is gone
so this is how you can unprotect
protected excel sheet if you want to
protect your excel sheets all you have
to do is go on review and click on
protect sheet
it will ask you for a password
enter a password say okay it will ask
you to re-enter password enter it again
say okay
now if you're trying to make changes
it will not allow
so this is how you can protect and
unprotect your excel
sheets
hope you found this video useful
if you like this video do like and share
drop in a comment and don't forget to
subscribe to my channel
stay tuned for many more interesting
videos
thanks for watching