How to Make a Shared Spreadsheet
Spreadsheets are a staple of an office. They are used to organize data and make reports. Whether you use an Internet-based spreadsheet program or the standard Microsoft Excel, you will need to share spreadsheet reports to your team or...
Method 1 of 2:
Microsoft Excel Spreadsheet
-
How to Make a Shared Spreadsheet Picture 1
Open your excel spreadsheet or create a new document by going to the File Menu in the top horizontal toolbar and selecting "New." -
How to Make a Shared Spreadsheet Picture 2
Make changes to your document. These should include macros, charts, merging cells. pictures, objects, hyperlinks, outlines, subtotals, data tables, Pivot Table reports, worksheet protection and conditional formats. -
How to Make a Shared Spreadsheet Picture 3
Click on the Tools Menu or in other version you can find the Review Tab. Select "Shared Spreadsheet/Share Workbook" from the options in the drop down menu. -
How to Make a Shared Spreadsheet Picture 4
Click the Editing tab when the dialogue box pops up. -
How to Make a Shared Spreadsheet Picture 5
Find the box that says "Allow changes by more than one user at the same time." Click on that box to affirm you want that change. -
How to Make a Shared Spreadsheet Picture 6
Click "OK" to save that change. -
How to Make a Shared Spreadsheet Picture 7
Save the workbook in its current location by clicking the File Menu and selecting "Save." -
How to Make a Shared Spreadsheet Picture 8
Go back to the File Menu and select "Save As." -
How to Make a Shared Spreadsheet Picture 9
Save the file in a shared folder on a shared network. Make sure all the people that will use the document have permission to use that folder. If not, save it somewhere that everyone can access.
Method 2 of 2:
Google Docs Spreadsheet
-
How to Make a Shared Spreadsheet Picture 10
Sign into your Google Documents account.- If you do not have a Google Docs account, set it up by clicking the "Try Google Docs Now" button on the Google sign in page.
-
How to Make a Shared Spreadsheet Picture 11
Go to your spreadsheet or click on the "Create New" drop down box. -
How to Make a Shared Spreadsheet Picture 12
Select "Spreadsheet" from the list of choices, or open a spreadsheet you have already been working on. -
How to Make a Shared Spreadsheet Picture 13
Click on the "Share" button to the right and above your spreadsheet. -
How to Make a Shared Spreadsheet Picture 14
Choose the names of people you want to join from your list of Google contacts, or you can type in email addresses. -
How to Make a Shared Spreadsheet Picture 15
Decide if the person can edit or only view the spreadsheet. Click on the drop down box to the right of the person's name. -
How to Make a Shared Spreadsheet Picture 16
Press the "Share & Save" button.
5 ★ | 1 Vote
You should read it
- Turn your Google spreadsheet into a brilliant rainbow
- How to create Google Spredsheet automatically updates data
- How to Make a Google Spreadsheet
- 10 tips and tricks in Google Spreadsheet
- How to Make a Spreadsheet
- A complete guide to Excel 2016 (Part 4): How to store and share spreadsheets
- How to Create an Excel Spreadsheet Without Excel
- Download files and websites directly from Google Drive in Chrome browser
- Use Pivot Table in the Google Docs Spreadsheet
- How to Learn Spreadsheet Basics with OpenOffice Calc
- How to Make a Spreadsheet in Excel
- How to send an SMS to save the website to Google Drive