Microsoft Excel adds Copilot AI to help fill in spreadsheet cells

Microsoft Excel is testing a caller AI-powered function that tin automatically capable cells successful your spreadsheets, which is akin to the feature that Google Sheets rolled retired successful June. You would usage the “COPILOT” relation followed by a earthy connection punctual and (optionally) specify the cells you privation it to reference; the AI would past classify information, make summaries, make tables, and more.

If you person a file of cells filled with feedback astir a java machine, for example, you tin usage the COPILOT relation to rapidly classify it with AI. To bash this, you’d usage this formula: “=COPILOT(“Classify this feedback”, D4:D18),” portion ensuring that you alteration the cells to lucifer your Excel sheet. Microsoft Excel volition past output AI-generated classifications wrong each specified cell.

Here are immoderate different examples provided by Microsoft: 

• Generate text: =COPILOT(“Create a statement for this merchandise based connected its specs”, B2:B8)
• Summarize text: =COPILOT(“Summarize this feedback”, A2:A20)

The COPILOT function, which is powered by OpenAI’s gpt-4.1-mini AI model, is the successor to the LABS.GENERATIVEAI relation Microsoft started experimenting with successful 2023. 

Microsoft notes that you tin harvester its caller AI relation with different Excel functions, including IF, SWITCH, LAMBDA, oregon WRAPROWS. The institution adds that accusation sent done Excel’s COPILOT relation is “never” utilized for AI training, arsenic “the input remains confidential and is utilized solely to make your requested output.”

The COPILOT relation comes with a mates of limitations, arsenic it can’t entree accusation extracurricular your spreadsheet, and you tin lone usage it to cipher 100 functions each 10 minutes. Microsoft besides warns against utilizing the AI relation for numerical calculations oregon successful “high-stakes scenarios” with legal, regulatory, and compliance implications, arsenic COPILOT “can springiness incorrect responses.”

It’s rolling retired present to users connected Windows and Mac successful the Beta Channel with a Microsoft 365 Copilot license. Microsoft plans connected refining this diagnostic successful the aboriginal by upgrading the function’s underlying exemplary and perchance adding enactment for web access.