How to Lock Range in Google Sheets

0:00 So you're trying to lock a range in Google Sheets. You're trying to get people not to edit it. You're trying to protect them from editing this particular data . We don't want this data to change. For instance, it's 2024 and we want 2023 sales to not be edited. However, we may have altercations modifications. We do need to edit around that data . So we just want to protect the specific range here. I've selected B2 to be 11. That's the range that I want to lock right now. So no one else can edit that. I'm going to hit the down arrow. I'm going to click protect sheet. And Look at that. It's already selected the range I have selected. If we however want to increase or edit or change this in any way, we can. We can say to be 13. Set permissions, and here we have two options. We're going to show a warning when Editing this range, which is really good. Password Protecting Data In a Google Sheet Part 2 The Basics Getting Started in Google Sheets Spreadsheet Management Password Protecting Data In a Google Sheet Part 2 The Basics How to Protect Spreadsheet From Yourself

0:47 If you just want to slow people down from editing, but if we want to restrict anyone else from editing this range , we're going to restrict who can edit this range , select only you and click done here. You can see we have added that range to our list of ranges that are protected. If you're looking for this protected sheets and ranges . Go up to data . Protect sheets and ranges and you can see all of the options here. These are already been set and we can always click on them, delete them and edit them in any way we can change permissions. If you're looking to get more out of your Google sheets than you ever have before, consider subscribing here on YouTube to better sheets. Pros and Cons of Sheet Protection and Collaboration Getting Started in Google Sheets Spreadsheet Management Password Protecting Data In a Google Sheet Part 2 The Basics How to Protect Spreadsheet From Yourself