How to Share Google Sheets With Others to Edit
Anyone with access to a spreadsheet file, such as those created by Google Sheets, will be able to make changes if no cell or file protection has been implemented. If your file is finished or you don't want others to be able to change it, you might choose to send it as a PDF instead.
The methods in this post were completed using Google Chrome, but they should work in any desktop Web browser. Following these procedures will result in a PDF file containing a copy of your spreadsheet. Google Drive will keep the original Google Sheets file.
Enable Editing for Everyone in Google Spread Sheets
Sharing Google Sheets to Edit: 7 Steps
Step -1 Open google sheets: You must first create and utilise a Google Sheet before sharing it. You may manage them from your phone, a computer, or a laptop.
- Any browser that supports Google extensions may be used on a PC or laptop.
- If you're on a mobile device, Google Sheets can be downloaded from the Play Store, and if you're on a Mac, you can use the App Store.
Step -2 Open file menu: Now the file has been opened.
- The cells containing data in them will be visible all throughout your page. You may use Google Sheets to easily and quickly keep and manage all of your data.
- The file name will appear in the top column, and menu options such as file, edit, insert, view, and so on will appear below.
- Find FILE among them and double-click it.
Step -3 Click on share: Now a new box opens up.
- New, open, import, and create a copy are all options that will be applied to the current file.
- You'll see choices like share and email underneath that.
- The term "share" refers to sending a file to someone's Gmail account.
- Once you've clicked SHARE, you'll be sent to the SHARE page.
Step -4 Click on share with others: After you click Share, you'll be able to choose who you wish to share the file with. You may do in one of two ways: either make the file public to all, allowing anybody to view it simply by clicking on the link, or add members who can access the file. Even if they have the URL, those who haven't been added to the file won't be able to view it.
Step -5 Now type or select the mail with you want to share sheet: You can share the sheet by simply typing out the receiver's mail ID. The only pre-requisite is that the person must have a Gmail Mail ID. Once you add the person, they'll be able to see all the data present in the sheet.
Step -6 Now select Editor: After adding the person, you can give them different roles. They can be the editor or the can just view the folder or they can even just comment on the data. Depending upon the need, you can change it. If you want to add more persons in more roles, you can do that with ease.
Step -7 Click on DoneOnce you have copied the link, and have added all the required persons to the file, you can close it. For closing this tab and to save all your changes you need to give DONE at the bottom of that present screen.
Commonly Asked Questions
1. Can the editor remove owner's access?
No one can remove the access of the owner to a file. The editor can only change the contents of the file
2. How can we track the changes made by an editor?
We can see all the recent changes made by the editor or anyone who has access to those files.
You can also learn how to download google sheets as pdf here.