How to set up the right to edit spreadsheets on Google Sheets

When working on Google Sheets online, if you want to restrict editing of certain column or row data areas, you can set editing rights on Google Sheets.

For those who do not install the Office suite on their computer or want to quickly create a spreadsheet, they will immediately think of Google's online Google Sheets application. Providing users with similar spreadsheet implementation options when done on Excel, users can easily create a complete data sheet. Especially Google Sheets also supports many online operators on certain data files.

However, if you want to restrict an Excel column or row area from editing, or for some editors, how? In this case we will use the feature to set the right to edit cell, sheet, area available on Google Sheets.

1. How to edit the Google Sheets area:

Step 1:

First we will access the spreadsheet you want to decentralize on Google Sheets. Next, click on the Tools tab and select Protect sheet .

How to set up the right to edit spreadsheets on Google Sheets Picture 1How to set up the right to edit spreadsheets on Google Sheets Picture 1

Step 2:

Right after that, the right side of the spreadsheet will appear with a Protected sheeets and ranges column. Here, we will select the Range tab, then click the grid icon to select the range of data you want to set permissions.

How to set up the right to edit spreadsheets on Google Sheets Picture 2How to set up the right to edit spreadsheets on Google Sheets Picture 2

Then, you localize the data you want to set editing permissions. We can choose one column, one row or any other data area. Once you've selected the area, click OK .

How to set up the right to edit spreadsheets on Google Sheets Picture 3How to set up the right to edit spreadsheets on Google Sheets Picture 3

Step 3:

Continue to click Set permissions .

How to set up the right to edit spreadsheets on Google Sheets Picture 4How to set up the right to edit spreadsheets on Google Sheets Picture 4

Step 4:

Shortly thereafter, a dialog box with Range editing permissions appears . We will see the option Restrict who can edit this range has been selected.

We can authorize anyone to edit the marked data area, otherwise we can leave you (Only you).

How to set up the right to edit spreadsheets on Google Sheets Picture 5How to set up the right to edit spreadsheets on Google Sheets Picture 5

To edit permissions, click Only you and select Custom .

How to set up the right to edit spreadsheets on Google Sheets Picture 6How to set up the right to edit spreadsheets on Google Sheets Picture 6

Step 5:

Appointment editing options appear. If there are members participating in editing this data, you want to assign permission to not edit it , just leave the account at that account .

To add editors , we enter the email address in the Add editor box. Then click Done at the bottom to save.

How to set up the right to edit spreadsheets on Google Sheets Picture 7How to set up the right to edit spreadsheets on Google Sheets Picture 7

So we have the right to edit a certain area in the Google Sheets spreadsheet.

2. How to assign permission to edit sheets in Google Sheets:

Step 1:

First of all, click on Tools and select Protect sheet . Protected sheeets and ranges interface appears on the right of the screen. Here, we will select the Sheet tab .

How to set up the right to edit spreadsheets on Google Sheets Picture 8How to set up the right to edit spreadsheets on Google Sheets Picture 8

Step 2:

Then localize the sheet to be authorized and click Set Permmissions .

How to set up the right to edit spreadsheets on Google Sheets Picture 9How to set up the right to edit spreadsheets on Google Sheets Picture 9

Step 3:

Next, we also proceed to decentralize the members, more members are allowed to edit in the Google Sheet spreadsheet.

How to set up the right to edit spreadsheets on Google Sheets Picture 10How to set up the right to edit spreadsheets on Google Sheets Picture 10

3. How to manage Google Sheets editing rights:

After we have the right to edit cell, sheet on Google Sheets, we can edit and change the assigned permissions.

Step 1:

At the spreadsheet, click the Tools tab, then select Protect sheet .

How to set up the right to edit spreadsheets on Google Sheets Picture 11How to set up the right to edit spreadsheets on Google Sheets Picture 11

Step 2:

Soon we will see a list of permissions that have been set on the spreadsheet. To edit the set permissions, simply click on the right.

How to set up the right to edit spreadsheets on Google Sheets Picture 12How to set up the right to edit spreadsheets on Google Sheets Picture 12

Step 3:

We can add a description for that permission , edit the authorized user in the Change permissions , or delete the set permissions when clicking the trash icon . Finally click Done to save the edit.

How to set up the right to edit spreadsheets on Google Sheets Picture 13How to set up the right to edit spreadsheets on Google Sheets Picture 13

As such, we have completed the setup tasks of editing the data area in the online Google Sheets spreadsheet. With this authorization, users will be able to protect the worksheet, not allowing anyone to edit any data.

Refer to the following articles:

  1. How to change folder ownership in Google Drive
  1. Tricks using Google Sheets should not be ignored
  1. How to convert the currency of each column, row in Google Sheet

I wish you all success!

5 ★ | 2 Vote