Google Drive: How to Create a Shared Spreadsheet (Great for Working with Others)

JerryS Level 1

May 23, 2013, 10:19 pm

10

Write the reason you're deleting this FAQ

Google Drive: How to Create a Shared Spreadsheet (Great for Working with Others)

Hello everyone! Today I'm going to teach you how to create a shared spreadsheet. What does shared mean, you ask? Well, it basically means that multiple people can work on a spreadsheet at the SAME time.... the SAME spreadsheet. Another thing that it's great for is if you and your friends are working on a project, or you and your spouse are working on taxes, etc. you can do it together and remotely so there's nothing to worry about. You can even watch while your both on the spreadsheet. Here are instructions.

THE STEPS:

Go to Google Drive's official website (Look it up) and either sign in with your Google Account or Sign up with Google to get into Google Drive.
After you have done that, you'll see a menu called, "Drive" at the side of your page. There will be two options: an "UP" arrow and an option called "Create".
Click "Create" and another menu should come up with several options. Click the "Spreadsheet" option and a new window should open in your browser with a spreadsheet called "Untitled spreadsheet".
When you are on this page, click the "Share" button. It will ask you to name your spreadsheet. Enter anything you like.
Now you'll see something called "Who has access" and under it, something that says "Private - Only the people listed below can access".
Click the "Change" button and several options will come up. Depending on what you want, click that option. "Public on the web" means anyone on the internet can see it. "Anyone with the link" means anyone who has the link to your shared spreadsheet can access but those who don't cannot. "Private" means only those you invite/allow are allowed to access it.
If you chose Private and want to add people to the list of allowed users, you'll see a text box that says "Add people". You can add emails, people on your friends list (if you have a Gmail account), etc.

I hope you enjoyed my tutorial and there will possibly be more to come. I look forward to working with you guys.

Google Drive: How to Create a Shared Spreadsheet (Great for Working with Others)

Comments

Please login or sign up to leave a comment

Join

angie828

Looking forward to more from you. Great tutorial.

13 years ago

Are you sure you want to delete this post?

evie

Always wondered how to do this. What an easy thing to do.

13 years ago

Are you sure you want to delete this post?

Miken34

Very easy from the looks of it.

13 years ago

Are you sure you want to delete this post?

loulou

I use google drives all the time so this was a good read for me.

13 years ago

Are you sure you want to delete this post?

tionna

Useful info here. I have done this many times.

12 years ago

Are you sure you want to delete this post?

evie

I use these spreadsheets a lot and they are very easy to use.

12 years ago

Are you sure you want to delete this post?

ralph101

Never used one of these but it looks pretty simple to do!

12 years ago

Are you sure you want to delete this post?

tangee

Never used one of these but it looks pretty simple to do!

Yes they are really easy to use. I have been sharing one for a while now.

12 years ago

Are you sure you want to delete this post?

haleystar

tank you

12 years ago

Are you sure you want to delete this post?

Corzhens

Thank you for the detailed tutorial. However, I have a question about spreadsheet. I am a Windows user and the MS Office is a standard for me which includes a spreadsheet called Excel. Now, if I am using the Excel for my spreadsheet and I save it in the Google drive folder, would it be the same as using the spreadsheet in the Google Drive? Pardon me for asking because I am quite confused with the spreadsheet of Google Drive. Or maybe that spreadsheet is good only for those with no MS Office software?

8 years ago

Are you sure you want to delete this post?

Process Time: 0.36821794509888

Possible Duplicate queries found!

Match	Count	SQL	Script
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400	1	SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400	/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()
SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='14490'	1	SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='14490'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='49394'	1	SELECT * FROM seoclerks.members WHERE USERID='49394'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM categories_faq WHERE CATID='36'	1	SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='36'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
SELECT * FROM categories_faq WHERE CATID='30'	1	SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='30'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
SELECT * FROM seoclerks.members WHERE USERID=49394	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=49394	/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()
SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=14490 LIMIT 5	1	SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=14490 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='14490' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	1	SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='14490' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	/opt/clerks-staging/docroot/viewfaq.php 1245 () ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75841 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75841 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75842 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75842 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75843 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75843 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75844 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75844 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75845 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75845 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75846 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75846 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75847 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75847 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75848 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75848 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75849 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=75849 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=152411 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=152411 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='14490'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='14490'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='14490' AND status='1' AND (question like '%Google Drive: Create Shared Spreadsheet (Great Working Others)%' OR question like '%Google%' OR question like '%Drive:%' OR question like '%Create%' OR question like '%Shared%' OR question like '%Spreadsheet%' OR question like '%(Great%' OR question like '%Working%' OR question like '%Others)%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='14490' AND status='1' AND (question like '%Google Drive: Create Shared Spreadsheet (Great Working Others)%' OR question like '%Google%' OR question like '%Drive:%' OR question like '%Create%' OR question like '%Shared%' OR question like '%Spreadsheet%' OR question like '%(Great%' OR question like '%Working%' OR question like '%Others)%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='1129' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='318' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='318' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=14490%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	1	SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=14490%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * from categories_software order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()
select * from categories_wanttobuy order by name asc	1	select * from categories_wanttobuy order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()
select * from categories_wanttotrade order by name asc	1	select * from categories_wanttotrade order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()
SELECT * FROM seoclerks.members WHERE USERID='632.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='632.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
select * from categories_faq order by name asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)	sql1	error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially

Load

Count

SQL

Max

Min

Suspicious SQL

The following SQL have high average execution times

Avg Time

Count

SQL

Max

Min