in this tutorial i want to share with
you how to break the
microsoft excel password so maybe you
are working and you have decided to
password your document so
other people cannot make inputs to it or
even you at some point you don't have to
even edit it or have access to it and
change one or two things you can
password your document now to password a
document all you need to do is to start
by coming to review over here and you
can come to protect sheet or to protect
protect workbook completely okay so you
can protect a sheet and you can set in
password this document can be protected
alternatively you can come to the tab or
the sheet that you have and then you
right click on it and say protect sheet
okay so you just click on protect sheet
and you can now put in the password that
you want to put one two three four five
for example and say okay it will request
you to re-enter the password to confirm
okay so one two three four five
let's say okay and this document
confirmation password is not identical
okay sorry one two three four five and
we can say yes
and now it's request to confirm one two
three four five and we now say okay
and now this document is password
protected okay so you can try to attempt
to change anything and it will not
change so for example i try to change
anything and you can see you cannot
change try to change anything you cannot
change try to do anything you cannot and
if you send it to someone
he will not be able to have access to
edit anything within the document you
can only watch you can only look or you
cannot put it
so for you to make use of it for you to
actually edit this document you have to
come over here and say unprotect sheet
and you can put the password over here
one two three four five
six for example you include a six and
you forgot your password and it said no
you cannot open it and this is your
document and you lost it okay try to
both ways
you see unprotect the sheet and you do
one two three four five six seven and
you try to open and it says no because
you have forgotten the password
now this little trick that i will share
with you can help you to break down this
break this password and have access to
your document back again
so to do that all you need to do is to
start by closing out this microsoft
excel okay so you can save if you want
you can come all the way to the folder
where you have that document so this is
it family game business for excel 3d
formulas so you can just okay so what
you need to do now is this is dot xlsx
file okay so to see the extension you
can select it you can come all the way
to view over here to this tree dot okay
you can just click anywhere you can come
to these three dots you can come to
options over here and it's going to show
you our folder options you can come all
the way to view and you can go down to
add extensions for known file types you
can just uncheck this and you can click
on apply and you say okay and you can
see now this is dot xlsx format you can
see it has been highlighted but before
you make any changes to this maybe you
may need to have a duplicate of this
document in cases when you make a
mistake and you cannot be able to refer
back so to make a duplicate of this
let's try we try to create a new folder
and you call it um
broken
password and then we try to copy this
very document here we try to right click
and we say copy and then we can come all
the way to broken password and then we
paste it so you can see right now it is
in the dot xls folder so you just right
click
on the
copied one just right click you can come
to more options and you'll come to
rename
and instead of xls
instead of dot x
l s x you can just come all the way
delete it
and make it dot zip okay so
you do pop up a one are you sure you
want to change it i say yes and it has
made this folder a zip folder okay it
has zipped it this is another way to
to zip your folder okay so it has zipped
this folder
now what we need to do is to try to
double click on the zipped folder
and you can see it has a bunch of
features it has a bunch of bunch of
files okay so you can come to excel file
over here and then you can come to
worksheets okay you just click
and you have a bunch of sheets that we
are working on so to be certain which
seat sheet we are we were working on it
was sheet five okay sheet five
and
we can just select it let's say we are
just going to own password or unprotect
sheet 5
and we can select it and copy it copy to
clipboard
and you can come back to our folder and
can just paste it over here so now what
you need to do is to double click on
this sheet five to try to open it
it's going to pop up that yeah we should
choose an app that we are going to open
with so let's say i'm going to open this
with wordpad
select wordpad and say ok
and we can see a bunch of code a program
okay so but then what we are looking for
is protection so you look for protection
where it is written protected so
but then to do that on the in the
fastest way you just close and you just
press on ctrl f to bring in the find
pop-up and you can just put protection
you can just search for protection
[Music]
okay you can find
and you can see it over here this is
sheet protection and you can see all the
algorithm over here
so let's say we open it up so that you
can see it clearly
so all you need to do is to start by
selecting from this sheet
all the way
down to this point down to this one icon
and the closing of this up to this point
all right
so let's say we we do up to this point
because it has selected this one so
we're going to delete everything from
that we'll just delete
and you can see the opening
is there just like that so just be sure
that you selected it exactly like that
so you just try to
do file and you save us
and we can set save it in the same
format we can go to the main folder we
can save it over here we can save it we
can close this
then we can close this as well we can go
back to the main folder
and we can see the sheet 5 that we've
just edited okay so let's try to bring
it into this broken password okay we
bring it back and replace it with the
one that is in existence
and what we are going to do is to try to
replace the one inside the zipped file
with this one so we just try to
double click to open
all right
so go to excel as before
we go to worksheet and then we will go
up to uh sheet x5 but then we'll just
minimize this
so we bring in this one to replace it
seat five with this sheet five so we
just drag and drop it
and it's going to pop up yeah so we say
okay yeah so we have replaced it so
we'll close on this
and then we can come back to the same
file that we zipped before instead of
dot zip we now right click on it and
then we can come to show more options
and then we can go to rename but this
time around we make it
dot
xlsx
okay so we are now refining it and
bringing it back to the way it was
before so just hit on enter
say are you sure you want to change you
will say yes let's try to open and see
what difference will it bring whether we
can edit it or not just double click to
open
and you can see this is our
microsoft excel so we try to click on
anything you can see we can edit
we can edit anything we can edit at any
given point
we can edit anything so it's now
the protection is gone so the protection
is gone so by just highlighting
that text and deleting it you have
deleted the protection within the
microsoft excel protected document okay
so you can apply that to any document
that you have misplaced the password or
you have forgotten the password just
follow the process and just replace the
first the sheet that you are targeting
all the sheet all the sheets that you
have protected and it will be very very
easy for you to
unprotect the password or remove the
password from that all right ladies and
gentlemen this is just a bit on how to
remove password or break password from
microsoft excel document if you enjoyed
this video please remember to give it a
thumbs up and don't forget to always hit
the subscribe and notification buttons
to stay connected to this channel for
more of our very very useful videos i'll
see you in my next video
bye
[Music]