To lock a row in Google Sheets, right-click on the row number, select “Protect range,” and then set the permissions as needed.

To lock a row in Google Sheets, you typically want to protect certain data or prevent accidental editing by others. Here’s a more detailed step-by-step guide on how to do this:

1. Open Your Google Sheet: Start by navigating to the Google Sheets document that you want to edit.

2. Select the Row: Click on the row number on the left side of the sheet to highlight the entire row that you would like to lock.

3. Right-Click: Once the row is selected, right-click on the highlighted number. This will open a context menu.

4. Choose “Protect range”: From the context menu, select the option that says “Protect range.” This will bring up a sidebar on the right side of your screen.

5. Set Permissions:

– In the sidebar, you can give your protected range a description to help identify it later.

– You’ll see an option that says “Restrict who can edit this range.” Click on it.

6. Choose Edit Permissions: Here you can choose how you want to restrict access:

– Allow only specific people to edit this row.

– Restrict it so that only you (the owner) can make edits.

7. Click “Done”: After you’ve set your permissions, click the “Done” button to save your changes.

8. Check the Protection: To confirm that the row is protected, you can try to edit it while logged in as a different user (if applicable). You should receive an alert indicating that the range is protected if everything is set correctly.

9. Managing Protected Ranges: You can manage all protected ranges by clicking on “Data” in the top menu and then selecting “Protected sheets and ranges.” Here, you can edit or remove existing protections as needed.

By following these steps, you can effectively lock a row in Google Sheets, safeguarding crucial data from unwanted changes while allowing designated users to have the necessary editing rights.