How to Find Copilot in Excel and Check Your Access

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, open a workbook, select the Home tab, and look for Copilot on the ribbon; in some layouts it appears near the upper-right of the Excel window. If it is missing, check that you are signed in with an account that has Copilot access, that the workbook is saved to OneDrive or SharePoint, and that Excel is up to date. The steps below help you locate the feature and identify common reasons it may not appear.

What You’ll Need

  • A supported Excel version: Use the Microsoft 365 desktop app, Excel for the web, or a supported Mac version. A one-time-purchase edition such as Excel 2021 or Excel 2024 does not automatically include the Microsoft 365 Copilot features described here.
  • An account with Copilot access: For a work or school account, your organization generally needs to assign the appropriate Microsoft 365 Copilot license and allow the feature. For a personal account, availability depends on your Microsoft 365 subscription, region, and current Copilot usage limits. Check your account or subscription if unsure.
  • A cloud-saved workbook: Save the file to OneDrive or SharePoint and turn on AutoSave when available. Copilot features and supported file requirements can change, so follow any eligibility message Excel shows.
  • An internet connection: Copilot connects to Microsoft services and is not an offline Excel feature.

Step-by-Step

  1. Open Excel and sign in. Start Excel for Microsoft 365 and check which account is active. In Windows, select File > Account to view the signed-in account and product information. If the displayed account is not the one with Copilot access, sign out and sign in with the correct work, school, or personal account. Your Windows login and your Office account can be different.
  2. Open a workbook from cloud storage. Open a file stored in OneDrive or SharePoint, or save your current workbook there using File > Save As. Select the cloud location and wait for the save to finish. If AutoSave is available, switch it on. A local file that has not been uploaded may not meet Copilot’s requirements, even if you can see the Copilot control in Excel.
  3. Check the Home tab. Select Home in the ribbon and scan for the Copilot button or icon. Depending on your Excel build and window size, it may be grouped with other tools or placed toward the right side of the ribbon. Maximize the Excel window if the ribbon is compressed; narrow windows can hide or rearrange commands.
  4. Look near the upper-right corner. If the button is not obvious on the ribbon, inspect the upper-right area of the Excel window for a Copilot icon or entry point. Microsoft adjusts the interface over time, and the button’s location can vary by update channel and layout. Hover over an unfamiliar icon to see its label or tooltip rather than assuming another assistant button is Copilot.
  5. Select Copilot to open the pane. Choose the Copilot button. Excel should open a side pane where you can enter a request about the workbook, such as asking for a summary, help identifying a trend, or suggestions for a formula. If Excel displays a setup, permission, or eligibility prompt instead, read it; it may identify a missing license, an unsupported file, or a setting that needs attention.
  6. Make the workbook easier to work with. Give your data clear column headings and remove blank rows or columns that split the data into unrelated blocks. Copilot can work with a range or a formatted Excel table, but a clear, consistently arranged dataset makes it easier to identify what you mean. Select a cell in the relevant data before asking a question if the request concerns one particular section.
  7. Try a focused request. In the Copilot pane, ask for one specific result, such as a brief summary of the selected table or an explanation of a pattern in a named column. Avoid including confidential information in a prompt unless your organization’s policies allow it. Review any proposed changes and verify calculations or interpretations against the workbook before using them.
  8. Check other Excel versions if needed. In Excel for the web, open the workbook in a browser, confirm that you are signed in to the right account, and look for Copilot on the Home ribbon or in the upper-right area. On a Mac, open Excel for Microsoft 365 and check the Home tab; the precise placement may differ from Windows. If your organization manages the app, its update schedule and policies can affect when the feature appears.

Common Mistakes

Looking in the wrong account. Copilot access belongs to an account or subscription, not simply to the computer. A personal Microsoft account may be open in Windows while Excel is signed in to a work account, or the reverse. Check File > Account inside Excel instead of relying on the account shown in another Microsoft app.

Expecting it in every Excel edition. Copilot for Excel is not a standard feature of every older or perpetual-license version. Make sure you are using a supported Microsoft 365 app and an account entitled to the feature, rather than reinstalling Excel based only on the word Excel in the product name.

Leaving the workbook only on the computer. A workbook saved only to a local folder may not satisfy the cloud-file requirement. Save a copy to OneDrive or SharePoint, allow it to sync, and check whether AutoSave is enabled. If the file is in a format or state Excel flags as unsupported, follow the message and save a compatible copy where appropriate.

Assuming a missing icon proves there is no license. A hidden or absent button can also result from an outdated app, a restricted organizational setting, a narrow ribbon, or temporary service availability. Check these causes before concluding that your account is ineligible.

Tips

  • Check the account and the file separately. Copilot availability depends both on who is signed in and on whether the open workbook meets the feature’s requirements. Confirm each instead of changing several settings at once.
  • Use descriptive headers. Headers such as Month, Region, and Units Sold provide more context than Column1 or abbreviated labels. If the data represents a continuous list, you can format it as a table using Home > Format as Table. Confirm the selected range and that it includes the header row.
  • Ask narrow questions first. A request about one table, date range, or column is easier to interpret than a vague instruction to analyze the whole workbook. If the first response misses the intended data, clarify which sheet or field you mean.
  • Keep your app current, but follow workplace policy. Updates can change where controls appear and which features are available. On Windows, check File > Account > Update Options > Update Now if your organization permits manual updates. Managed work devices may receive updates on an administrator’s schedule.
  • Verify before accepting changes. Treat generated summaries, formulas, and suggested edits as items to review. Check the result against source data, especially when a workbook has multiple tables, hidden rows, unusual labels, or mixed data types.
  • Protect sensitive workbook content. Follow your employer’s data-handling and AI-use policies before sending a prompt about customer, employee, financial, or confidential information. Copilot availability does not remove your responsibility to use data appropriately.

Troubleshooting

Copilot is missing from the Home tab: First confirm the account in File > Account, then make sure the file is saved in OneDrive or SharePoint. Maximize Excel and reopen the workbook. Check for updates under File > Account > Update Options > Update Now on Windows. On Mac, use Help > Check for Updates if Microsoft AutoUpdate is installed. Restart Excel after updating.

You see Copilot but cannot use it: Select the button and read the message in the pane. It may ask you to sign in, indicate that the account lacks an eligible license, or explain that the workbook is not supported. Work or school users should contact their Microsoft 365 administrator to confirm the license assignment, service availability, and organization policies. Personal users should check the Microsoft account’s subscription and Copilot availability in their region.

The workbook is not recognized or Copilot gives poor results: Confirm that the latest edits have synced and that the relevant data is in a clear range or table with a header row. Remove merged cells or unrelated notes from the middle of the dataset if they make its structure ambiguous. Select a cell in the intended data and restate the request with the relevant sheet, table, or column named. Do not assume the assistant has interpreted every hidden or separated range as intended.

Your organization blocks the feature: If the account and workbook appear eligible but the button remains unavailable, ask your administrator whether Copilot for Excel is enabled for your account and tenant. Do not try to bypass workplace controls or move protected company data into a personal account to gain access.

The button appears inconsistently: Sign out of Office and sign back in only after confirming you know the correct credentials and any required work sign-in method. Check Excel again after restarting. If the issue affects multiple eligible users, consult your administrator or Microsoft service-status information; a service or staged rollout can affect availability temporarily.

Frequently Asked Questions

Where exactly is Copilot in Excel?
In Excel for Microsoft 365, start with the Home tab and look for the Copilot button. Depending on the app version and window layout, it may instead be prominent near the upper-right. Excel for the web and Mac can place it differently.

Is Copilot included with every Microsoft 365 subscription?
No. Eligibility depends on whether you use a personal, work, or school account, the subscription or license assigned to it, your region, and any usage limits or organization policies. Check the account that is signed in to Excel.

Does Copilot in Excel work with a file on my desktop?
Many Copilot experiences require the workbook to be stored in OneDrive or SharePoint, often with AutoSave enabled. Save a cloud copy and follow any eligibility instructions shown in Excel; requirements can vary as features are updated.

Can I use Copilot in Excel for the web or on a Mac?
It may be available in supported Microsoft 365 versions of Excel for the web and Mac when your account and workbook qualify. Look on the Home ribbon or near the upper-right, and remember that the layout and rollout may differ from Windows.

Why do I have Copilot in another Microsoft app but not Excel?
Availability can differ by app, license, update, and workbook requirements. Being able to use Copilot in another app does not guarantee that Excel has the required entitlement or that the current workbook is eligible. Check Excel’s signed-in account and any message shown when you open its Copilot control.

What if my administrator says I have a license but the button is still missing?
Ask the administrator to confirm the license is assigned to the exact account you use in Excel and that the feature is enabled for your organization. Then update or restart Excel, open a cloud-saved workbook, and check again. If it still fails, provide the administrator with the Excel version and the exact message or behavior.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.