How to Unlock Specific Cells in a Protected Sheet in Excel | Unlock Scrollbar, Checkbox, Drop-Downs
131.4 هزار بار بازدید -
4 سال پیش
-
In this video, I will
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
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
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
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
4 سال پیش
در تاریخ 1398/12/15 منتشر شده
است.
131,449
بـار بازدید شده