HomeApplicationOffice information

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

  1. How to Make a Shared Spreadsheet Picture 1How 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."
  2. How to Make a Shared Spreadsheet Picture 2How 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.
  3. How to Make a Shared Spreadsheet Picture 3How 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.
  4. How to Make a Shared Spreadsheet Picture 4How to Make a Shared Spreadsheet Picture 4
    Click the Editing tab when the dialogue box pops up.
  5. How to Make a Shared Spreadsheet Picture 5How 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.
  6. How to Make a Shared Spreadsheet Picture 6How to Make a Shared Spreadsheet Picture 6
    Click "OK" to save that change.
  7. How to Make a Shared Spreadsheet Picture 7How to Make a Shared Spreadsheet Picture 7
    Save the workbook in its current location by clicking the File Menu and selecting "Save."
  8. How to Make a Shared Spreadsheet Picture 8How to Make a Shared Spreadsheet Picture 8
    Go back to the File Menu and select "Save As."
  9. How to Make a Shared Spreadsheet Picture 9How 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

  1. How to Make a Shared Spreadsheet Picture 10How to Make a Shared Spreadsheet Picture 10
    Sign into your Google Documents account.
    1. 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.
  2. How to Make a Shared Spreadsheet Picture 11How to Make a Shared Spreadsheet Picture 11
    Go to your spreadsheet or click on the "Create New" drop down box.
  3. How to Make a Shared Spreadsheet Picture 12How to Make a Shared Spreadsheet Picture 12
    Select "Spreadsheet" from the list of choices, or open a spreadsheet you have already been working on.
  4. How to Make a Shared Spreadsheet Picture 13How to Make a Shared Spreadsheet Picture 13
    Click on the "Share" button to the right and above your spreadsheet.
  5. How to Make a Shared Spreadsheet Picture 14How 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.
  6. How to Make a Shared Spreadsheet Picture 15How 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.
  7. How to Make a Shared Spreadsheet Picture 16How to Make a Shared Spreadsheet Picture 16
    Press the "Share & Save" button.
5 ★ | 1 Vote
spreadsheetsaveclickgoogle

You should read it

May be interested

Office information