hi my name is hamsa Jacobs I'm an IT
trainer with New Horizons in London I'm
here today just to show you a couple of
cool little tips and tricks on Windows 7
and office 2010 how to unprotect a
worksheet in Microsoft Excel some of you
may be working with protected worksheets
this basically means that as you can see
on this file I'm trying to type I cannot
it basically means that all the contents
of that particular sheet being the BnB
product sale sheet has been protected
and cannot be manipulated or modified
have a look my home tab all of these
options are grayed out
I cannot choose any of them I can't make
any changes anyway this is because this
sheet is protected so to unprotect the
sheet it's pretty straightforward all
you need to do is go to review at the
top and this gives you the unprotect
sheet option now when a sheet gets
protected it would most likely have been
protected with a password now the
password is optional you do not have to
enter the password so you may find that
you can click unprotect and it
immediately just removes the protection
in this case I've added a password in so
when I click unprotected remember we go
to review and protect I get prompted for
the password I have to enter the
password it then gets unprotected
alright so quite important so just to
show you if I hit protect and I do not
enter a password here now you see once
again everything is protected can't
change anything when I go to review I go
unprotect it does not ask me for
anything
but now you'll notice on the home
I can do anything I like here I can
change these numbers now and change that
can change that to total sales Babs my
sheet is unprotected
that was how to unprotect a worksheet in
Microsoft Excel