unlock

Protect a Sheet in Excel But Leave Some Cells Unlocked

0:00
↔️ ↕️

Timecodes:

Hello and welcome to this Excel tips video. I am Sumit Bansal and in this video I'm going

to show you how to protect an entire worksheet, but have a range of cells that are unprotected,

and can be edited.

So here I have this worksheet. And what I want to do is protect this entire worksheet,

except these cells, because I want to share this worksheet with someone who can edit these

cells, but I don't want that person to make changes in the remaining part.

So the first thing I would do is select this range that I want to keep unprotected, go

to the Review tab and click on 'Allow Edit Ranges'. And when I click on this option,

it will show me this dialog box where I can specify a range that can be unlocked with

a password, or it can be unprotected without a password.

In this case, when I click on New, it'll ask me for a Title. I'll keep it Range1 for now,

and it refers to the selected range. And in this case, I can give it a password, or I

can leave it as is. If I don't give it a password, this can be edited by anyone, and if I give

it the password, then someone will have to enter the password and this would become unprotected.

And now I would click okay (without giving a password). And now this has been added.

Now I would click on this button called protect sheet, and I would give a password to protect

the entire sheet.

If you do not want to give a password, you can leave this empty, but in this case, let

me give it a password, and click okay. It'll ask me to reenter the password, so I will

do it again. Click okay, and now this entire work sheet has been protected. If I try and

change this, it is not going to allow me to do it. I would have to first unprotect the


Related queries:


how to unlock excel sheet for editing without password
how to unlock excel sheet for editing online
how to unlock excel file for editing
how to unlock excel file for editing on mac
how to protect excel sheet for editing
how to unlock excel file for editing in teams
how to unlock excel file for editing online
how to open excel sheet for editing
how to unlock excel file for editing by me