Is it possible to protect 1 sheet or part of a sheet?

[Burrgogi]

I remember googling this issue a few years back and it's my understanding that you CANNOT protect just a portion of a sheet or even just 1 single worksheet within a workbook. I ran into someone who claimed to be an Excel expert - she says she uses Excel frequently for her job. She says it is possible. I really don't think she's right. But I'm also open minded to being corrected about this issue since I do not use the latest version of MS Office.

What say you experts here on the forum?

 

[Skyybot]

It is possible.

 

[Burrgogi]

It is possible.

Please explain how that's possible because I'm using MS Office 2010 and I don't see any feature whatsoever to protect just 1 worksheet amongst many within a workbook. Also I'd like to know which MS Office version this new feature was introduced.

 

[Skyybot]

I'm using Office 365. I can't remember when this feature was introduced, but to be honest, I don't ever remember this feature not being available.

 

[Fluff]

You have always been able to protect a single sheet, or part thereof.
It's on the Review tab of the ribbon.

 

[Skyybot]

You have always been able to protect a single sheet, or part thereof.
It's on the Review tab of the ribbon.

@Fluff, thank you. I though I was loosing it for a second there. I wish I would've kept all of my older versions for just this reason.

 

[Burrgogi]

OK I see the 'protect' feature in the Review tab, don't know how I could have missed that. As I mentioned earlier, I googled this issue several years ago and I may have conflated these 2 issues:

protect worksheet
protect just a portion of a worksheet

 

[Fluff]

To protect a portion of the sheet select the cells you want to be editable, right click, format cells & on the protection tab uncheck the "locked" box

 

[Burrgogi]

To protect a portion of the sheet select the cells you want to be editable, right click, format cells & on the protection tab uncheck the "locked" box

Uncheck that box?? Seems a bit counter-intuitive.

 

[Fluff]

Yes, because that will unlock the cells so that you can edit them.