Setting Edit Permissions To A Range of Cells In Google Sheets
Sharing and collaborating on worksheets is one of the benefits of using Google Sheets. At the most basic level we can grant permission for someone to edit a spreadsheet. This permission allows access to the complete workbook and all the spreadsheets. There may be times when we don’t want to grant access to edit some part of a spreadsheet. In this case, we can grant permission to edit specific sheets or ranges of information.
In this example, we want to provide edit access to specific cells in the sheet. We want to provide access to one range of cells for one account and permission to another range of cells for another account.
Click on “Data” in the menu and select “Protected sheets and ranges”.
A configuration panel will open on the right side. Click on “Add a sheet or range”.
We need to provide a short description for this permission.
We’ll provide the name of the campus that will have access to this range of cells. The range option is selected for us in this example, click on the range button if this option is not selected. In this example, one of the rows is selected for me. This is a row I was working on before.
To select the cells for this account, click on the cell icon.
We need to select one or more cells for the range.
Click and drag to select a range of cells.
In this example, cells C5 to C16 in sheet “Open Questions” is selected. Click the “OK” button to save the selection.
We need to designate who will have access to this part of the spreadsheet for editing. Click on the “Set permissions” button.
A permissions pane will open.
Click on the restrictions pull down menu and select the custom option.
Provide an account name in the editors field.
Provide the information for one or more accounts. Click the done button to grant the user access to this range of cells in the spreadsheet.
The permission setting appears in the panel on the right.
We can repeat the same process to grant edit access to other range of cells in this sheet.
We can add or remove accounts that have access to a range of cells. Click on a permission in the panel.
Click on the “change permissions” button.
Click on the check mark to remove it from an account. Click the done button to save the changes.
Click the done button to save the permission update.
To remove edit access, click on the restriction in the panel.
Click the trash can icon.
Click the remove button to confirm.