hi and welcome to how tech tutorials in
this video we will show you how to
unprotect
Excel spreadsheets and workbooks easily
this tutorial is for basic users getting
started with Excel and once you
understand how to unlock protected
sheets or workbooks in Excel over here
we have an excel file opened up and as
you can see that we can't change
anything in the spreadsheet Excel gives
us a prompt that the sheet is protected
similarly we are also unable to add a
new worksheet this means both the
spreadsheet and the entire workbook is
protected to unprotect a worksheet you
can right click on the sheet tab at the
bottom over here and select the
unprotect sheet option you can also open
up the format drop-down menu in the
cells section under the Home tab and
from here you can unprotect this sheet
as well lastly you can also move to the
review tab and from here you can click
on the unprotect sheet option if the
sheet is password-protected you would be
required to enter the password to
unprotect the sheet now you can see that
the spreadsheet is unprotected and
changes can be made on the spreadsheet
to unlock the workbook simply click on
the protect workbook option if the
workbook is password protected you would
be required to enter the password to
unlock the workbook once done you can
see here that now we can freely add more
sheets in the workbook it's important to
remember and store the password if the
Excel spreadsheet or workbook is
password protected that's all what would
you like to know about Excel functions
let us know in the comments below thank
you for watching if you like this video
don't forget to give it a thumbs up and
subscribe to our Channel and make sure
to press the bell button to be the first
to know about our new videos