How to share only one specific sheet to others in Google sheet?
Normally, when you share a Google sheet file, all the sheets will be shared as well, but, sometimes, you just want to share only one specific sheet excluding others as following screenshot shown. How could you solve this job in Google sheet?
The following steps can help you to share just one tab to others from Google sheet, please do as this:
1. Create a new Google sheet file, and then enter the following formula into a cell where you want to output the original data: =IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Plv5B3v3VfPtdWSJ4zFM6DKPY0MhcCxiYS0vYrxORHE/edit#gid=1482359313","kte data!A1:C18"), see screenshot:
Note: In this formula: https://docs.google.com/spreadsheets/d/1Plv5B3v3VfPtdWSJ4zFM6DKPY0MhcCxiYS0vYrxORHE/edit#gid=1482359313 is the original sheet address, and kte data!A1:C18 is the sheet name and cells range you want to share with others. Please change them to your own.
2. Then press Enter key, an error value is displayed in the cell, select the formula cell, and click Allow access button in the popped out message beside the cell, see screenshot:
3. Then the original data in the sheet has been imported into this new file, and this data will be changed as the original data changes. And now, you can click Share button at the top right of the file to share this sheet file to others, see screenshot:
4. If your new file is not saved, a message box is popped out to remind you to enter a name for this new file, see screenshot:
5. Then click Save button, and in the popped out Share with others dialog box, enter the user’s email address that you want to share with, and then click button to select the operation that you want the user to operate, see screenshot:
6. Then please click Advanced at the right bottom of the dialog, in the Sharing settings dialog box, in the owner settings section, please check the Prevent editors from changing access and adding new people and Disable options to download, print, and copy for commenters and viewers options to protect the sheet. See screenshot:
7. Click Save changes button, and then click Send button to send this sheet to the user you want to share with. See screenshot:
Note: If the user’s email address is not Gmail, you will get the following step, please choose one option you need, and go on clicking Send button. See screenshot:
8. And your sheet has been shared with the specific user.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!