Copilot
Copilot in Excel
Copilot in Excel
Generate single-cell formulas with Copilot in Excel
Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for iPad Excel Web App Microsoft Office

Copilot makes it easier than ever to perform precise calculations based on your data by generating single-cell formulas. Whether you need to calculate the percentage increase between two cells or extract specific text, Copilot streamlines the process so you don’t need to enter calculations for each cell.

Generate a single-cell formula

  1. Open Excel.

  2. Add some data to your sheet. 

  3. From the Home tab, select the Copilot small image of the Copilot icon.​​​​​​​ icon in the ribbon.

  4. In the Copilot pane, prompt "Suggest a formula" or "Show suggestions for formulas".

  5. You can copy and paste an example prompt or type something in your own words.

  6. Copilot will suggest formulas and explain how each one works.

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

Generate a formula with prompts like:

Icon depicting a document with sparkles Calculate the percentage increase from cell A1 to cell B1.

Icon depicting a document with sparkles Extract the first name from a full name in cell C1.

Icon depicting a document with sparkles Calculate the difference between the values in cell D1 and E1.

More ways to work with data using Copilot in Excel

Generate formula rows or columns with Copilot in Excel

Get insights from numerical data with Copilot in Excel

Get insights from text-based data with Copilot in Excel

Facebook LinkedIn Email

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center