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
If you don’t see Copilot in Word, Excel, PowerPoint, or OneNote, it might not be included with your Microsoft 365 subscription or available based on your organization’s settings. Learn which Copilot license you have.
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
👁 small image of the Copilot icon.
. - 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. |
