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 without password
how to unlock a cell in excel formula
how to unlock a cell in excel vba
how to unlock a cell in excel 2016
how to unlock a cell in excel 2010
how to open a cell in excel
how to open a cell in excel using keyboard
how to get a cell in excel
how to open a cell in excel without mouse