Google Sheets - Conditionally Lock Cells Based on Other Values
You can prevent users from accessing certain cells in a Google Sheet based on the values in specified ranges. Learn how to do this with three different examples. Then, we will discuss a few alternatives.
🕒 Timestamps:
0:00 Intro
0:44 Based on the values in one column of cells
3:55 Locking out multiple columns of cells
5:39 Locking out range based on one fixed cell
7:03 Not a security measure
7:58 Alternatives
Learn more from Prolific Oaktree:
🌳 Next Video - Learn how to sort and filter the responses in Google Sheets: • Google Sheets Basics #5 - Sort and Fi...
🌳 Related Playlist - Google Apps | Full Tutorials - https://bit.ly/full-tutorials
#googlesheets #spreadsheets #datavalidation
Watch video Google Sheets - Conditionally Lock Cells Based on Other Values online without registration, duration hours minute second in high quality. This video was added by user Prolific Oaktree 04 June 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 98,130 once and liked it 582 people.