Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Sharing a spreadsheet file with other people

From: Google Sheets Essential Training

Video: Sharing a spreadsheet file with other people

Let's take a few minutes to talk about the ways you can share a Google Sheets file There's Private, which means only you can access. There's Sharing with specific people, There's Sharing with anyone with link, There's Sharing public on the web, which means that anyone on The sharing settings dialogue box will pop up.

Sharing a spreadsheet file with other people

Let's take a few minutes to talk about the ways you can share a Google Sheets file with other users. Before we walk through the process of sharing a spreadsheet file, let's make sure we understand some terms. There are four types of access in Google Sheets. I'll click the Share button in the upper right to show you these types. There's Private, which means only you can access. There's Sharing with specific people, which means only the email addresses you specify can access the spreadsheet. There's Sharing with anyone with link, which means anyone who has the link can access it without signing into Google.

There's Sharing public on the web, which means that anyone on the internet can find or access your spreadsheet without signing in to Google. I'll cancel this, and let's walk through the process of sharing a spreadsheet with specific people. In many situations, you'll want to just share a document with a few people, and you won't want to share it on the web. In Google Sheets, the users that you shared the spreadsheet with are called collaborators, whether they have viewing, commenting or editing privileges.

To share a spreadsheet with another person, start by opening the spreadsheet document. I'll show you how with this kinetECO Solar System spreadsheet. Click the blue Share button in the upper right corner. The sharing settings dialogue box will pop up. You can see in this pop up that the visibility setting of this spreadsheet is set to private. Any spreadsheet you create will start out with its visibility set to private. To share with specific people, type in the email addresses of people you want to share with. In this box below, invite people. Now you can enter any email address, but Gmail addresses will make the process easiest for the collaborator because they'll be able to access the file immediately.

I'll add the email addresses of a couple of my colleagues here. Next, select their permission levels. Use this drop-down. If you'd like them to have editing privileges on the spreadsheet, leave the setting as Can edit. Editors will also be allowed to share the document with others. If you'd like them to be able to comment but not edit the spreadsheet, select Can comment from the drop-down. If you only want them to be able to view the document, select Can view. You can always change these sharing settings later. I'll keep these settings as Can edit so that the collaborators can edit my spreadsheet.

Keep in mind that when you share with specific people, in order to view or edit the spreadsheet, the user you're sharing with will need to sign in with their Google account. Or create a Google account if they don't already have one. If you want Google to send them an email notification, leave this Notify people via email check box checked. You can click Add message to add a custom message to the collaborators. I'll add a quick note here. Note that when Google sends this email, they'll send a link to the shared file. It will not be an email attachment.

You can also send a copy of the email to yourself by checking this Send a copy to myself check box. I'll do that. When you've completed the sharing settings, click this blue Send button in the bottom left corner to send an email with a link to the document to all collaborators. You'll notice that the Sharing settings dialogue box is still open after you send the email. And now the collaborators will be added to the list. If everything is set as you wanted, click this Done button to return to your spreadsheet. If you need to change levels of access, select the drop-down next to the user's name.

I'll change Simon's permissions so that he just has view permissions. If you need to remove a collaborator, select the X next to the user's name. When you've completed your changes click the Save Changes button at the bottom left, and click the Done button to return to your spreadsheet. Let's talk about a few special cases with sharing with specific people. First, if you want to share a file with someone who uses a non-Google account, they'll receive an invitation with a link prompting them to sign in or sign up for a Google account to be able to view or edit the file.

This link will be valid for 14 days. Also, you can share an item with an email mailing list. However, each user on the mailing list will need a Google account to sign into Google and see the spreadsheet in their Google Drive. Now, there are limits on how many people you can share the spreadsheet with. You can share with up to 200 email addresses, and a maximum of 50 people can make edits to the spreadsheet at the same time. If you want to share with a large group of people or if you want to share the spreadsheet with people who do not have Google accounts, consider changing the settings to anyone with a link.

I'll show you how to do that. Click the blue Share button in the upper right, and click Change to change your sharing settings. Select the radio button for Anyone with link. You can use this drop down to allow people to view, comment, or even edit the document without signing in to Google. Click Save, and you can share this document by just copying and sharing this link under link to share. Or using these quick link icons to share via Gmail, Google Plus, Facebook, or Twitter. If you click Change and change the visibility to public on the web, keep in mind that the spreadsheet will be searchable on the web.

I'm going to change back to sharing with specific people, and I'll click Save to save my changes. By sharing your spreadsheet, you can allow people to view, comment on, and edit your spreadsheet without managing multiple versions of the file, and without sending the file as a bulky email attachment.

Show transcript

This video is part of

Image for Google Sheets Essential Training
Google Sheets Essential Training

50 video lessons · 887 viewers

Sally Norred
Author

 
Expand all | Collapse all
  1. 4m 44s
    1. Welcome
      46s
    2. Importing exercise files to Google Sheets
      1m 29s
    3. What's new in Google Sheets
      2m 29s
  2. 14m 44s
    1. What is Google Sheets?
      2m 31s
    2. Accessing Google Sheets with your account
      2m 3s
    3. Understanding common Google Sheets terminology
      4m 17s
    4. Navigating Google Sheets
      5m 53s
  3. 22m 15s
    1. Creating, naming, and saving a spreadsheet
      3m 28s
    2. Renaming a spreadsheet
      1m 59s
    3. Copying a spreadsheet
      3m 9s
    4. Moving a spreadsheet
      3m 10s
    5. Deleting a spreadsheet
      2m 15s
    6. Importing and converting Excel or OpenOffice spreadsheets
      4m 20s
    7. Importing and converting .csv, .tsv, .tab, and .txt data files
      3m 54s
  4. 28m 46s
    1. Entering and editing cell content
      4m 2s
    2. Inserting, deleting, and clearing rows and columns
      3m 26s
    3. Moving rows, columns, and cells
      2m 25s
    4. Working with multiple sheets
      4m 14s
    5. Using keyboard shortcuts
      3m 43s
    6. Creating a series of numbers or dates
      3m 13s
    7. Using Find and Replace
      2m 30s
    8. Entering hyperlinks
      1m 58s
    9. Inserting images into spreadsheets
      3m 15s
  5. 14m 31s
    1. Using the View menu
      3m 2s
    2. Freezing rows and columns
      1m 58s
    3. Hiding rows, columns, and sheets
      3m 45s
    4. Publishing a spreadsheet to the web
      3m 6s
    5. Printing a spreadsheet
      2m 40s
  6. 18m 46s
    1. Formatting cell, row, and column data
      6m 6s
    2. Google Sheets formatting tips
      3m 35s
    3. Using conditional formatting
      5m 6s
    4. Creating a spreadsheet from a template
      3m 59s
  7. 36m 12s
    1. Sorting data on a spreadsheet
      3m 37s
    2. Using Quick Sum
      3m 14s
    3. Using formulas and functions
      6m 23s
    4. Using IF functions and nested functions
      4m 33s
    5. Referencing data from other sheets
      3m 43s
    6. Creating charts in Google Sheets
      5m 28s
    7. Using filters and creating filter views
      4m 55s
    8. Using pivot tables
      4m 19s
  8. 20m 37s
    1. Sharing a spreadsheet file with other people
      5m 40s
    2. Working with Google Sheets that are shared with you
      4m 19s
    3. Working with spreadsheet revisions
      3m 2s
    4. Commenting on a spreadsheet
      3m 26s
    5. Emailing spreadsheet collaborators
      1m 47s
    6. Collaborating simultaneously and using Google Chat
      2m 23s
  9. 8m 54s
    1. Installing the Google Sheets mobile app
      2m 3s
    2. Navigating the Google Sheets mobile app
      3m 21s
    3. Working with spreadsheets on the Google Sheets mobile app
      3m 30s
  10. 47s
    1. Helpful resources
      47s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Google Sheets Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.