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!

Just released

Automate your repetitive tasks with Office Scripts in Excel for the web

Excel Scripting

___________________________________________

New linked data types bring you facts and data on hundreds of subjects.

Linked Data Types

___________________________________________

You can now search values within Data Validation dropdown lists.

Search Dropdown

___________________________________________

Excel for the web now supports refreshable connections to other workbooks.

Workbook Link

___________________________________________

Switch between the display of formulas and their results.

Show Formula

Resize Table dialog

Resize a table by selecting a new range.

First screen of the Text to Columns Wizard

Split text across columns using the Convert Text to Columns Wizard.

The Slicer Settings pane

Adjust a slicer using the Slicer Settings pane. Select the slicer, then select Slicer > Settings.

          The All Sheets menu, opened

Quickly pick any sheet from the All Sheets menu - no horizontal scrolling.

          LET function

Use the LET function to create named variables in formulas.

Regional Settings button

Adjust the format you see for dates, currency and more using the regional format settings.

We released these Excel for the web features during 2020.

Renaming a table using the ribbon

Rename an Excel table

Easily replace the default names Excel gives your tables with more meaningful names.

          Simplified ribbon

The new look of Office

Excel for the web gets the simplified ribbon.

          Touch-based menu in Excel for the web


Touch-based menu in Excel for the web   

New touch-based menu lets you perform basic Excel tasks with a finger.

Comment thread inline instead of in the Comments Task Pane

Insert comments right in the grid

Comments now work like they do in desktop Excel, except that in Excel for the web, you can also use the Comments Task Pane to review all comments in the workbook.

Using an at-mention in a comment

Use @mention in comments to tag someone for feedback

An @mention alerts the person and gives them an easy way to provide input in the comment thread.

Totals Row drop-down showing aggregate function options

Set the function for a Totals Row cell

Select the aggregate function used by the Totals row.

Discontinuous ranges selected in Excel for the web

Discontinuous selections   

Select discontinuous ranges and apply all kinds of operations on the selection. 

Email sent via @mention from Excel for the web

Read and reply on the fly   

Respond to comments and @mentions made in Excel right from email without opening the workbook.

The Settings button on the PivotTable tab in Excel for the web

PivotTable Settings

Use the PivotTable Settings pane to make changes to your PivotTable's layout and formatting.

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.

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.

  

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.

Supports co-authoring of protected files to web & desktop

Get Organization Data from Power BI using Excel Data Types

New conditional formatting experience

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

Icon for XLO Blog post - Whats New
What's New in Excel for the web
by Danielle Rafiniski on 03-02-2021 

Delighting our customers with faster, smoother, and richer experiences in Excel for the web is an uncompromised goal across our Excel team.

Read more

Icon for XLO Blog post - Performance
Performance Improvements in Excel for the web
by Danielle Rafiniski on 01-25-2021

We've improved performance when opening workbooks, navigating within a workbook, and other interactions.

Read more

Icon for XLO Blog post - Simpler ribbon
Simplified Ribbon is now available in Excel for the web
by Atri Roy on 12-16-2020

The Simplified Ribbon has a refreshed modern design that's easy to use while offering all the functionality and power of the classic Excel ribbon.

Read more

Icon for blog post about Excel for the web's LET function
LET - Names in Formulas - Generally Available
by Chris Gross on 11-16-2020

We've made the LET function generally available. Now you can give names to calculations or expressions, to make formulas easier to create and read.

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.

Need more help?

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?

×