hello guys this is Jay so for this video
on to can't show guys how to break the
excel what's your password so this
something that I'm always hesitate to do
unless it's very necessary and I just
want to say that I don't try to break
pass or like sell file that you do not
own so let's say if you down a
commercial Excel workbook and the Excel
workbook is work she pretends to be
honest those are the ownership of the
person who create the excel file and the
person may spend handjobs hours they'll
create something Duff trying to make a
passive income so only do these wings
very necessary so now let's go into
details on how you can break the
worksheet password Excel so Ram using
our office 2016 so Excel 2016 is the
Excel version and I'm using and this
will basically apply to every single
version Excel so here I have a excel
file and I have two worksheet and
worksheet a and customer worksheet and
both work Shia passport 4/10 so if I try
to type something and I'll get the
message saying that the cell chart
you're trying to change
you sound up attack worksheet and to
make a change I need to are enter the
password and on put head worksheet you
know as far as you know what she a it is
also a worksheet protect and to break
the password first of all let me click
so you want to close the excel file and
make sure that the excel file is saved
on your hard drive and here's the excel
file so the first step is make a copy of
the excel file so that way that when you
are corrupt the excel file at least you
know you have a copy in next you want to
go to home so so for the default you
don't have the extension name display so
to display the extension select hello da
excel
sex and you want to go to home and sure
you want to go to view sorry good review
if you are on Windows 2010 you can just
check the filename extensions checkbox
so make sure that's checked but
otherwise you want to go to our folder
options and go to options and change for
them and these search options and under
view under the View tab you want to go
down to look for Missy
hide extensions for known file type so
make sure that that's uncheck and click
on OK and once you do that that will
display the file extension name and next
you want to change the extension name to
our zip file so change to the IP and
found a point of time you want to double
click this will show you all the XML
file the compile that creates the excel
file and so you want to go down to the
Excel folder then go to the worksheets
folder and here we have two XML files
and one is for the worksheet a yeah in
the otherwise for the customer would
shape and grab this to file and make a
copy and paste in your folder anywhere
in your folder I'm using notepad plus
plus you can use any type of text editor
even notepad will work and so you open
the XML file with a notepad and here's
what the XML file looks like and so you
want to go down twist the N so you want
to look for sheep potassium so this the
Sheep protection tag and so we want to
copy from the beginning so beginning of
the shoe protection all the way to the
end
so from scenario the end tag and then
just delete
just ideally should me just double-check
okay and save the file and I'll do the
same for the other worksheet so let me
open too
and I'm going to open the file with
notepad and you want to go down twist
the N and so remove the strip attention
tag and save the file now let's go back
to the other zip folder so what you want
to do is you want to replace these two
files with the existing files are in the
exit file so it's going to copy and
paste over and now that's finish so I
can close these two folder window and I
don't need this to XML file anymore so I
can just leave I can just delete these
two files okay
and the last step is you want to change
the extension the zip extension back to
xlsx and this will come back this is the
file back to excel file and now we open
the excel file and if you go down to the
worksheet right click you see that now
the water is being unperturbed so now if
you want to make some changes like
insert a new transaction ID and can do
that now so same with T would see a you
can type a hello world as well
so this basically the step da you will
follow to break the worksheet password
on excel file again I just want to
emphasize the only big the worksheet as
well when it's necessary and make sure
that you have the ownership of the files
are you walk on so this is everything I
want to show you guys today if you found
this video useful please seem to like
and subscribe to my channel and thank
you for watching and tell you guys soon
bye bye