Basic tasks in Excel Online

With Excel Online you use your web browser to create, view, and edit workbooks you store on OneDrive. If your organization or college has an Office 365 plan or SharePoint site, start using Excel Online by creating or storing workbooks in libraries on your site.

Note    If you’re using Excel Web App with SharePoint 2010, or if you're using Internet Explorer 7, see Introduction to Excel Web Appand Excel Web App at a glance.

Create an online workbook

  1. From your OneDrive, click Create > Excel workbook.

    Create a new workbook

  2. To rename the workbook, click the default file name and type a new one.

    rename a file

Share workbooks online

After you’ve created your online workbook, you can share it with friends, coworkers, or the public. People can view your worksheets, sort and filter data, and drill into the details of PivotTables on the web or mobile device.

To share a workbook, click Share and type email addresses of people you want to share with or get a link you can email to your contacts.

Invite people for sharing your workbook

Edit in the browser

If you try to enter data, set up a formula, add charts, or apply basic formatting and nothing happens, you’re probably in read-only view. Here's how you can switch to editing view:

Click Edit Workbook > Edit in Excel Online.

For more advanced editing options, click Edit in Excel.

Excel Online saves your work automatically however, if you change your mind about any changes you’ve just made, use Undo or press Ctrl+Z.

Work together on the same worksheet

When you’re working with others in Excel Online, you can edit the worksheet as you usually would. When others edit the worksheet, Excel Online shows their presence and the updates right away. This only works when everyone is working in Excel Online. If anyone opens the workbook in Excel desktop, others won't be able to edit the workbook at the same time in Excel Online.

indicator showing how many are collaborating on a spreadsheet

See, Top tips for working in Excel Online.

Print in Excel Online

  1. Select the cells or chart you want to print, and then go to File > Print. To print the whole worksheet, don’t select anything before going to the Print command.

    Print selected cells

  2. Click Print for a preview.

  3. If you change your mind about printing a selected area, choose the Entire Sheet print option and click Print.

  4. If the final print preview looks right, click Print.

    Printable view of worksheet

Learn more about printing gridlines in a worksheet.

Applies To: Excel Online



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language