Excel Web App at a glance

Excel Web App at a glance

1. In the browser view of a workbook, you can navigate through the workbook, sort, filter, expand and collapse PivotTables, and even recalculate the workbook.

2. The data you are viewing is live. You can refresh a PivotTable, or refresh the whole workbook.

3. Click Edit in Browser to edit the workbook in the browser; click Open in Excel to work on it in the Excel desktop application.

4. When you edit the workbook in your browser, you can enter data and formulas, create tables and charts, and do some formatting. To enter formulas, type equal-sign (=), and then the formula or function. For help with Excel functions, see the Excel functions (by category).

5. Excel Web App has the look and feel of Excel.

  • Click the File tab to save a copy of the workbook or download a snapshot that contains just values and formatting, no live data.

  • The Home tab has commands for formatting text and cells, adding rows and columns, and recalculating data.

  • Use the Insert tab to add charts, tables and hyperlinks to your worksheets.

  • Excel Web App saves your work automatically. Use Undo to get rid of changes you don't want to keep.

6. If other people are working on the workbook, you can see who they are by clicking in the bottom right corner of the browser window.

Applies To: Excel Web App

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!

Change language