Generate formula rows and columns with Copilot in Excel

With the formula generation capabilities available with Copilot in Excel, you can effortlessly create new columns or rows in your table that perform calculations based on existing data.

For instance, you might want to generate a column that calculates the total cost per product or a row that sums up the total sales for each quarter. Now you don’t need to manually enter calculations for each row or column, streamlining your workflow and ensuring accuracy.

Note: This feature is being gradually rolled out to all customers and may not be available to you yet. Check back for updates as it will be available to everyone soon.

Create formulas in columns or rows with Copilot

Open Excel.
Make sure the sensitivity level for the workbook isn't set to Confidential or Highly Confidential.
You'll need to have some data in your sheet to be able to create helpful formulas. Format your data in a table or supported range to make sure that it works for Copilot.
From the Home tab, select the Copilot icon in the ribbon.
Select Suggest a formula column or Show suggestions for formula columns from the Copilot pane. You can also describe what columns or rows you'd like to add by typing it in your own words or copying and pasting one of the example prompts.
Copilot provides formula suggestions with an explanation of how each formula works. View the explanation by selecting Show explanation.
Select Insert column to add the formula column or row to your table.

Note: As with any AI-generated content, it's important to review, edit, and verify anything Copilot creates for you.

Create formula rows and columns with prompts like:

Icon depicting a document with sparkles Calculate the total cost per product in a new column.

Icon depicting a document with sparkles Add a column that calculates the total profit for each marketing campaign in 2022.

Icon depicting a document with sparkles Add a column that calculates the number of days after the product launch event.

Icon depicting a document with sparkles Add a row that calculates the average revenue, ROI, and sales.

More ways to work with formulas with Copilot in Excel

Understand formulas with Copilot in Excel

Create a single-cell formula with Copilot in Excel

Generate formula rows and columns with Copilot in Excel

Create formulas in columns or rows with Copilot

Create formula rows and columns with prompts like:

More ways to work with formulas with Copilot in Excel

Need more help?

Want more options?

Was this information helpful?

Thank you for your feedback!