GadgetBond

  • Latest
  • Features
  • How-to
  • Tech
    • AI
      • Apple Intelligence
      • Gemini AI
      • Google DeepMind
      • Anthropic
      • Claude AI
      • Claude Code
      • OpenAI
      • ChatGPT
      • Codex
      • Perplexity
      • SpaceXAI
      • Grok AI
      • Microsoft Copilot
      • Meta AI
    • Amazon
    • Apple
    • CES
    • Computing
    • Creators
    • Google
    • Meta
    • Microsoft
    • Mobile
    • NVIDIA
    • Samsung
    • Security
    • Smart Home
    • Sony
    • Xbox
    • YouTube
  • Transportation
    • Audi
    • BMW
    • Cadillac
    • E-Bike
    • Ferrari
    • Ford
    • Honda Prelude
    • Lamborghini
    • McLaren
    • Mercedes
    • Porsche
    • Rivian
    • Tesla
  • Culture
    • Gaming
    • Streaming
    • Apple TV
    • Disney
    • Hulu
    • Marvel
    • HBO Max
    • Netflix
    • Paramount
    • SHOWTIME
    • Spotify
    • Star Wars
Add GadgetBond as a preferred source to see more of our stories on Google.
Font ResizerAa
GadgetBondGadgetBond
  • Latest
  • Tech
  • AI
  • Features
  • Deals
  • How-to
  • Apps
  • Computing
  • Gaming
  • Mobile
  • Streaming
  • Transportation
Search
  • Latest
  • Deals
  • Buying Guide
  • How-to
  • Features
  • Tech
    • Amazon
    • Apple
    • CES
    • Computing
    • Creators
    • Google
    • Meta
    • Microsoft
    • Mobile
    • NVIDIA
    • Samsung
    • Security
    • Smart Home
    • Sony
    • Xbox
    • YouTube
  • AI
    • Apple Intelligence
    • Gemini AI
    • Google DeepMind
    • Anthropic
    • Claude AI
    • Claude Code
    • OpenAI
    • ChatGPT
    • Codex
    • Perplexity
    • SpaceXAI
    • Grok AI
    • Microsoft Copilot
    • Meta AI
  • Transportation
    • Audi
    • BMW
    • Cadillac
    • E-Bike
    • Ferrari
    • Ford
    • Lamborghini
    • McLaren
    • Mercedes
    • Porsche
    • Rivian
    • Tesla
  • Culture
    • Gaming
    • Streaming
    • Apple TV
    • Disney
    • Hulu
    • Marvel
    • HBO Max
    • Netflix
    • Paramount
    • SHOWTIME
    • Spotify
    • Star Wars
Follow US
AIAppsMicrosoftProductivityTech

Microsoft Excel adds a COPILOT formula so AI can fill the grid — and yes, it writes in cells now

With the new Copilot formula, Excel users can automate tasks like tagging feedback, building tables, and generating product blurbs using natural language prompts.

By
Shubham Sawarkar
Shubham Sawarkar's avatar
ByShubham Sawarkar
Editor-in-Chief
Shubham Sawarkar is a technology journalist at GadgetBond, covering Apple, AI, consumer technology, software, gadgets, and product launches. His work explores emerging technologies, industry developments, product...
Follow:
- Editor-in-Chief
Aug 25, 2025, 7:05 AM EDT
Share
COPILOT function in Microsoft Excel
Image: Microsoft
SHARE

If you thought Excel’s AI was already busy enough suggesting charts and answering questions in a side panel, Microsoft just pushed the assistant inside the grid itself. This month, the company began rolling out a new =COPILOT() formula that lets you type a natural-language prompt directly into a cell, point the formula at a range, and have an LLM return results that spill into the sheet — classifying feedback, summarizing text, generating descriptions, building mini-tables and more.

What it is (and how you actually use it)

Think of =COPILOT() like any other Excel function, except its “work” happens by calling a large language model. The basic syntax Microsoft shows is:

=COPILOT(prompt_part1, [context1], [prompt_part2], [context2], ...)

So to classify a column of customer comments, you might write:

=COPILOT("Classify this feedback", D4:D18)

or to make product blurbs from specs:

=COPILOT("Create a description for this product based on its specs", B2:B8)

Because the function is integrated into Excel’s calculation engine, results update automatically when source cells change, and you can nest COPILOT inside other Excel machinery (IF, SWITCH, LAMBDA, WRAPROWS, etc.). That makes it feel — for better or worse — like just another formula.

The engine under the hood

Reporting indicates Microsoft is running the function against an OpenAI model (reported as gpt-4.1-mini), which is why the results are natural-language first. Microsoft itself frames the feature as the successor to the experimental LABS.GENERATIVEAI function that it trialed inside Excel Labs in 2023, but now it’s a built-in function available to Copilot customers in preview.

Limits, guardrails and privacy

Microsoft is explicit about two practical limits right now:

  • The COPILOT function is model-grounded: it cannot fetch live web pages or reach into enterprise stores (SharePoint, Teams, etc.) — at least initially. If you want enterprise or web sources included, you must import the data into the workbook or wait for future updates that expand its knowledge sources.
  • Usage is throttled to keep compute predictable: the function currently supports 100 calls every 10 minutes and up to 300 calls per hour (Microsoft explains workarounds such as passing arrays so a single call can process many rows). Also, Microsoft warns that the function is not meant for numerically heavy-math or high-stakes legal/regulatory decisions because LLMs can return incorrect responses.

On privacy, Microsoft says data is passed through COPILOT is not used to train its models — the inputs remain “confidential” and are used only to produce the requested output. That’s an important distinction for businesses that have been nervous about shipping customer or internal text into third-party models.

Who can use it today (and how you get it)

The feature is rolling out to Microsoft 365 Beta Channel users who have a Microsoft 365 Copilot license — Windows and Mac builds are supported now, with web availability promised soon through Microsoft’s Frontier/web preview channels. Distribution is staged, so even some Beta users report waiting for the feature to be enabled on their accounts.

How it stacks up to Google Sheets

This isn’t a unique idea: Google added a similar cell-filling AI capability to Sheets earlier in the summer that uses Gemini and Workspace Labs tooling to generate text into selected ranges (Google’s rollout supports up to 200 selected cells per generation, for example). The two approaches converge on the same user problem — automating repetitive text work inside a spreadsheet — but each company’s limits and licensing models differ (Microsoft ties this to the Copilot add-on; Google’s functionality has been part of Workspace Labs / Gemini access paths). If you live in spreadsheets, this now becomes a platform choice as much as an AI capability.

Practical uses (and pitfalls)

What you’ll see people trying right away:

  • Bulk classify and tag survey responses or support tickets inside a table.
  • Summarize long comments into one-line takeaways for reporting.
  • Generate marketing copy variations from product specs directly into a campaign spreadsheet.
  • Auto-format a column of messy text into consistent labels, lists or mini-tables that spill across rows and columns.

But caveats matter: the model can invent plausible-sounding but incorrect facts (hallucinations), it won’t know things outside the cells you give it, and frequent recalculation can create compute costs and weird nondeterminism in results. Microsoft suggests reviewing outputs, and treating COPILOT as an assistant rather than an infallible calculator.

Why this matters

Putting LLMs inside cell formulas changes the mental model for spreadsheet power users. Historically, automation in Excel meant VBA, Power Query, or complex formula workarounds; now non-developers can ask the sheet to “do the thinking” in plain English. That broadens who can automate workflows — but it also pushes organizations to rethink governance, auditing and accuracy checks in a place where small mistakes can cascade into big business decisions.

If you live in Excel — and a lot of knowledge work does — =COPILOT() is the sort of change that quietly makes the grid more like a writable AI canvas. It won’t replace skilled analysts, but it will let more people ask spreadsheets to do the tedious parts of the job in plain English. Try it carefully, double-check the outputs, and expect Microsoft to iterate quickly: this is very much still the preview phase.


Discover more from GadgetBond

Subscribe to get the latest posts sent to your email.

Most Popular

Four AI apps to act as your personal life admin team
Marvel Comics app is finally here, bringing 35,000+ comics and a new reading experience
Google introduces Stitch Loop for continuous AI-powered code optimization
Apple announces new regional taxes and December price adjustments for apps and in-app purchases
How these three Apple-recommended apps turn everyday stress into quiet me-time

Also Read

Hot air balloons float over snowy mountains under a bright sun, with "Genie 4" centered and on-screen WASD, SPACE, and arrow controls at the bottom.

Google Project Genie gets a major upgrade with Genie 4

Google Gemini Live interface displayed on a smartphone, showing the greeting “Ready when you are, Camila!” with voice, camera, and screen-sharing controls.

Google brings the Gemini app to lower-memory Android (Go edition) devices

Apple App Store icon glowing against a blue background, featured in the 2026 App Store Awards announcement.

Apple reveals the 45 finalists for the 2026 App Store Awards

Keke Palmer holds the Apple Podcasts icon while smiling against a pink and purple gradient background.

Apple Podcasts names Keke Palmer’s show its 2026 Show of the Year

Google Wallet for iOS displayed on an iPhone, featuring a digital boarding pass, Google Store delivery notification, loyalty cards, membership cards, concert tickets, and other passes. The accompanying text reads, “Google Wallet on iOS — Now available on iOS.”

Google Wallet arrives on iPhone in the U.S. for tickets, passes, and agentic purchases

Google Vids logo

Google Vids now lets anyone with a personal Google account create custom digital avatars for free

Google Search AI Mode temporary thread interface displaying a “Welcome, stranger” message and an input box, with a notice explaining that temporary threads won't appear in Search history or be used to train Google's generative AI models.

Google adds temporary threads to AI Mode in Search for off-the-record queries

Gemini interface showing "What can I get done for you?" above a "Describe a task" search bar set to "Hydrogen" and a "Task" toggle selected.

Google Gemini can now handle everyday tasks for you

Company Info
  • Homepage
  • Support my work
  • Latest stories
  • Company updates
  • GDB Recommends
  • Daily newsletters
  • About us
  • Contact us
  • Write for GadgetBond
  • Editorial guidelines
Legal
  • Privacy Policy
  • Cookies Policy
  • Terms & Conditions
  • DMCA
  • Disclaimer
  • Accessibility Policy
  • Security Policy
  • Do Not Sell or Share My Personal Information
Socials
Follow US

Disclosure: We love the products we feature and hope you’ll love them too. If you purchase through a link on our site, we may receive compensation at no additional cost to you. Read our ethics statement. Please note that pricing and availability are subject to change.

Copyright © 2026 GadgetBond. All Rights Reserved. Use of this site constitutes acceptance of our Terms of Use and Privacy Policy | Do Not Sell/Share My Personal Information.