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 cells for editing in excel
how to unlock for editing excel sheet
how to open editing in excel
how to unlock excel for editing in teams
how to open editor in excel
how to get edit in excel
how to open enable editing in excel
how to open vba editor in excel
how to open macro editor in excel
how to open vba editor in excel mac
how to open query editor in excel
how to open vba editor in excel 2016
how to open vba editor in excel office 365
how to open code editor in excel
how to open vba editor in excel 2007