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.

Create formulas in columns or rows with Copilot

Open Excel.
You'll need to have some data in your sheet to be able to create helpful formulas.
From the Home tab on the ribbon, select Copilot .
Type Suggest a formula column or Show suggestions for formula columns in 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.

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!