Step-by-step
📊 Copilot
Microsoft
📘 Step-by-step 📘 Microsoft · Copilot↗ Copilot · Official sitebeginner 🔄 Life & Business

Use Copilot to Write Spreadsheet Formulas Without the Tech Jargon

A plain-English walkthrough for getting Copilot to draft Excel and Google Sheets formulas you can actually paste and use

6 min read·July 25, 2026

This guide was written by AI. It passed automated fact and quality checks, and our editor spot-checks published guides every day.

See AI World HQ first on GoogleAdd us as a preferred source and our stories show up higher in Google’s Top Stories.Add on Google

If you've ever stared at a spreadsheet wishing someone would just write the formula for you, this guide is for you. In about six minutes, you'll learn how to ask Copilot — Microsoft's AI assistant — to turn plain-English requests into real formulas you can paste into Excel or Google Sheets, even if you've never written a formula in your life.

💡 Tip: tap a step’s number when you finish it — a green tick appears and your browser remembers how far you got.

✅ Before you start
  • An account with Microsoft Copilot. You can use the free version at copilot.microsoft.com, or open Copilot inside Microsoft 365 apps like Excel (paid Microsoft 365 plans include Copilot). A free Microsoft account is enough to get started on the web.
  • A spreadsheet to test with. Either Excel (desktop or web) or Google Sheets will work. The formulas you'll learn about are mostly the same in both.
  • Roughly 10 minutes. Most of that is reading and one test run.
  • One honest note: Copilot can write a formula for you, but it cannot run that formula inside your spreadsheet automatically — you'll still need to copy it in yourself. Think of Copilot as your formula translator, not your spreadsheet robot.
1
Step 1 of 6

Open Copilot and start a new chat

Open your browser and go to copilot.microsoft.com. Sign in with your Microsoft account if asked. Once the page loads, you'll see a chat box near the middle of the screen with a blinking text cursor and a placeholder like "Ask me anything…". Click inside that box and type your first message. A new conversation begins, and Copilot will start thinking about your request.

🔄 If it looks different

If you can't find the website, search "Microsoft Copilot" and look for the link that ends in microsoft.com.

✅ You'll know it worked when

**** the chat box lets you type and Copilot replies with a friendly opening message.

Next step ↓
Copilotcopilot.micros…
✏️ Sketch — your screen may look a little different
2
Step 2 of 6

Tell Copilot what your spreadsheet looks like

Before you ask for a formula, give Copilot the context it needs. In plain words, describe what your columns are called and what's in them. A formula is just a tiny instruction a spreadsheet follows to calculate something — like adding up a list of numbers. Type your description straight into the chat box and press Enter or the send arrow. Copilot will reply confirming it understands. If your screen shows a different layout, look for a text box labeled "Message Copilot" or a microphone icon for voice — both work the same way.

💬 Example*"I have a spreadsheet with column A called 'Item', column B called 'Price', and column C called 'Quantity'. I want to work out totals."*
✅ You'll know it worked when

**** Copilot summarizes your columns back to you.

Next step ↓
CopilotEnter
✏️ Sketch — your screen may look a little different
3
Step 3 of 6

Ask for the formula in everyday words

Now type what you actually want the spreadsheet to do, written like you'd explain it to a friend. Don't worry about formula grammar — that's Copilot's job. Press Enter and wait a few seconds. Copilot will reply with a formula written in spreadsheet language, usually inside a gray code box you can copy. If Copilot gives a long answer instead, look for a line that starts with an equals sign (=) — that's the formula.

💬 Example*"Write me a formula for cell D2 that multiplies the price (B2) by the quantity (C2)."*
✅ You'll know it worked when

**** you see something starting with = that looks like a tiny instruction, not a sentence.

Next step ↓
CopilotEnter
✏️ Sketch — your screen may look a little different
4
Step 4 of 6

Copy the formula and try it in your spreadsheet

Highlight the formula Copilot gave you, right-click and choose Copy, or use the keyboard shortcut Ctrl + C (or Cmd + C on a Mac). Then open your spreadsheet, click the cell where you want the answer to appear, and paste with Ctrl + V (or Cmd + V). Press Enter. The cell will immediately show either a number or a message like #VALUE!. If you see a number — perfect. If you see an error message, don't panic: it usually just means a cell reference is slightly off, which Step 5 covers.

💬 ExampleCopilot's reply might be `=B2*C2` — you'd paste that into cell **D2** and press **Enter**.
✅ You'll know it worked when

**** the cell shows a calculated number that matches what you'd expect by hand.

Next step ↓
CopilotCopy
✏️ Sketch — your screen may look a little different
5
Step 5 of 6

Adjust the formula if something looks off

If the answer is wrong, or you see an error like #REF! or #VALUE!, copy the error message and paste it back into Copilot with a short explanation. A cell reference is just the letter-and-number label of a cell, like B2. Tell Copilot which row or column is wrong, and ask it to fix the formula. Press Enter and wait for the new version. If Copilot's reply looks the same as before, add more detail — for example, mention that column A is text and column B starts in row 2.

💬 Example*"That gave me #VALUE! in cell D2. Column B has dollar signs in it like '$10' instead of just numbers. Can you fix the formula?"*
✅ You'll know it worked when

**** Copilot returns a tweaked formula that, when pasted, gives the right number.

Next step ↓
CopilotEnter
✏️ Sketch — your screen may look a little different
6
Step 6 of 6

Ask follow-up questions to build on the formula

Once one formula works, you can keep the conversation going and ask for more advanced ones — like adding totals, counting items, or finding averages. An average is just the middle value of a group of numbers (add them all up, then divide by how many there are). Type each new request as a fresh sentence, and Copilot will remember your column names from earlier. If you ever start a brand-new chat, just re-share the column layout from Step 2.

💬 Example*"Now write me a formula that adds up everything in column D from row 2 down to the last row of data."*
✅ You'll know it worked when

**** each new formula pastes cleanly and gives you a sensible number.

CopilotNow write me aformula that adds upeverything in column…
✏️ Sketch — your screen may look a little different
⚠️ Common mistakes
  • Asking for a formula without describing your columns. Copilot will guess, and its guess may not match your sheet. Fix: always spend 10 seconds naming your columns before you ask for the formula.
  • Pasting the formula into the wrong cell. The formula is built for a specific cell, usually row 2. Fix: check the formula's cell references — if it says B2*C2, paste it into row 2, not row 1.
  • Assuming the formula will update itself if your data changes. Most formulas do update automatically, but only if you haven't accidentally turned calculations off. Fix: if numbers stay frozen, press F9 to recalculate, or check that Excel's calculation setting is on "Automatic".
🚀 Try it now

Open Copilot in a new tab, type "I have column A with names and column B with ages. Write me a formula that shows 'Adult' if the age is 18 or over and 'Minor' if it's under 18." Copy the formula it gives you, paste it into a blank cell in a test spreadsheet, and see what appears.

🎯 Next guideHow to Use Copilot in Word to Turn a Long Report Into a One-Page SummaryA practical, beginner-friendly walkthrough that keeps your voice and key numbers, and drops the jargon for a boss-ready one-pager.

❓ Quick questions

How long does this take?

About 6 minutes — the guide has 6 steps, and you can tick each one off as you go.

Which tool do I need?

This guide uses Microsoft Copilot — but the approach works very similarly in other AI assistants.

Do I need to prepare anything?
  • An account with Microsoft Copilot. You can use the free version at copilot.microsoft.com, or open Copilot inside Microsoft 365 apps like Excel (paid Microsoft 365 plans include Copilot). A free Microsoft account is enough to get started on the web.
  • A spreadsheet to test with. Either Excel (desktop or web) or Google Sheets will work. The formulas you'll learn about are mostly the same in both.
  • Roughly 10 minutes. Most of that is reading and one test run.
  • One honest note: Copilot can write a formula for you, but it cannot run that formula inside your spreadsheet automatically — you'll still need to copy it in yourself. Think of Copilot as your formula translator, not your spreadsheet robot.
What mistakes should I avoid?
  • Asking for a formula without describing your columns. Copilot will guess, and its guess may not match your sheet. Fix: always spend 10 seconds naming your columns before you ask for the formula.
  • Pasting the formula into the wrong cell. The formula is built for a specific cell, usually row 2. Fix: check the formula's cell references — if it says B2*C2, paste it into row 2, not row 1.
  • Assuming the formula will update itself if your data changes. Most formulas do update automatically, but only if you haven't accidentally turned calculations off. Fix: if numbers stay frozen, press F9 to recalculate, or check that Excel's calculation setting is on "Automatic".

Keep reading

📘 How to Spot Hidden Errors in an Excel Budget with Copilot Use Microsoft's Copilot to scan your Excel budget for broken formulas and inconsistent numbers before they quietly drain your wallet 📘 How to Build a Clean Invoice and Payment Tracker in Excel with Copilot Set up a simple spreadsheet that tracks who owes you, when it's due, and gently highlights overdue payments. 📘 Build a Simple Personal Budget Spreadsheet Using Any AI Assistant Ask any AI assistant to design a beginner-friendly budget template, then drop it into Excel or Google Sheets in under 15 minutes 📘 How to Use Copilot in Word to Turn a Long Report Into a One-Page Summary A practical, beginner-friendly walkthrough that keeps your voice and key numbers, and drops the jargon for a boss-ready one-pager. 📘 Start Using Microsoft Copilot in Word, Excel, and Outlook Discover how to draft documents, analyze data, and manage your inbox more efficiently with Microsoft's built-in AI assistant. 📘 How to Build a Simple Weekly Schedule in Google Sheets with Gemini Describe your week and get a ready-to-use template with time blocks, color categories, and hours-totaling formulas
Was this helpful?

✦ Generated by AI in AI World HQ's automated newsroom, written in plain language. Checked by automated fact and quality gates, and our editor spot-checks published guides every day. Spot a mistake? Use the buttons above.

📘 Prefer it in one file? Work and Email: The AI Pack (20 guides, free printable PDF)

← Back to all stories