Copilot in Excel: how to use it on a Personal or Family plan
If you live in Singapore, Malaysia, Australia, New Zealand, Taiwan or Thailand and you pay for Microsoft 365 Personal or Family, you may have been paying for an AI assistant in Excel for up to two years. Plenty of people never clicked it.
That is not a guess about laziness. Microsoft announced on 31 October 2024 that these six markets would be the first to get Copilot inside Word, Excel, PowerPoint, Outlook and OneNote on the consumer plans, with price increases at renewal that Microsoft said “vary in each market”. The rest of the world followed in January 2025, when the US price went up by US$3 a month. In Australia the change ended up in court: the consumer regulator, the ACCC, sued Microsoft in October 2025, alleging that around 2.7 million subscribers were told to accept Copilot at the higher price or cancel, without being told about a cheaper Classic plan. Personal went from A$109 to A$159 a year, according to Information Age’s report on the case. We could not find a ruling yet.
So the question worth answering is practical. If it is on your bill, what is it good for, and how do you use it without it quietly rearranging a spreadsheet you care about?
Before you start: three things that stop it working
You have to be the subscription owner. On a Family plan, Microsoft’s support page is blunt: “only the subscription owner can use Copilot in the desktop apps”. Your partner, on the same plan, will not get it in the desktop apps.
The file must live in OneDrive with AutoSave on. Microsoft’s FAQ says Copilot in Excel requires AutoSave, and it does not work on unsaved files. A workbook sitting in your Downloads folder is the most common reason the button seems dead.
Ignore old tutorials about a =COPILOT() formula. That was a preview feature. Microsoft’s own page now says: “Starting September 14, 2026, the COPILOT function is no longer available in Microsoft Excel.” The Copilot pane replaces it.
If you have done all three and still see nothing, Microsoft’s line is that Copilot “might not be included with your Microsoft 365 subscription”. Check whether you moved to a Classic or Basic plan at some point, since those plans come without it.
The steps, on a real spreadsheet
Take something you actually keep. Say a sheet of orders for a small home business: date, customer, item, quantity, price, paid or not. Thirty or three hundred rows, typed in over months, a bit untidy.
- Open the workbook in Excel on Windows, Mac or the web and confirm the title bar shows it saved to OneDrive. Those three versions get all of Copilot’s modes. On an iPhone or Android phone you get chat only.
- Select the Copilot icon in the lower-right corner of Excel. A pane opens beside your sheet.
- Switch the mode to Plan before you type anything. Copilot opens in edit mode by default, which means it “works directly in your workbook”. Plan mode is the cautious one. In Microsoft’s words, “instead of immediate actions, Copilot generates a plan so you can review and confirm the approach before starting.”
- Ask for one job, in plain words. For the order sheet, try: “Add a column that multiplies quantity by price, then highlight every row where Paid is No.” You should see a short list of steps it intends to take. Read it. If it has misread a column, say so and ask again.
- Confirm, and watch it work. If it starts heading somewhere you did not want, there is a Stop button at the right of the chat box.
- Check the result yourself. Pick three rows and do the multiplication in your head. Click one of the new cells and look at the formula. The changes are ordinary Excel, which Microsoft describes as “your content stays editable”, so a wrong formula is fixable, but only if you look.
Once you trust it on small jobs, Microsoft lists bigger ones Copilot in Excel can do: build charts and PivotTables linked to your data, sort and filter, apply conditional formatting, point out trends or outliers, and pull in information from the web with citations. A good second prompt for the order sheet: “Make a PivotTable of total sales by month and item, and a chart of it on a new sheet.”
[[photo:1]]
Use Chat only when you just want an answer
The third mode, Chat only, “can analyze your workbook data and provide insights without making changes to your workbook”. That is the right setting for questions like “Which three customers owe me the most?” or “Which month was slowest, and was it slow on every item or just one?”
Our view: this is where most people should spend their first week. It costs you nothing in risk, and you learn quickly whether Copilot reads your columns the way you meant them. If it gets your messy “Paid” column wrong in chat, it would have got it wrong in edit mode too, and you would have found out later.
The allowance, and the off switch
The consumer plans do not give unlimited use. Microsoft describes AI credits on Personal and Family as a monthly allotment. Its current usage page says use in Excel is tracked automatically, and it describes the limits in tiers rather than as a price per prompt. Spend them on the jobs that would take you twenty minutes by hand, not on questions you could answer with a filter.
And if you decide you do not want it at all, the FAQ says Word, Excel and PowerPoint each have a setting to turn Copilot off. Turning it off only hides it. Changing what you pay means changing plans.
If you have a spreadsheet someone else built and need to understand it before changing anything, we walked through that job with a different assistant in our guide to Claude for Excel. The habit carries over: ask it to explain before you let it edit.
Was this useful?
Sources
- Get started with Copilot in Excel · Microsoft Support
- Unlock your potential with Copilot and Designer in Microsoft 365 Personal and Family · Microsoft Stories Asia
- Copilot is now included in Microsoft 365 Personal and Family · Microsoft 365 Blog
- Frequently asked questions about Copilot in Microsoft 365 subscriptions · Microsoft Support
- What Copilot license do I have · Microsoft Support
- Microsoft 365 price hikes misled Australians, ACCC says · Information Age (Australian Computer Society)
- COPILOT function · Microsoft Support