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 cell in excel
how to unlock a cell phone
how to unlock a cell phone for free
how to unlock a cell phone without the password
how to unlock a cell in google sheets
how to unlock a cell phone from a carrier
how to unlock a cell phone screen lock
how to unlock a cell in excel without password
how to unlock a cell in word