unlock

How to Lock and Protect Individual Cells in Excel + Bonus Tips for Quick Setup

0:00
↔️ ↕️

Timecodes:

welcome to Excel campus my name is John

and in this video I'm going to explain

how to lock individual cells for editing

in Excel so here we have a quote sheet

that your team or co-workers might be

filling out and we only want them to be

able to edit specific cells in the sheet

some of the cells contain formulas and

we don't want them to accidentally

delete these cells or edit them and this

is actually a two-step process in Excel

the first step is that we're going to

lock or unlock individual cells and then

we are going to protect the worksheet so

we'll first take a look at this cell

here it does contain a formula so we

want to make sure this cell is locked so

we're going to right-click the cell and

choose format cells and that will bring

up the format cells window and on the

protection tab here we have a check box


Related queries:


how to get a dropdown in word
how to get a drop down menu in word
how to unlock drop down in word
how to get drop down box in word
how to get drop down list in wordpress
how to get rid of dropdown in word
how to unlock drop down list in word
how to edit locked selection in word
how to unlock selection in word