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
- Open Excel.
- Add some data to your sheet.
- From the Home tab, select the Copilot
icon in the ribbon. - In the Copilot pane, prompt "Suggest a formula" or "Show suggestions for formulas".
- You can copy and paste an example prompt or type something in your own words.
- 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:
Calculate the percentage increase from cell A1 to cell B1.
Extract the first name from a full name in cell C1.
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