unlock

How to Lock and Unlock cells in Excel

0:00
↔️ ↕️

Timecodes:

here I'm going to show you another way

that you can protect your worksheet

where you don't have to worry about

entering passwords now what I mean is

for instance say that we want the

benefits column to always be editable

but we don't want anything else in a

worksheet to be able to be edited and we

don't want to have to enter a password

to edit the benefits part now a very

simple way to do this is to I'll show

you by example first right click one

cell and click format cells now if you

go to the protection tab you'll notice

this locked and there is a box next to

it that's always checked now by default

it's checked so all of them are checked

if you uncheck this once click OK then

go to tools protection protect sheet and

here have select unlocked cells checked

but do not allow locked cells to be


Related queries:


how to unlock a excel file that is locked by another user
how to unlock a excel file without password
how to unlock a excel file protected by password
how to unlock a excel file that is locked for editing
how to open a excel file in python
how to open a excel file without password
how to unprotect a excel file
how to open a excel file in r
how to open a excel file as read only