1
Open the Google Sheets document
Open the Google Sheets document
How to lock a row on Google Sheets
This guide provides step-by-step instructions on how to lock a row on Google Sheets. It explains why someone might want to do this, such as preventing others from making changes or receiving a warning when changes are made. The guide also covers additional features like setting permissions and creating custom permissions
Accounting & Finance
2
Right click on the row you want to lock
Right click on the row you want to lock
3
Select the View more row actions option
Click the "View more row actions" option at the bottom of the context menu to reveal additional settings.
4
Select the Protect range option
Click the "Protect range" option in the sub-menu to open the protection settings.
5
Optionally, you can give your range a title. For example, this locked row is called "Lead List"
Optionally, you can give your range a title. For example, this locked row is called "Lead List"
6
Click the Select data range icon
Click the grid icon inside the range input field in the sidebar to choose the cells you want to protect.
7
Once your range is selected, click "Ok"
Click the "Ok" button in the Protected sheets & ranges sidebar to confirm the selected range.
8
Optionally, change the sheet
Optionally, change the sheet
9
Click the Set permissions button
Click the Set permissions button in the Protected sheets & ranges sidebar to configure access for the selected sheet.
10
Select if you would like to show a warning when editing the range, or restrict who can edit the range
Select if you would like to show a warning when editing the range, or restrict who can edit the range
11
You can create custom permissions by clicking "Custom"
You can create custom permissions by clicking "Custom"
12
Click the "Enter names or email addresses" input field
Click the input field under "Add editors:" in the modal to specify who can edit the range.
13
Click the Add editors input field
Click the Add editors input field in the Range editing permissions modal to enter the email address of the person you want to grant access to.
14
Click the Done button
Click the Done button at the bottom right of the Range editing permissions modal to save your changes.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.