have you ever experienced such a
situation like when you try to edit the
Excel cells only to find you can't or a
situation where you can't rename move or
copy excel sheets
here comes the solutions in today's
video I will show you four ways to
remove passwords from Excel worksheets
or workbooks without passwords solution
one use Google sheet please backup your
Excel worksheet first in case of data
loss as you can see this worksheet is
not editable now let's go to Google
sheet and start with a blank spreadsheet
you should navigate to file and choose
import go to upload tab in the new
screen then drag your password-protected
worksheet to Google sheet
[Music]
here we need to press import data button
to continue we need to wait for a while
now double-click one cell and you'll
find it's editable now you can directly
edit your worksheet here or choose to
download and edit the sheet in Microsoft
Excel
[Music]
now let's make a summary of this method
this method is free and easy to use but
it will take time to upload if your
excel worksheet is large and a stable
and powerful internet connection is
necessary solution to change file
extension
locate your password-protected excel
worksheet and change its file extension
to zip
[Music]
choose yes if any dialog pops up open
the zip archive and go to excel
worksheet double-click to open it right
click on the lock sheet select edit to
open it in notepad
press ctrl F to find sheet protection
and delete the whole stream remember to
save the file
now update the modified XML file
we need to change the file extension
back to xlsx
[Music]
open your Excel worksheet and you can
edit it as you want summary of this
method this method doesn't work for all
Microsoft Excel versions and if there
are several locked worksheets in your
excel file you need to repeat the above
operations one by one solution 3 use VBA
code
locate your password-protected Excel
worksheet and open it with Microsoft
Excel then press Alt + f11 to bring out
the visual basic screen navigate to
insert module a blank screen will pop up
now insert the VBA code into it press f5
to run the code
the program is running it will take some
time to finish and we won't wait for the
result here summary of this method this
method is a little bit complicated for a
computer novice and it's time-consuming
sometimes since you need to unprotect
the locked cells one by one what's more
there is a risk of damaging your data
since you need to enter some codes
solution for use pass purge for Excel
download install and run pass per for
Excel on your PC choose remove
restrictions on the main interface click
select a file to import your locked
excel sheet
then click the Remove button to begin
the removal process just within a few
seconds your excel sheet will be
unprotected and now you can edit the
sheet as you wish
[Music]
let's make a summary of this method it's
truly easy to use and 100% works the
removal speed is super fast that's all
for today's video thank you for watching
don't forget to subscribe and drop a
like
[Music]