What's new in Excel 2019 for Mac

If you're upgrading to Excel 2019 for Mac from Excel 2016 for Mac, you'll still have all the features you're used to—and you'll notice a few new ones as well!

New functions

We continue to make improvements with Excel, and its native functions.

CONCAT

This new function is like CONCATENATE, but better. First of all, it's shorter and easier to type. But it also supports range references, in addition to cell references. Learn more about CONCAT.

IFS

Tired of typing complicated, nested IF functions? The IFS function is the solution. With this function, conditions are tested in the order that you specify. If passed, the result is returned. You can also specify an else "catch all" if none of the conditions are met. Learn more about IFS.

SWITCH

This function evaluates an expression against a list of values in order, and returns the first matching result. If no results match, the "else" is returned. Learn more about SWITCH.

TEXTJOIN

This function combines text from multiple ranges, and each item is separated by a delimiter that you specify. Learn more about TEXTJOIN.

New charts

Map charts

You can create a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes. Watch a quick map chart video here.

Excel MapChart with Value data

Funnel charts

Funnel charts show values across multiple stages in a process. For example, you could use a funnel chart to show the number of sales prospects at each stage in a sales pipeline. Typically, the values decrease gradually, allowing the bars to resemble a funnel.

Funnel chart showing sales pipeline; stages listed in the first column, values in the second

General improvements

Precision selecting

Ever selected too many cells or the wrong ones? You can now deselect extraneous cells without having to start over.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Timeline filters

Want to take a look your PivotTable data across years, quarters, months or even days? Easily filter a PivotTable with a timeline filter by sliding the date range.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Customize the Ribbon

We've extended Ribbon customization to Excel 2019 for Mac. You can set preferences for the Quick Access toolbar, and personalize the Ribbon the way you want it. You can change default tabs, or create custom tabs and custom groups to contain your frequently used commands.

See and restore previous versions

You can now look back and see previous versions of a workbook, and even restore one if you like.

Break the language barrier

Translate words, phrases, or sentences to another language with Microsoft Translator. You can do this from the Review tab in the ribbon.

Translator button, and one word in English and its translation in French

One-click fixes for accessibility issues

The Accessibility Checker is better than ever with updated support for international standards, and handy recommendations to make your documents more accessible.

Computer screen with document on the left and Accessibility visual with a check mark on the right
Expand your Office skills
Explore training
Get new features first
Join Office Insiders

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.

×