How to Grant Editing Permissions on Google Sheets

Google Sheets is a spreadsheet application similar to Microsoft Excel but with the added convenience of being accessible online, eliminating the need for software installation. It allows users to share data with others for collaborative work on spreadsheets.

Despite its convenience, sharing data for collaborative work on a spreadsheet can pose the risk of unwanted data loss or alterations.

Therefore, it is crucial to establish editing permissions on Google Sheets. In this article, Officehabit will guide you on how to set up editing permissions on Google Sheets to safeguard your spreadsheet.

Setting Editing Permissions for a Google Sheets File

To add one or more accounts to work on the same Google Sheets file, follow these steps:

  1. Open the spreadsheet and click on the “Share” button at the top-right corner of the sheet if the spreadsheet is already open.
  2. If the spreadsheet is not open, right-click on the file icon and select “Share.”

This will open the sharing settings dialog:

  1. In the sharing settings dialog, enter the email addresses of the people you want to share the spreadsheet with.
  2. Choose the level of access for each person. You can select “Editor” if you want them to have editing rights.
  3. Click “Send” or “Share” to send invitations to the specified email addresses.

Note: You need to name the spreadsheet before performing the action of setting editing permissions for the spreadsheet. If the spreadsheet doesn’t have a name, clicking on the share button will prompt a dialog box with the message “Name the file before sharing.”

Simply enter the name of the file, then press OK to proceed with the process of setting editing permissions for the Google Sheets spreadsheet.

In the “Share with others” window, there are the following sections to pay attention to:

People/Add people and groups: Here, you can enter the accounts of one or more individuals you want to share the file with to collaborate.

After you input the accounts you want to share in the field, the share dialog will change as follows:

Editor: The person granted permission has the right to edit the file exactly like the owner, being able to add or remove data, edit content in the file.

Commenter: The person granted permission has the right to provide feedback, comment on the file through the Comment feature in Google Sheets, but does not have the right to edit the file’s content.

Viewer: The person granted permission is only allowed to view the content without the ability to comment or edit any content in the file.

Notify people: If you want to send notifications to the Gmail accounts that have been granted editing permissions for the spreadsheet, check this box; otherwise, leave it unchecked.

Message: If you choose to send notifications to the person granted editing permissions for the spreadsheet, you can enter a message for that person in this field.

After completing these steps, click Send to complete the process of setting editing permissions for the Google Sheets spreadsheet.

How to Change Permissions for an Account with Editing Access in Google Sheets

After sharing editing permissions for a spreadsheet with another account, you can also change the permissions for that account. To modify the editing permissions for a spreadsheet, follow these steps:

  1. Open the Share with others dialog: Click on the Share icon in the top-right corner of the spreadsheet.
  2. In the opened dialog, click on the permission box next to the account name you want to modify. You can choose the permissions for the account just like when setting them up initially. Additionally, you can select Set as owner to make that account the owner of the file or Remove to revoke editing permissions for that Google Sheets account.
  3. After making your selections, click Save to complete the modification.

In the above article, Officehabit guided you on how to set up editing permissions for Google Sheets, helping safeguard your spreadsheet when sharing for collaborative work with other accounts. Best of luck implementing these steps successfully!

Leave a Comment

Your email address will not be published. Required fields are marked *

Shopping Basket
Scroll to Top