How to share Google Sheet Tabs to different people

In this video tutorial, we are going to learn how to share the google sheet sheets to different people.

Here is the google sheet, let's name it “To Share” sheet.

Let's change the sheet name as tab1. Now let's insert some data over here.

For best understanding let's change the label as student1.

Now let's duplicate the sheet and label it as student2. Let’s make it different from the previous sheet.

If we share the student1 sheet to someone, can student1 get access to student2 sheet?
Let’s check.

I’m sharing to master2teach@gmail.com as student1. Giving only view access for now.

Share it.

Checking mail. Here it is. Opening it. Here is the sheet. As you can see, student2 sheet is also available and accessible.

Actually there are no such facilities provided by Google. So we have to make some twice on it.

Let’s see what we can do to achieve our requirements.

First copy the sheet code from the URL. After D.
Create a new sheet. Let's name it as student1. Sheet name as well.

To import data from another sheet, we have an import range formula.
Paste the sheet id. Sheet name. Exclamation sign. Import from A1 to E15
Need to allow access.

Create another new sheet. Name it as student2.
Implement the same formula over here as well.
Import range

Now we have two new sheets with different names whereas we have one main sheet name as “ to share”.

Navigate to student1 sheet and share to student1.

Again using the same mail. View only access. Send.

Check mail and Open

Now if we change to main sheet data, it will reflect the shared sheet and student2 data is not accessible to student1 and vice versa.

In this way we can manage all the data from the main sheet and can share different sheets to different people with limited access.

I hope you learn from this tutorial. Please don’t forget to like, share, and subscribe to the channel.

Thank you

SUBSCRIBE to our YouTube channel for more videos: https://www.youtube.com/c/Master2Teach?sub_confirmation=1

Like us on Facebook: https://www.facebook.com/master2teach

For more content go to https://master2teach.com/

Видео How to share Google Sheet Tabs to different people канала Master2Teach