Excel will soon have Formula data summaries in rows and cells

It will be released in July 2024 worldwide

2 min. read

Published onJune 7, 2024

published onJune 7, 2024

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Microsoft is developing a Formula data summaries in rows and cells feature for Excel that can revolutionize data summaries and allow you to simplify data analysis by summarizing column data into a single cell or creating rows with formulas for relevant columns.

This will streamline complex calculations, boost productivity, and promote better workflow.

Here is the description mentioned on theMicrosoft 365 Roadmapsite:

Add a single formula to summarize column data into one cell. Today, full column calculations product a unique result in each row, but this new feature gives you the option to calculate all data in a column together to return one result. You can also create a row with formulas that apply for relevant columns; for example, an “add total sales row” will add a SUM formula underneath the every column that has sales data.

It was added to the Microsoft 365 Roadmap site with Feature ID 398989 on June 5, 2024. It will be released in July 2024 for all the users worldwide. You will be able to access it on various platforms, including Mac, desktop, and web.

To conclude, Excel users can look forward to using the feature to simplify the data analysis process and save time.

Recently, Microsoft added a functionality that lets youchange your handwriting into text on Excel. To know more, check out this article.

What do you think about the Formula data summaries in rows and cells in Excel? Share your views with our readers in the comments section below.

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Excel will soon have Formula data summaries in rows and cells#

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Excel will soon have Formula data summaries in rows and cells