What Copilot in Excel actually does
Copilot in Excel is an AI assistant built into Microsoft Excel that helps you analyze data, write formulas, and create charts by describing what you want in plain language instead of typing formulas yourself. You ask it questions about your spreadsheet — "show me sales by region" or "calculate the average of column B" — and it generates the formulas or visualizations you need.
Copilot is not a separate tool you download. It lives inside Excel itself, accessed through a button on the ribbon. The feature requires a Microsoft 365 subscription (the paid version of Office), not the free web version of Excel.
Before you add it, understand what you're getting: Copilot can save time on repetitive analysis tasks, but it reads your spreadsheet data to generate suggestions, so you should not use it on sensitive information like medical records, financial account numbers, or personal identification details.
Key Takeaways
- Copilot in Excel requires a Microsoft 365 subscription and is not available in the free web version of Excel.
- You enable Copilot through Excel's ribbon menu, and it appears as a button labeled "Copilot" on the right side of your screen.
- Copilot sends your spreadsheet data to Microsoft's servers to generate suggestions, so avoid using it on sensitive personal or financial information.
- The feature works best when your spreadsheet has headers in the first row and organized data in columns, not scattered across random cells.
Check your subscription and update Excel
Copilot only works if you have a Microsoft 365 subscription. This includes Microsoft 365 Personal, Microsoft 365 Family, or a business plan like Microsoft 365 Business Standard. If you own a one-time license of Excel (like "Office 2021" or "Office 2019"), Copilot will not appear.
Open Excel and go to File > Account. Look for "Product Information" or your subscription name. If you see "Microsoft 365" listed, you have the right subscription. If you see "Office 2021" or no subscription information, you need to upgrade.
Next, make sure Excel is fully updated. Go to File > Account > Update Options > Update Now. Wait for the update to finish and restart Excel. Copilot requires a recent version of Excel to function.
Enable Copilot in Excel settings
Open Excel and look at the top ribbon. On the far right side, you should see a button labeled Copilot (it looks like a small icon with a sparkle or star). If you do not see it, Copilot may not be enabled yet.
To turn it on, go to File > Options > Trust Center > Trust Center Settings > Privacy Options. Look for an option related to "connected experiences" or "optional connected experiences" and make sure it is turned on. This setting allows Excel to send your data to Microsoft's servers so Copilot can analyze it.
After enabling this setting, close and reopen Excel. The Copilot button should now appear on the ribbon. If it still does not show up, sign out of your Microsoft account (File > Account > Sign Out), then sign back in with the account attached to your Microsoft 365 subscription.
Prepare your spreadsheet for Copilot
Copilot works best when your data is organized in a specific way. Put headers in the first row — for example, "Date", "Product", "Sales", "Region" — and keep your actual data below in columns. Avoid mixing data with empty rows or placing information in random cells across the sheet.
If your spreadsheet is messy, spend a few minutes cleaning it up before using Copilot. Delete blank rows between data sections, remove extra spaces at the end of cell entries, and make sure each column contains only one type of information. A well-organized sheet means Copilot will understand your data faster and give you more accurate suggestions.
You do not need to format cells in any special way. Copilot reads the raw data, not the colors or fonts you have applied.
Open Copilot and start asking questions
Click the Copilot button on the ribbon. A panel will open on the right side of your screen with a text box that says "Describe what you want to do" or similar language. Type a plain-language description of what you need — for example, "create a chart showing total sales by month" or "add a column that calculates profit margin".
Copilot will read your spreadsheet, generate a suggestion, and show you what it plans to do before it does it. Review the suggestion carefully. If it looks right, click a button like "Insert" or "Create" to apply it. If it is not what you wanted, try rephrasing your request or providing more detail.
Common requests Copilot handles well include creating pivot tables, writing SUM or AVERAGE formulas, filtering data by criteria, and generating charts. It is less reliable at complex multi-step analysis or when your data structure is unusual.
Understand what data Copilot sees
When you use Copilot, Excel sends the contents of your spreadsheet to Microsoft's servers. This means Copilot can see every cell, every value, and every formula in your active sheet. Microsoft says it does not store this data permanently, but it is processed by their AI systems.
Do not use Copilot on spreadsheets containing social security numbers, credit card numbers, passwords, medical information, or other sensitive personal data. If your spreadsheet mixes sensitive and non-sensitive information, create a separate copy with only the non-sensitive columns and use Copilot on that version instead.
If you work in a regulated industry like healthcare or finance, check with your organization's IT or compliance team before using Copilot. Some organizations have policies restricting which tools employees can use with certain types of data.
Troubleshoot if Copilot does not appear
If you have a Microsoft 365 subscription and updated Excel but still do not see the Copilot button, try these steps in order:
- Restart Excel completely. Close all windows and open Excel again.
- Check that you are signed in with the Microsoft account attached to your subscription. Go to File > Account and verify the account name.
- Disable and re-enable connected experiences. Go to File > Options > Trust Center > Trust Center Settings > Privacy Options, turn off "optional connected experiences", click OK, then turn it back on and restart Excel.
- Check if Copilot is available in your region. As of early 2024, Copilot in Excel is rolling out gradually and may not be available everywhere yet. If you are outside the United States, it may take longer to reach your region.
If none of these steps work, your subscription type or region may not have access yet. Microsoft is expanding Copilot availability over time, so check back in a few weeks.
Frequently Asked Questions
Do I need to pay extra for Copilot beyond my Microsoft 365 subscription?
No. Copilot in Excel is included with Microsoft 365 subscriptions at no additional cost. You do not need to buy a separate Copilot license or subscription. If someone is asking you to pay extra for Copilot in Excel, they are not describing the real feature.
Can I use Copilot in the free web version of Excel?
Not yet. Copilot in Excel currently requires the desktop version of Excel and a Microsoft 365 subscription. The free web version of Excel (Excel Online) does not have Copilot access. You must download and install the desktop application.
What happens if Copilot gives me a wrong answer?
Copilot can make mistakes, especially with complex data or unusual spreadsheet structures. Always review its suggestions before applying them to your data. If a formula or chart looks wrong, reject it and try rephrasing your request or manually building what you need. Treat Copilot as a helper, not an authority.
Can I turn off Copilot if I do not want to use it?
Yes. Go to File > Options > Trust Center > Trust Center Settings > Privacy Options and turn off "optional connected experiences". The Copilot button will disappear from the ribbon. You can turn it back on the same way.
Is my data safe when I use Copilot?
Your data is encrypted in transit to Microsoft's servers, but Copilot does process it to generate suggestions. Microsoft says it does not permanently store your spreadsheet data, but it is analyzed by their AI systems. If you have concerns about data privacy, do not use Copilot on sensitive information, or check with your organization's IT team about their policies.