How to Unlock Specific Cells in a Protected Sheet in Excel | Unlock Scrollbar, Checkbox, Drop-Downs

In this video, I will show you how to unlock specific cells in cells when you have locked the entire sheet.

I cover the following three scenarios in this video:
-- Unlock selected cells in Excel (in a protected sheet)
-- Use Scrollbar, Checkbox, Drop-down, etc. in a locked sheet
-- Unlock cells that have a specific value of color in it

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.

[ams]

Thank you very much - this was useful and straight to the point.

[prachigharat]

Thank you for the video! Such a life saver!!!

[laniefigueroa]

Very helpful and easy to follow presentation. Thank you very much!

[Jason-Woolf]

Excellent - clear and to the point - with a few bonus tips as well - great video!

[justineabundo]

Thank you very much for this video! I’ve been watching many videos but this one is what I’m looking for!!! Helped me a lot with my file!!!

[Thomas-iccd]

Very nicely and easy to understand. Thank you

[wayneedmondson]

Thanks Sumit! Nice tips :)) Thumbs up!!

[MareeTeolanafo]

Well presented as always and easy to follow; I look forward to more informative videos.

[Ali-uzqg]

Thanks. I learned today how to unlock colored cells.

[timbabitelor]

Thank you Sumit, I just learned now that Ctr+H can select colours. I see those buttons all the time but never thought of exploring it!

[LearningHome-trainings]

Another interesting content from Sumit. Please keep the great job going.

[marianagomez]

wooow you saved my projecttt, thank you so much for your videoooo

[joear]

Can you disable the popup message "The cell or chart you're trying to change is on a protected sheet..."?

[BounceEV]

Great video, looks so simple. After protecting the sheet, what happens when the format cells is not available to select...?

[subhodeepsengupta]

I am a great fan of your videos, got inspired and started to educate people about the importance of Excel in the current market. Waiting for more of your videos.


Do share your views on the same.
Thanks,
Subhodeep Sengupta

[teresachang]

Thank you for the video. I am using Excel 365. After I clicked on Protect sheet, the Format Cell feature is grey out. I was not able to unlock the specific cell I prefer to keep unlocked. Which version of Excel you were using on this video?

[sweetyreddy]

Can we lock values in table in the sheet and also get the table expanded?

[real_shortreels]

Is there any way to add a filter in a protected file, which already has unlocked heading?

[rachelcorcoro]

Hello hope you could help me with my concern, if I choose on the dropdown list then the template will be enabled, however the columns that were not needed will be disabled. Do you know how?