Wednesday, August 10, 2022

What's new in Excel for Microsoft 365 [MS]

What's new in Excel for Microsoft 365

As a Microsoft 365 subscriber, you regularly get new and improved Office features. Take a look below to see what's available to you today.

Latest updates for Excel for Windows Desktop

Here's what's new in Version 16.0.15028.20160, the March release. Find your Office version

Note: If you use Office at work, the availability of the features above may vary based on your company's update policies.

Keeping your stock info up to date

All of the Stocks data types in your workbook will refresh each time you open the file and again every five minutes.

Want new features first?

Become an Office Insider and you'll be first in line to see new features and tell us what you think.

JOIN OFFICE INSIDER TODAY

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

More about releases

When do I get new features?
New Microsoft 365 features are sometimes rolled out over a period of time to all subscribers.

See how features are rolled out

Complete list of all updates
Get information about all the channel releases for Microsoft 365 client applications.

Latest releases

New for non-subscribers
Not a Microsoft 365 subscriber but using Office 2016 or Office 2019? Find out what's available in your version.

What's new in Office 2016? What's new in Office 2019?

Previous releases

Here's what's new in Version 2201 (14931.20120).

Enjoy an improved scrolling experience

Scrolling through your sheet just got smoother when navigating large or very wide cells.

LEARN MORE

Here's what's new in Version 2112 (14827.20192).

Want your workbook to take you places?

Understand the layout of your workbook, see what elements exist, and navigate around quickly using the Navigation pane.

LEARN MORE

Here's what's new in Version 2109 (14430.20234).

Office apps now support OpenDocument Format (ODF) 1.3

ODF 1.3 brought many improvements to the OpenDocument format and these are now supported in Word, Excel, and PowerPoint (file extensions .odt, .ods, and .odp).

Get a preview of your query results when hovering over the query's name

Enable the display of a query preview popup window with new settings in the Queries & Connections pane.

LEARN MORE

Here's what's new in Version 2108 (14326.20238).

Office has a fresh look

The new visual refresh is modern and new, designed to make it simple, intuitive, and seamless experience across all your Office apps.

Here's what's new in Version 2107 (14228.20324).

Get control over the first two query steps that automatically promote column headers and change data types

By default, Power Query promotes a first row to a column header and converts the Any data type to a specific data type, but you can control this with a Query option.

Here's what's new in Version 2105 (14026.20246).

Linked data types

Linked data types: Real data for real life

New linked data types bring you facts and data on hundreds of subjects to help you accomplish your goals right in Excel.

LEARN MORE

Shows accessibility ribbon

A new way to reach the Accessibility tools

The Accessibility ribbon puts all the tools you need to create accessible content in one place.

Here's what's new in Version 2011 (13530.20316).

Conditional formatting dialog

Improved Conditional Formatting dialogs

Conditional Formatting dialogs are now resizable, and now you can duplicate the rule with a single click.

LEARN MORE

Use SVGs from Office across 3rd party apps

Paste SVG content from Office into 3rd party apps such as Adobe Illustrator or Photoshop.

Here's what's new in Version 2010 (13426.20306).

Unhide many sheets at the same time

No need to unhide one sheet at a time anymore -- unhide multiple hidden sheets at once.

LEARN MORE

Custom data type

Create a custom data type in Power Query

Use any data source to create a custom data type that lets you load multiple related pieces of information into one column.

LEARN MORE

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.)

Latest updates for Excel for the Web

Formula Library

Improved Formulas menu and Function library

Easily choose functions and formulas from the detailed Function library on the Formulas menu.

LEARN MORE

Previous releases

Right Click PivotTable

Sort and filter your PivotTables using the right-click menu

PivotTable Fields

Enjoy a new interface for managing your PivotTables

LEARN MORE

Slicers

Create slicers for PivotTables to filter data the way you want

LEARN MORE

PivotTable Filter Menu

Refining PivotTables is easier with the new filter menu

Phonetic Text

Japanese language customers can see phonetic text.

Upload to Sharepoint

Open and edit files up to 100 MB from SharePoint

Open Password Protected File in XLO

Files that have been password protected on the desktop can now be edited in Excel for the Web

SmartArt

Open and edit files containing SmartArt objects.

Conditional Formatting

Add or edit rules from the new modern Conditional Formatting task pane

Text in Shape

Add text to shapes

Link to comment

Create and share a link directly to a comment

Add Dataset from PowerBI

Find new insights in your data by creating a PivotTable from Power BI Datasets.

Stocks Update

Stocks in your workbook will refresh each time you open the file and again every five minutes

XLO Offline

Continue to read and scroll through your workbook even if your internet connection is down.

Latest updates for Excel for Mac

Here's what's new in version 16.59.22031300, the March update.

Enjoy an improved search experience

Get a more extensive set of results for your searches in the updated Find tool.

Want your workbook to take you places?

Understand the layout of your workbook, see what elements exist, and navigate around quickly using the Navigation pane!

LEARN MORE

Want new features first?

Become an Office Insider and get early access to the latest Office innovations. We're continuously hard at work on exclusive monthly upgrades and new features for Microsoft 365 subscribers.

JOIN OFFICE INSIDERS TODAY

Previous releases

Want your workbook to take you places?

Understand the layout of your workbook, see what elements exist, and navigate around quickly using the Navigation pane!

LEARN MORE

Import data from local files with Power Query

You can now import data from local Excel workbooks, text and CSV files with Power Query

LEARN MORE

Get in control with new data source settings on Excel for Mac

Get in control with new data source settings on Excel for Mac.

LEARN MORE

Linked data types

Linked data types: Real data for real life

New linked data types bring you facts and data on hundreds of subjects to help you accomplish your goals right in Excel.

LEARN MORE

A new way to reach the Accessibility tools

The Accessibility ribbon puts all the tools you need to create accessible content in one place.

Get a Refreshed Look for your Office Start Screen on Mac

A new refreshed look that uses our Fluent toolkit to align with Apple's new design language in Big Sur.

Editor Offers Writing Suggestions in a Single Click

Get spelling, grammar and other intelligent writing suggestions in a single right-click (Alt +Down). Use the left-click to view the new card design and discover other options lie Add to dictionary, Show context, synonyms and more.

LEARN MORE

Easily pick common calculation options for PivotTable columns

Right-click a PivotTable value and choose "Show Values As..." to pick a value calculation, such as % of column total.

LEARN MORE

Get Organization Data from Power BI using Excel Data Types

Insert data from your Organization using Excel Data Types. Convert a cell in your workbook and get additional information and refresh the data anytime you need.

LEARN MORE

Unhide multiple sheets

Unhide Many Sheets at the Same Time

No need to unhide one sheet at a time anymore—unhide multiple hidden sheets at once.

LEARN MORE

Watch your formulas

Watch Your Formulas

Watch cells across multiple sheets and books in a single pane or window.

LEARN MORE

Latest updates for iOS

Read on to see what's new in version 2.59.22030700, the March update.

Work with your tables in a better way using Cards View

Cards View allows you to work with tables using a mobile-optimized interface that keeps the focus on your data.

LEARN MORE

Want new features first?

Become an Office Insider to get early access to the latest Office innovations.

JOIN OFFICE INSIDERS TODAY

Previous releases

Here's what's new in version 2.54.21100301, the August update.

Quickly Delete a File or Folder

Swipe left or tap and hold to quickly delete a file or folder.

Here's what's new in version 2.52.21080301, the August update.

Format Painter is now available on the iPad

Quickly copy all the formatting from one block of text and apply it to another on the iPad with the Format Painter.

LEARN MORE

Here's what's new in version 2.51.21071204, the July update.

Excel on iPad Has a New Look

Check out the new ribbon and commands design and let us know what you think.

Here's what's new in version 2.50.21061002, the June update.

View or Edit Your Files Offline in iOS

Mark your files as available offline, so you can access them on even when you aren't connected to the internet.

Add more expression to your documents

Animated GIFs are now supported in the Office editor.

Here's what's new in version 2.47.21030900, the March update.

Quickly Access Useful Commands

Open the context menu with just one click using a mouse or trackpad.

Here's what's new in version 2.43.20110606, the November update.

Open Your Spreadsheets in Multiple Windows

Work on multiple Excel files side-by-side on iPad. This feature is currently only available for iPadOS13 users.

Latest updates for Android

There is nothing new in 16.0.15028.20140, the March update. But check out one of the recent features we released.

Work with your tables in a better way using Cards View

Cards View allows you to work with tables using a mobile-optimized interface that keeps the focus on your data.

LEARN MORE

Want new features first?

Become an Office Insider and you'll be first in line to see new features and tell us what you think.

JOIN OFFICE INSIDERS TODAY

Previous versions

Dark mode now available for Android devices

Try out a dramatic new look that's easy on your eyes and helps you focus on your work.

Edit data quickly on the go

Cards view, optimized for mobile devices makes it easier to view and edit data.

Look left, look right… XLOOKUP is here!

Row by row, find anything you need in a table or range with XLOOKUP.

Read and reply on the fly

Respond to comments and mentions right from email without opening the workbook.

See what you want to see

The Sort and Filter pane has been optimized for mobile so you can filter columns, apply conditional filters, and view a tree list for dates.

Focus on what's left to do

Select Resolve to collapse comments and make open items stand out.

No comments:

Post a Comment

Search This Blog

"Windows cannot access the specified device, path, or file" error when you try to install, update or start a program or file [MS]

"Windows cannot access the specified device, path, or file" error when you try to ...