Share this article

Latest news

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

Copilot in Excel will get the ability to generate multiple formula columns from a single prompt

The feature is expected to roll out in April 2024

2 min. read

Published onApril 12, 2024

published onApril 12, 2024

Share this article

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

Microsoft recently updated its roadmap for Microsoft 365, adding a new feature for Excel Copilot, which will allow the generation of multiple formula columns from a single prompt.

The feature is listed as Feature ID391638and was added to the Roadmap on April 11, 2024. It will be available on Windows, Mac, and the web within the Microsoft 365 suite.

This feature is accessible worldwide on standard multi-tenant cloud deployments, and the rollout is expected to begin in April 2024.

With this update, you can get tasks like separating full names into first and last names or separating days, months, and years from date with a single prompt.

There is no further mention of this upcoming multi-formula generation feature, but we can anticipate that it will offer a range of pre-defined formula options or allow Copilot to learn from user preferences over time.

This feature could be very useful for those who often use formulas and deal with complex data structures. Another important feature pending rollout this month isCopilot in Excel support for complex formula columns from multiple tables.

Microsoft also added a newCopy/Paste experience to the Excel web app. Now, you can use drag-and-drop auto-fill to copy and paste content. Moreover, you will get a list of paste options.

To conclude, Microsoft’s advancement in Copilot features for Microsoft 365 shows its commitment to providing users with a seamless experience. Furthermore, this newest feature is great for both experienced and newbie Excel users.

However, if you haven’t tried Copilot in Excel yet, maybe this is the sign to do it. We havea detailed guideon everything you need to know to use it. If you have already used it, share your experience with our readers in the comments section below.

More about the topics:microsoft,Microsoft copilot

Srishti Sisodia

Windows Software Expert

Srishti Sisodia is an electronics engineer and writer with a passion for technology. She has extensive experience exploring the latest technological advancements and sharing her insights through informative blogs.

Her diverse interests bring a unique perspective to her work, and she approaches everything with commitment, enthusiasm, and a willingness to learn. That’s why she’s part of Windows Report’s Reviewers team, always willing to share the real-life experience with any software or hardware product. She’s also specialized in Azure, cloud computing, and AI.

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Δ

Srishti Sisodia

Windows Software Expert

She is an electronics engineer and writer with a passion for technology. Srishti is specialized in Azure, cloud computing, and AI.