Excel for the web is Excel, but in your web browser. You can access it from any device, anywhere. And better yet, it's free for your personal use! (If you need to use it for a business, you can access it with a Microsoft 365 subscription.)
With new features constantly being released, Excel for the web is quickly becoming as powerful as its desktop equivalent.
Create spreadsheets and share them with your peers at work and school. Collaborate with others in real time while communicating via built-in comments and chat.
Organize & analyze your data just like you do in the Excel desktop app. Turn columns of numbers into valuable insights by building PivotTables, modern charts and smart tools.
Create surveys and polls , and watch the results fill your Excel workbook automatically. Then, analyze the results in all-familiar Excel ways. All without ever leaving your browser!
See the following details for our latest feature releases.
Manage conditional formatting rules in the Conditional Formatting side pane.
Choose from a wide selection of styles in the Cell Style Gallery.
Now you can view and restore the versions of a workbook stored on OneDrive. You can even review the exact changes made between the various versions.
Need to compare two worksheets in the same workbook? Open a new window for the workbook and the task becomes easy.
How do you want your formulas to behave? Set the calculation mode to take control.
In addition to using them, you can now delete PivotTable Slicers that were added in a desktop version of Excel.
The Workbook Statistics feature counts and identifies elements of a workbook, helping you discover all its content. You'll find it on the Review tab of the ribbon.
Dynamic array formulas work like regular formulas, but produce arrays that automatically spill into adjacent cells as needed - no need to select the range the result will occupy, and no need to press CTRL+ALT+Enter to enter the array formula.
Sort by color or icon
Sort conditionally-formatted data that uses icon sets or color scales by using their icons or color values.
Easier to start editing
Easily switch between viewing and editing when working in Excel for the web. If you're using the Single-Line ribbon the command is always visible on the top level; otherwise just look on the View tab in the Document Views group for the commands.
Create customized views in an Excel worksheet without disrupting others.
Enjoy new table formatting options, including a style gallery.
Excel for the web now includes six new functions to supercharge your spreadsheets: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and RANDARRAY.
The following Excel for the web features were released during 2019.
Paste hyperlinks from outside Excel
Using Edge or Chrome as your browser, you can copy hyperlinks from other apps and paste them into Excel for the web. The pasted hyperlinks will function normally.
With Microsoft 365, users can maintain control of access and sensitivity of their documents by manually applying a label or using the automatically recommended labels from Microsoft.
You can control keyboard shortcuts so they work the same in both versions of Excel by changing the Keyboard Shortcuts settings - you can even override browser shortcuts. Just click Help > Keyboard Shortcuts.
Find and highlight every instance of your search term. Just press Ctrl+F, enter your search term, then select Find All.
For data in a range, you can now sort from left-to-right. If your data is in a table, you'll need to convert it to a range first.
Improved Presence information makes it easier to see who else is working on a workbook, what they have selected, and whether they are currently editing.
Resolve a comment thread to show the issue has been addressed but leave the comments in place. You can reopen a resolved thread if needed.
To check spelling for any text on your worksheet, click Review > Proofing > Spelling.
Ideas in Excel empowers you to understand your data through high-level visual summaries, trends, and patterns. Simply click a cell in a data range, and then click the Ideas button on the Home tab. Ideas in Excel will analyze your data, and return interesting visuals about it in a task pane.
You can get stock and geographic data in Excel. It's as easy as typing text into a cell, and converting it to the Stocks data type, or the Geography data type. These two data types are new, and they are considered linked data types because they have a connection to an online data source. That connection allows you to bring back rich, interesting information that you can work with and refresh.
After you create an Excel table, you may only want the table style without the table functionality. To stop working with your data in a table without losing any table style formatting that you applied, you can convert the table to a regular range of data on the worksheet.
Now you can insert PivotCharts in addition to PivotTables.
Switch row-based data to columns and vice versa.
Tired of boring, black borders? Now you can make them stand out with colors & styles.
Sorting by multiple levels just got a whole lot easier.
Quickly and easily remove duplicate values from your data.
Create an outline of up to eight levels, one for each group.
Add editable comments to cells, and call out people with @Mentions.
Quickly add a border around cells or ranges of cells.
Paste options from the context menu
Right-click on any cell to display your Cut/Copy/Paste options.
For a thorough description of the current feature set of Excel for the web, see Excel for the web.
Roadmap of what's to come
The following features are being considered or are currently being developed for Excel for the web. Although we list them here, we can't guarantee when they'll be available.
Select discontinuous cells, ranges, columns or rows
Import data from other Excel workbooks
Templates, to get you started
Suggest a Feature
Now you can influence Excel for the web! With Excel UserVoice you can suggest new features for the upcoming versions of Excel for the web, or look at existing suggestions and vote for your favorites! We will do our best to respond and will strive to satisfy those requests that get votes.
by Joe McDaid on 8-28-19
We are excited to announce XLOOKUP, successor to the iconic VLOOKUP and HLOOKUP functions.
Insert PivotChart is available in Excel for the web
by Itai Goldstein on 05-19-19
PivotChart insertion was requested by many customers in the Excel community. Just like in Excel Desktop, you can now create your own PivotTables and PivotCharts and edit them directly in Excel for the web.
Report an Issue
Have a problem with Excel for the web? Got an idea about changes you would love to see? Or just want to share what you like? Tell us what you think, and give us your feedback about anything. We're waiting to hear from you and willing to help with any issue.
Click on HELP IMPROVE OFFICE at the bottom left corner and you'll be able to tell us what you think.
We do read your feedback, and we'll make every effort to act on it.
Please follow this link for an overview of how to get started with Office Development.
You can also view and influence the extensibility roadmap. We encourage you to review and comment on the new and planned APIs.
To find out more about what we're working on, see our article online: What's new in Excel for the web.