How to Open Copilot in Excel: Access and Setup Steps

How-to basics · Updated November 21, 2026

To open Copilot in Excel, open a workbook in an eligible Microsoft 365 version of Excel, then select Copilot on the Home tab. If the button is missing, check that you are signed in to an account with Copilot access and that your organization has enabled it. For many workbook actions, you will also need to save the file to OneDrive or SharePoint with AutoSave turned on.

Copilot opens in a side pane where you can ask questions about workbook data, request summaries, or get help with analysis. The exact options can differ by account, app version, and organization settings, so the steps below include checks for Windows, Mac, and Excel for the web.

What You’ll Need

  • An eligible Microsoft 365 account. Copilot availability depends on your subscription or work/school license, region, and any administrator settings. A Microsoft 365 account by itself does not guarantee that Copilot is included.
  • A current Excel app or browser. On Windows or Mac, use an up-to-date Microsoft 365 version of Excel and sign in. For the web, use Excel through Microsoft365.com or your organization’s Microsoft 365 portal.
  • A workbook you can access. For Copilot to work with workbook data, save the file in OneDrive or SharePoint and make sure AutoSave is enabled when Excel offers it. Some Copilot features require a supported workbook structure.
  • Data that is easy to interpret. Clear column headings and a consistent layout help Copilot understand the information. For a list of records, converting the range into an Excel table is often the most reliable setup.

Step-by-Step

  1. Check which account is signed in. Open Excel and look at the account or profile area, usually at the upper-right of the app window. Confirm that it is the Microsoft account or work/school account that has Copilot access. If you have more than one account, the one signed into Windows or your browser may not be the account Excel is using. Select the profile area to switch accounts if needed.
  2. Start Excel and open a workbook. On Windows, open the Excel desktop app from the Start menu, then choose a recent file or select Open to browse for one. On Mac, open Excel from Applications or the Dock and open the workbook from the start screen or with File > Open. In a browser, go to Microsoft365.com, sign in, open Excel, and choose a workbook from your recent files or OneDrive. Copilot’s availability is tied to the signed-in account and the workbook, not just to the Excel icon.
  3. Save the workbook to OneDrive or SharePoint if needed. If the file is only on your computer, use File > Save As and choose OneDrive or a SharePoint location you can access. Follow any prompt to turn on AutoSave. In Excel for the web, files are generally stored in OneDrive or SharePoint already, but check the file location if you are unsure. Cloud saving helps Excel keep the workbook available to Copilot; do not upload a file to a location you are not authorized to use.
  4. Prepare the data before asking questions. Give each column a clear heading, avoid blank rows or columns inside the dataset, and keep one type of information in each column. If your records form a simple rectangular range, select a cell in the data and choose Insert > Table, confirm whether the table has headers, then select OK. You can also use Home > Format as Table. A table is especially helpful when the workbook contains multiple blocks of information, because it makes the intended dataset clearer.
  5. Open the Home tab. In Excel for Windows, select Home in the ribbon. Look for the Copilot button, commonly shown with the Copilot icon toward the right side of the ribbon. If the Excel window is narrow, the ribbon is simplified, or the app is zoomed in, some commands may be grouped or hidden; maximize the window or expand the ribbon and look again. On Mac, select Home and look for Copilot in the ribbon. In Excel for the web, use the Home tab in the browser version of the ribbon.
  6. Select Copilot to show the pane. Click or tap Copilot. A side pane should open alongside the worksheet with a prompt box or suggested actions. If Excel displays an access, file, or sign-in message instead, follow that message before trying to submit a prompt. The pane may take a moment to load, particularly in a large workbook or on a slow connection.
  7. Ask a specific question or request. Start with a task that names the relevant data and the outcome you want. For example, you could ask, "Summarize the main patterns in the selected sales table," or "Identify which product categories have the largest month-to-month changes." If there are several tables or worksheets, name the sheet or table where possible. Read the response and check it against the worksheet before using it in a report or making changes.
  8. Review the result and continue in the pane. Copilot may provide an explanation, a suggested formula, a chart, or an action you can apply, depending on the feature available to your account. Review any proposed changes before accepting them. If the answer uses the wrong range, clarify which table, date period, or columns to use and ask again. You can close the pane with its close control when you are finished; closing it does not delete the workbook or undo changes already accepted.

If you do not see the button after opening the workbook, do not assume the feature is installed as a separate Excel add-in. Copilot access is normally provided through Microsoft 365 and can be controlled by the account license and administrator policies. Work through the checks in Troubleshooting before reinstalling Office or changing workbook content.

Common Mistakes

  • Looking in the wrong place. Copilot is generally on the Home ribbon, not a separate worksheet tab or the Windows Start menu. The button may be harder to spot if the ribbon is collapsed or the Excel window is narrow.
  • Using an account without access. Being able to open Excel or use other Microsoft 365 features does not necessarily mean that Copilot is available on that account. A personal account and a work account can have different entitlements, even when both are signed in on the same device.
  • Leaving the workbook only on the local device. A file saved only to the desktop or Downloads folder may not meet the requirements for certain Copilot workbook actions. Save a permitted copy to OneDrive or SharePoint and enable AutoSave when prompted.
  • Asking a vague question about a complicated workbook. A request such as "Tell me what is happening" gives little direction when the workbook has several sheets, tables, or date ranges. Identify the data and the question you want answered.
  • Trusting an answer without checking it. Copilot can misread ambiguous headings or produce an interpretation that does not match your intent. Check figures, dates, filters, and any suggested edits in the worksheet before relying on them.
  • Expecting identical controls in every Excel version. The position of the button and available actions can change with updates, platform, license, or administrator policy. A missing feature in one account does not prove that your workbook is damaged.

Tips

  • Use descriptive headers. Headings such as "Order date," "Region," and "Net sales" communicate more than generic labels like "Column 1." Include units or date context where that matters.
  • Make the data range coherent. Keep the header row at the top, avoid merged cells within a dataset, and remove completely blank rows that split related records. If a workbook has separate datasets, make each one a clearly named table rather than combining unrelated information.
  • State the goal and scope in your prompt. Mention the sheet or table, time period, comparison, and output you want. For example, ask for a brief summary of quarterly revenue by region, rather than a general summary of the entire workbook.
  • Ask follow-up questions to refine the response. If the first response is too broad, specify the columns to compare or request a different format, such as a concise explanation or a chart suggestion. Confirm that the follow-up still refers to the intended data.
  • Protect sensitive information. Follow your employer’s data-handling rules and Microsoft 365 organization policies. Do not move confidential workbooks to a personal OneDrive or share them with an account that is not approved for the data.
  • Keep Excel updated. Updates can change the ribbon layout and make new Copilot options available to eligible accounts. On Windows, check File > Account > Update Options; update controls may be managed by your organization. On Mac, use Help > Check for Updates if Microsoft AutoUpdate is available.

Troubleshooting

Copilot is missing from the Home tab: First verify the signed-in account and its Copilot entitlement. Then check with your Microsoft 365 administrator if this is a work or school account; administrators can control access, and license changes may take time to appear. Update Excel, close and reopen it, and check the ribbon again. If you use a managed device, do not install unofficial add-ins or change organizational settings to try to force the button to appear.

The button appears, but selecting it gives an error: Confirm that Excel is online and signed in, then reopen the workbook. Save it to OneDrive or SharePoint if your current copy is local, and turn on AutoSave if prompted. Check that you have permission to edit or access the file and that the service is not experiencing a temporary problem. If only one workbook causes the error, try a permitted copy with a simple, clearly headed table to see whether the original file structure is the issue.

Copilot opens but cannot find the data: Check that the intended data is in the active workbook and that the column headings are in the first row of the range. Convert the range to a table using Insert > Table, then ask a prompt that names the table or worksheet. If the workbook contains several similar datasets, explain which one you mean. Make sure filters or hidden rows are not causing you to misinterpret the result.

Copilot is slow or the pane stays blank: Wait briefly, check your internet connection, and refresh Excel for the web or close and reopen the desktop app. If your organization uses a proxy or restricts connected experiences, ask its support team whether Microsoft 365 Copilot services are allowed. Avoid repeatedly submitting the same request while the first one is still processing.

The steps do not match your screen: Check whether you are using Excel for Windows, Mac, or the web, and whether the account is a personal or organizational one. Ribbon placement and available Copilot features can differ. If the account and app are eligible but the control remains absent, provide your administrator or Microsoft support with your Excel version, platform, account type, and the exact message shown.

Frequently Asked Questions

Do I need to install Copilot as an Excel add-in?
No. For supported Microsoft 365 accounts, Copilot is accessed through Excel’s ribbon. If it is missing, check account licensing, app updates, and administrator settings instead of searching for an unofficial add-in.

Where is the Copilot button in Excel?
In current Microsoft 365 versions, look on the Home tab of the ribbon, usually toward the right. The precise placement can vary by platform and window size, so expand the ribbon if necessary.

Can I use Copilot in Excel for the web?
Yes, if your account and organization have access to the relevant Copilot features. Open Excel through Microsoft365.com or your organization’s Microsoft 365 portal, sign in, open the workbook, and check the Home tab.

Does Copilot work with a workbook saved on my computer?
Some Copilot workbook actions require the file to be saved in OneDrive or SharePoint with AutoSave enabled. If Excel reports that the workbook is unsupported, save an authorized copy to a supported cloud location and try again.

Why can a coworker see Copilot when I cannot?
They may be signed in with a different account, have a different license, use a newer app build, or belong to a group with different administrator settings. Compare those details with your Microsoft 365 administrator rather than relying only on the device or workbook.

Does opening Copilot change my spreadsheet?
Opening the pane alone does not change worksheet data. Some requests can suggest or apply content changes, so review any proposed action and confirm it only when you intend to make that change. Check the workbook afterward to ensure the result is correct.

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.