Google Sheets has a document sharing mode to collaborate with others online, or share data in Google Sheets. And in addition to sharing a Google Sheets file with all sheets displayed, users can choose to share a Google Sheets data area or share a sheet on Google Sheets, with the only sheet that needs to be shared, not the entire file. . Below is a tutorial on sharing a sheet on Google Sheets.
How to share a sheet on Google Sheets via link
This is the simplest way when you want to share a single sheet with others. Just copy the link of the sheet you want to share and send it to others.
Then the person receiving the link will immediately access the sheet you sent. This way, they can still access other sheets in the document, so users need to pay attention.
Share a single sheet on Google Sheets
In case you only want to share a single sheet on Google Sheets and the person receiving the link cannot view the content in the other sheet, you need to set up protection mode.
Step 1:
At the sheet we want to protect, we Click Data then select Protect sheets and cell ranges.
Step 2:
Next on the right edge of the screen, the user Next click Add sheet or range need to be protected.
Step 3:
This time you Click on the Sheets categoryenter the description inside then Click on the sheet that needs to be protected and do not share. Below there are additional options Except for certain cells to select the cells that will be shared in that protected sheet. Final Click the Set Permissions button.
Step 4:
At this point, an interface appears to edit additional protection rights. We choose the settings we want and then click the Done button. So this sheet has been protected.
How to share a sheet on Google Sheets from a new file
If we want to completely restrict other people's access to other sheets without needing to set up much, just create a new file from the sheet you want to share.
At the sheet you want to share, you Right-click, select Copy to, then select New Worksheet.
Then this sheet is created into a completely new spreadsheet for us to share via the sheet link and that's it.
