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 unprotect excel sheet 2007
how to protect excel sheet 2007 with password
how to protect excel sheet 2007
how to unprotect excel 2007 sheet without password
how to open excel file 2007 in 2016
how to open excel 2007 file in office 365
how to open unsaved excel file 2007
how to open corrupted excel file 2007
how to remove password protect excel file 2007
how to get back unsaved excel file 2007