hey everyone and welcome back to the
channel uh I have an extra seat here I'm
gonna bring it to the middle I'm gonna
double click and open it and it's
opening now as you can see I have two
seats here I'm gonna right click on the
seat named staff's Edge and it's
protected as you can see now let's try
and hit and type any data
and it's it won't let me because it's
protected and I don't know the password
of it and this is actually happening in
so many cases uh there may be cases
where you have given your date CLD your
data to your colleague and you you just
wanted to make sure that uh he doesn't
alter your data and hence you protected
the seat or you just want simply wanted
to protect the seat because the content
of the seat was so valuable to you but
after some time you try to open the seat
again and you do not know the password
and you have to make some changes now
how can you recover the password or how
can you unprotect the seat in this video
I'm gonna tell you exactly how to do it
the very first thing I want you to do is
go to the seat which is protected for me
it's in my desktop for you it can be
anywhere just go to the location now I
want to make sure that I do not get the
original file destroyed so I'm gonna
right click and create a new folder
click on new and click on folder I'm
gonna name it on protection feet
I'm going to
right click on to see that I want to
protect I'm going to click on copy I'm
gonna click click on the sheet I just
created and I have misspelled on
protecting but I guess that's okay I'm
gonna right click and paste it here
now the very first thing that I want you
to do is make see the extension of the
seat you just created but for me I
cannot see an extension name as you can
see here now in order to make sure that
you can see the extension I want you to
go to file menu I want I want you to
click on options
uh window will pop up and I want you to
click on view tag now let's drag it down
and
if you if you see here there is a tick
mark right next to hide extensions for
known file types I want you to remove it
click on it and it will be gone now
click on apply and click on OK there you
go now you can see that the extension of
this Excel sheet is dot xlx as X and now
it must be visible to you as well what I
want you to do is right click on the
seat and click on rename
now rename the extension to Z IP
there you go uh a window will pop up it
will ask you if you if you're sure about
it click on yes
now it's zip now I'm gonna double click
on it and once again a new window will
pop up I'm using a win RAR software uh
if you're using any other software uh
this window may look a little different
to you but the content and the steps are
absolutely same so just follow along now
click on Excel and click on worksheet
now you have you will see there are two
worksheet and if you recall I had to
work it actually and I wanted to protect
this seat number two so I'm gonna right
click and I'm gonna copy this sheet
coffee files to clipboard that's it I'm
gonna close this window I'm gonna close
this window all as well I'm gonna paste
it here on my desktop
and I can paste it let's go back and
copy this it again
let's click on Excel again let's click
on worksheets and there you go what I'm
gonna do is simply minimize it and I'm
gonna minimize this as well and there
you go I'm gonna drag this xc2 and bring
it here and there you go it worked now
this is what I wanted I'm gonna break it
bring it in the middle I'm gonna right
click
and I'm gonna open with click on open
with and click on Notepad
there you go there is a lot of data and
I want to see make sure you want if you
want to see this clearly I want to go to
format and make sure uh it's word wrap
is uh a tick mark is uh on right next to
it if not click on word wrap uh for me
uh I want to use word wrap so click on
word wrap and there you go now it's
visible now I'm gonna click go to edit
and click on find
and click on protect
and search Project I'm really sorry for
that click on find next and there you go
there is there it is
now what I want you to do is uh find the
smaller
less than symbol and select
the data
up to the location where the greater
than symbol appears and click backspace
to delete it now it's deleted I'm gonna
click on file and I'm gonna click on
Save now it's saved I'm gonna close this
window now what I want you to do is open
the folder again I'm gonna make sure
this is visible to you I'm gonna click
on the zip folder that you created a few
moments ago click on Excel again
click on worksheets and now I want you
to
copy the sheet that you edited and
replace it with the sheet we have here
where there you go it's here now I'm
going to Simply drag it and drop it in
this folder
uh a pop-up will appear now just make
sure that uh it's add and replace files
set here if not click on the drag drop
drag icon and click on ADD and replace
files
click on OK
and there you go it has been updated now
I'm gonna
close this window I'm gonna open the
window again now I want you to change
the extension
of this uh sheet of this folder again in
order to do that right click and click
on rename
now I'm gonna rename it back to xlsx I'm
gonna click I'm gonna hit enter it will
ask me the same thing again I'm gonna
click on yes
and as you can see it's back to Excel
form now I'm gonna click right click and
open it
now it's opening
and yes it's it has opened now I'm gonna
I'm going to right click here and it's
not protected anymore let's write and
enter any data
subscribe to my channel and as you can
see it's working right the seat is not
protected anymore and if you have follow
along all the steps it must be working
for you as well thank you for sticking
till the end and watching the video
it takes a lot of effort to make these
kind of videos uh if you like such
videos and want to learn more about
Excel please subscribe to my channel