Thursday, January 20

How to change the property of a Google sheet

Changing jobs and wondering what to do with all your data on Google Sheets? Do not worry. There is a way to change ownership in this popular spreadsheet program.

When you create a Google Sheet, you are, by default, the owner. However, you can just as easily allow someone else to enjoy this permission. In this article, we’ll show you how it’s done.

Change ownership in Google Sheets

When you create a Google Sheet, you have permission to not only view the spreadsheet, but also to add changes, comments, or even delete it entirely. In a situation where you want to change ownership, here is what to do:

  1. Open the sheet you want.
  2. Then find “File” in the upper left corner of the sheet.
  3. Below the “File” button, you will see “Share.” Click on it.
  4. “Share with people and groups” will open. You will see the list of people who have access to the Google sheet.
  5. Find the person you want to be the owner of the sheet.
  6. On the right, next to its name, you can select different options. Click on “Make Owner.”
  7. A pop-up box will appear to confirm the changes made. Finally, select “Yes” to confirm and then click “Done”.

You will receive a message informing you that you have transferred ownership. Once you finish all the steps, you will not be able to take back the property, unless the new owner grants you permission. However, you will still be able to view and edit the contents of the sheet.

Note: You need to be very careful when making someone the owner of the sheet, as they can remove your access to it.

Change Google Sheets property

Important things before changing ownership

There are some things you won’t be able to do once you change ownership, so be sure to read the following information carefully before doing anything.

First of all, you won’t be able to share the Google Sheet with other people. Only the new owner will be able to do so. Second, the visibility option will not be available to you. Therefore, you cannot see who has access to that particular sheet. Finally, you will not be able to grant editing or commenting permissions to collaborators.

For these reasons, we’ve rounded up other Google Sheet features that may be worth checking out.

Other Google Sheet Permissions

If you decide not to make other contributors the owners of the sheet, you can grant them other Google Sheet permissions, such as edit and comment.

Edit permission

With the edit permission, other Google Sheet users can edit the cell content and modify it according to their needs. This is always recorded in the revision history. As long as someone wants to check the previous editions, they can. Here’s how you can grant edit permission:

  1. Open the sheet.
  2. Then find “File” in the upper left corner of the sheet.
  3. Click on “Share” below it.
  4. When the window appears, add the email of the user you want to give edit permission.
  5. Now next to the username you can find different permissions.
  6. Click on “Editor.”
  7. Then click “Submit.”

Excellent! You have now granted edit permission to the other user.

Permission to comment

People who can see the Google Sheet you have shared with them do not have the automatic privilege to comment on it. However, often you would like to give users permission to comment. Fortunately, it is a fairly straightforward process. To grant a user this role, simply do the following:

  1. Open the sheet and under “File” tap “Share.”
  2. Add the emails of the people you would like to give permission to comment.
  3. Once you add them, you will see a drop-down menu on the right, next to their names.
  4. Select “Commentator”.
  5. Finally, click on “Submit.”

That’s it! Now users have the “Commenter” privilege and can comment on the sheet data, without changing it.

Modify permissions

Modifying permissions in Google Sheets is useful when you want to give users different privileges. You can do this by following these simple steps:

  1. Look for the “Share with people and groups” dialog.
  2. Search for the person whose permissions you want to change.
  3. Next to your name, you will see the drop-down menu. Click on it.
  4. Now choose a new option.

This way you can decide when someone has permission to comment, edit or just view the Sheet.

Find what works best for you

When you leave a job, you definitely want to transfer ownership of Google Sheets to someone else. Then they can have full access and enjoy all the associated benefits.

At other times, you might reconsider this option and decide to give a user edit or comment privileges, and still be the owner of the sheet. If so, feel free to refer to this article for guidance.

Do you use any of the features described above? Which one do you use the most and why? Let us know in the comment section.

Reference-www.jugomobile.com

Leave a Reply

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