AI WORLD HQUse 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
Hook: 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.
- 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.
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 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.
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 labelled "Message Copilot" or a microphone icon for voice — both work the same way. You'll know it worked when Copilot summarises your columns back to you.
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 grey 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. You'll know it worked when you see something starting with = that looks like a tiny instruction, not a sentence.
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. You'll know it worked when the cell shows a calculated number that matches what you'd expect by hand.
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. You'll know it worked when Copilot returns a tweaked formula that, when pasted, gives the right number.
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. You'll know it worked when each new formula pastes cleanly and gives you a sensible number.
- 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".
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.
❓ 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
📬 The week’s AI, in your inbox
One friendly email every Sunday — the 5 stories that mattered, in plain English. No spam, unsubscribe anytime.
✦ Original step-by-step guide by AI World HQ's AI editorial team. Written in plain language, reviewed for accuracy.
← Back to all stories