Co-edit a spreadsheet using Excel Online

Office Training Center > Office 365 scenario-based training > Me and my docs

Back to previous page Go to next page

With Excel Online, you can edit an Excel spreadsheet alongside your teammates. Watch the video to see how this works in the browser on a computer, and scroll down to see how to perform this task across a variety of devices.

Important: In order for multiple people to co-edit a spreadsheet, everyone must be using Excel Online. If anyone opens the spreadsheet in Excel installed on a device, only that person will be able to edit the file until it's saved and closed.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

The following procedure describes how to perform this task using Excel Online in a web browser on a computer. However, you can use another device as well. See Specific "how to" instructions for your device.

To edit a spreadsheet using Excel Online
  1. Using the web browser on your device, go to http://portal.office.com and sign in using your work or school account.

  2. Do one of the following:

    • If the file you want to edit is yours, from either your home screen or the app launcher, choose OneDrive, and then select an Excel spreadsheet to open it in your browser window.

    • If someone shared a spreadsheet with you and you want to edit that file, choose OneDrive, and then choose Shared with me. Then select an Excel spreadsheet to open it in your browser window.

      (Our example is called Marketing event budget example.xlsx.)

  3. On the Edit Workbook menu, choose Edit in Excel Online.

  4. To edit the contents of a cell, tap to select that cell, and then type your entry. Then press Enter.

Tip: When you edit a spreadsheet in Excel Online, your changes are saved automatically.

Specific "how to" instructions for your device

To edit a spreadsheet using Excel Online on your Windows computer or tablet
  1. Using the web browser on your device, go to http://portal.office.com and sign in using your work or school account.

  2. Do one of the following:

    • If the file you want to edit is yours, from either your home screen or the app launcher, choose OneDrive, and then select an Excel spreadsheet to open it in your browser window.

    • If someone shared a spreadsheet with you and you want to edit that file, choose OneDrive, and then choose Shared with me. Then select an Excel spreadsheet to open it in your browser window.

      (Our example is called Marketing event budget example.xlsx.)

  3. On the Edit Workbook menu, choose Edit in Excel Online.

  4. To edit the contents of a cell, tap to select that cell, and then type your entry. Then press Enter.

Tip: When you edit a spreadsheet in Excel Online, your changes are saved automatically.

To edit a spreadsheet using Excel Online on your Mac
  1. Using the web browser on your device, go to http://portal.office.com and sign in using your work or school account.

  2. Do one of the following:

    • If the file you want to edit is yours, from either your home screen or the app launcher, choose OneDrive, and then select an Excel spreadsheet to open it in your browser window.

    • If someone shared a spreadsheet with you and you want to edit that file, choose OneDrive, and then choose Shared with me. Then select an Excel spreadsheet to open it in your browser window.

      (Our example is called Marketing event budget example.xlsx.)

  3. On the Edit Workbook menu, choose Edit in Excel Online.

  4. To edit the contents of a cell, tap to select that cell, and then type your entry. Then press Return.

Tip: When you edit a spreadsheet in Excel Online, your changes are saved automatically.

To edit a spreadsheet using Excel Online on your Android phone or tablet
  1. Using the web browser on your device, go to http://portal.office.com and sign in using your work or school account.

  2. Do one of the following:

    • If the file you want to edit is yours, from either your home screen or the app launcher, choose OneDrive, and then select an Excel spreadsheet to open it in your browser window.

    • If someone shared a spreadsheet with you and you want to edit that file, choose OneDrive, and then choose Shared with me. Then select an Excel spreadsheet to open it in your browser window.

      (Our example is called Marketing event budget example.xlsx.)

  3. On the Edit Workbook menu, choose Edit in Excel Online.

  4. To edit the contents of a cell, tap to select that cell, and then type your entry. Then press Enter.

Tip: When you edit a spreadsheet in Excel Online, your changes are saved automatically.

To edit a spreadsheet using Excel Online on your iPad or iPhone
  1. Using the web browser on your device, go to http://portal.office.com and sign in using your work or school account.

  2. Do one of the following:

    • If the file you want to edit is yours, from either your home screen or the app launcher, choose OneDrive, and then select an Excel spreadsheet to open it in your browser window.

    • If someone shared a spreadsheet with you and you want to edit that file, choose OneDrive, and then choose Shared with me. Then select an Excel spreadsheet to open it in your browser window.

      (Our example is called Marketing event budget example.xlsx.)

  3. On the Edit Workbook menu, choose Edit in Excel Online.

  4. To edit the contents of a cell, tap to select that cell, and then type your entry. Then press Enter.

Tip: When you edit a spreadsheet in Excel Online, your changes are saved automatically.

To edit a spreadsheet using Excel Online on your Windows Phone
  1. Using the web browser on your device, go to http://portal.office.com and sign in using your work or school account.

  2. Do one of the following:

    • If the file you want to edit is yours, from either your home screen or the app launcher, choose OneDrive, and then select an Excel spreadsheet to open it in your browser window.

    • If someone shared a spreadsheet with you and you want to edit that file, choose OneDrive, and then choose Shared with me. Then select an Excel spreadsheet to open it in your browser window.

      (Our example is called Marketing event budget example.xlsx.)

  3. On the Edit Workbook menu, choose Edit in Excel Online.

  4. To edit the contents of a cell, tap to select that cell, and then type your entry. Then press Enter.

Tip: When you edit a spreadsheet in Excel Online, your changes are saved automatically.

To edit a spreadsheet using Excel Online
  1. Using the web browser on your device, go to http://portal.office.com and sign in using your work or school account.

  2. Do one of the following:

    • If the file you want to edit is yours, from either your home screen or the app launcher, choose OneDrive, and then select an Excel spreadsheet to open it in your browser window.

    • If someone shared a spreadsheet with you and you want to edit that file, choose OneDrive, and then choose Shared with me. Then select an Excel spreadsheet to open it in your browser window.

      (Our example is called Marketing event budget example.xlsx.)

  3. On the Edit Workbook menu, choose Edit in Excel Online.

  4. To edit the contents of a cell, tap to select that cell, and then type your entry. Then press Enter.

Tip: When you edit a spreadsheet in Excel Online, your changes are saved automatically.

Additional resources

Top of module

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×