good afternoon today I'm gonna be giving
a tutorial on how to unlock in a 2016
Excel spreadsheet here we have a
spreadsheet that's been locked if I try
to enter any data in it it'll come up
showing it's locked I can try to enter a
password I have no idea what the
password is
and it my password wrong so we have to
unlock this sheet first thing that we
have to do is change the file name to a
dot zip this then needs to be extracted
and we'll extracted here to the desktop
alright here's the file that we just
extracted now we're gonna go into Excel
worksheets and this should sheet number
1 file is the one that contains the
password alright so we have to remove
the entire section that says sheet
protection and we're going to take it
out until just after scenarios here by
doing that we'll just hit delete now we
have to save this winged out of here
I'm gonna go back into Excel I'm gonna
copy this whole worksheets folder all
right now we can get out of here and go
back into our dot zip file and click on
Excel and here I'm going to delete the
worksheets folder and I'm going to paste
the worksheets folder that we just
copied and you see here it pasted it in
there all right now we can X out of this
and we just have to rename our file back
to the 2016 Excel spreadsheet which is
xlsx and confirm that we do want to make
that change and now when we open it the
password should have been removed and
you see we can now enter information if
you've liked my tutorial please like the
video and subscribe to my channel thank
you very much