![]() ![]() 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:ĥ. And now, you can click Share button at the top right of the file to share this sheet file to others, see screenshot:Ĥ. 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. 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:ģ. Note: In this formula: is the original sheet address, and kte data!A1:C18 is the sheet name and cells range you want to share with others. Create a new Google sheet file, and then enter the following formula into a cell where you want to output the original data: =IMPORTRANGE("","kte data!A1:C18"), see screenshot: The following steps can help you to share just one tab to others from Google sheet, please do as this:ġ. Share only one specific sheet to others in Google sheet How could you solve this job 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 to share only one specific sheet to others in Google sheet? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |