What's new in Excel for the web

Excel for the web

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!

What's New?

See the following details for our latest feature releases.

Manage Conditional Formatting Rules in Excel for the web

Manage conditional formatting rules

Manage conditional formatting rules in the Conditional Formatting side pane.

Cell Styles button on the ribbon in Excel for the web

Cell Style Gallery

Choose from a wide selection of styles in the Cell Style Gallery.

Version History pane in Excel for the web

View and restore previous versions of a workbook

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.

New Window command on the ribbon in Excel for the web

Open multiple windows for one workbook

Need to compare two worksheets in the same workbook? Open a new window for the workbook and the task becomes easy.

Calculation Mode menu in Excel for the web

Switch between Automatic and Manual calculation modes

How do you want your formulas to behave? Set the calculation mode to take control.

Context menu of PivotTable slicer in Excel for the web

Delete PivotTable Slicers

In addition to using them, you can now delete PivotTable Slicers that were added in a desktop version of Excel.

Workbook Statistics dialog box

Workbook Statistics

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.

XLOOKUP example on a worksheet

XLOOKUP function and XMATCH function

New lookup functions let you perform lookups in any direction - left, right, up, or down.

FILTER function spilling on a worksheet

Dynamic array formulas

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 icon set

Sort by color or icon

Sort conditionally-formatted data that uses icon sets or color scales by using their icons or color values.

View Mode menu on the single-line ribbon

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.

The New button in the Sheet Views group

Sheet Views

Create customized views in an Excel worksheet without disrupting others.

XLO Table Style options

Table Style Gallery and Options

Enjoy new table formatting options, including a style gallery.

FILTER function in Excel for the web

New array functions

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.

Excel for the web with pasted hyperlink

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.

Apply document sensitivity labels in Excel from Home > Sensitivity

Classify documents and protect access to sensitive data

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.

Keyboard Shortcuts dialog box in Excel for the web

Control keyboard shortcuts in Excel for the web

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 dialog box with Find All option

Find All

Find and highlight every instance of your search term. Just press Ctrl+F, enter your search term, then select Find All.

Sort left-to-right command

Sort left-to-right

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.

Presence indicators in an open workbook with coauthors

Improved Presence information when co-authoring

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

Resolve comment threads

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.

Image of the Spell Check pane in Excel for the web

Spell Check

To check spelling for any text on your worksheet, click Review > Proofing > Spelling.

Image of the Ideas pane in Excel for the web

Ideas in Excel Online

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.

Image of Stock and Geography data types in Excel for the Web

New Data Types – Stocks and Geography

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.

Image of a table with Blue, Table Style, Medium 2 converted to a range and maintaining table formatting

Convert an Excel table to a range

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.

Spreadsheet with pivot table and graph

Insert a PivotChart

Now you can insert PivotCharts in addition to PivotTables.

Paste transpose option on Paste menu

Paste Transpose

Switch row-based data to columns and vice versa.

Add Border Colors in Excel for the web

Apply colors & styles to cell borders

Tired of boring, black borders? Now you can make them stand out with colors & styles.

Custom Sort in Excel for the Web from Data > Sort & Filter.

Sort by multiple columns or rows

Sorting by multiple levels just got a whole lot easier.

Remove duplicates in Excel Online from Data > Data Tools > Remove Duplicates.

Remove duplicate values

Quickly and easily remove duplicate values from your data.

Apply row and column Outline levels in Excel for the Web from Data Group/Ungroup.

Outline (Group/Ungroup) rows/columns

Create an outline of up to eight levels, one for each group. 

Mentions and Comments

@Mentions and Comments

Add editable comments to cells, and call out people with @Mentions.

Image of applying an Inside Border to a cell range from Home > Font > Borders.

Draw Inside Borders

Quickly add a border around cells or ranges of cells.

Right-click any cell to display your Cut/Copy/Paste options in Excel for the Web.

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.

Feature

Use Office Scripts to automate tasks easily

Create recommended charts

Set the function for a Totals Row cell

Rename a table

PivotTable Settings

Select discontinuous cells, ranges, columns or rows 

Import data from other Excel workbooks

Templates, to get you started

Take a Tour

Family Budget

Track My Tasks

More Excel templates here

Tutorials

Learning Excel for the web

Office Online essential training

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.

User Voice Features

Blogs


XLOOKUP function
by Joe McDaid on 8-28-19

We are excited to announce XLOOKUP, successor to the iconic VLOOKUP and HLOOKUP functions.
Read more


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.
Read more


Excel Dynamic Array Improvements
by Joe McDaid on 02-19-19

Since announcing dynamic arrays, we’ve received an overwhelmingly positive response from the Excel community. Being a fundamental change to the way formulas work, we wanted to take some time to gather and incorporate your feedback.
Read more

More Resources

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.

Help Improve Office

We do read your feedback, and we'll make every effort to act on it.

For Developers

Please follow this link for an overview of how to get started with Office Development.

If you want to develop add-ins that will work for Excel for the web and other Excel endpoints (cross-platform), please follow Office Add-ins platform overview and Develop Excel add-in.

If you want to create scripts that would operate on Excel workbooks stored in the cloud, please use our Graph Service (REST APIs). Make sure to check out the Excel-specific stuff..

You can also view and influence the extensibility roadmap. We encourage you to review and comment on the new and planned APIs.

More news

To find out more about what we're working on, see our article online: What's new in Excel for the web.

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×