How To Share Only One Sheet In Google Sheets

Google Sheets is an incredibly powerful tool for collaboration and data management, but sometimes you may only want to share a single sheet within a larger workbook with certain individuals.

In this article, we’ll show you how to share only one sheet in Google Sheets, without giving access to the rest of your workbook.

Step 1: Create A New Sheet

To start, open the Google Sheets workbook that contains the sheet you want to share, and create a new sheet.

You can do this by clicking the plus sign in the bottom-left corner of the screen.

This new sheet will serve as a “front end” for the sheet you want to share.

Step 2: Copy The Data From The Original Sheet

Next, select the sheet you want to share and copy the data by pressing Ctrl+C (or Cmd+C on a Mac).

READ NEXT:   How to Copy Chart Styles and Duplicate Charts in Google Sheets

Then, go to your new sheet and paste the data by pressing Ctrl+V (or Cmd+V on a Mac).

Step 3: Share The New Sheet

Now that you’ve copied the data to a new sheet, you can share that sheet without giving access to the rest of your workbook.

To do this, click the “Share” button in the top-right corner of the screen.

In the share settings, you can add the email addresses of the individuals you want to share the sheet with and choose their level of access (view, comment, or edit).

Step 4: Restrict Access To The Original Sheet

To prevent others from accessing the original sheet, go to the “File” menu and select “Protect sheet.” In the protection settings, you can choose which users can edit the sheet and which users can view it.

READ NEXT:   How to Freeze and Unfreeze Rows and Columns in Google Sheets

This will ensure that only you and the people you’ve explicitly given access to can view or edit the original sheet.


In this article, we’ve shown you how to share only one sheet in Google Sheets by creating a new sheet, copying the data from the original sheet, sharing the new sheet, and restricting access to the original sheet.

By following these steps, you can easily share specific data with others without giving them access to your entire workbook.

Similar Posts:

READ NEXT:   Moving and Copying Charts in Google Sheets