unlock

Locking and Unlocking 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 saying 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 unlock cells checked

but do not allow locked cells to be


Related queries:


how to unhide columns in excel
how to unlock cells in excel
how to unhide columns in excel shortcut
how to unlock cells in excel when scrolling
how to unlock cells in excel without password
how to unhide columns in excel far left
how to unhide columns in excel mac
how to unhide columns in excel 2010
how to unhide columns in excel at once
how to open columns in excel
how to unhide columns in excel mobile
how to unhide columns in excel google sheet
how to unlock cells in excel mac
how to unhide columns in excel using keyboard
how to unhide columns in excel spreadsheet