How to enable new Copilot on Microsoft Excel

Microsoft Excel users can enable an early preview of the new Copilot, the new AI chatbot is designed for Office apps and other products from Microsoft. It appears in the sidebar of Office apps, which will work much like an assistant to help users generate content for documents, emails, presentations, and more.

In Exel, Copilot will assist users to make more sense of the information by analyzing and exploring the data in the spreadsheet. Users can ask virtually anything using natural language. The chatbot is also smart enough to suggest formulas based on queries, predict “what if” scenarios, and find data correlations. In addition, based on data users can instantly create a SWOT (strengths, weaknesses, opportunities, and threats) analysis or a Pivot Table.

As of now, it is unclear when Copilot will arrive to everyone, however, you can enable an early preview of the feature through the Registry. In this guide, we will show you how to enable the new Copilot on Microsoft Excel.

How to enable new Copilot on Microsoft Excel_featured

Here is how to enable the new Copilot on Microsoft Excel

Since this is an early preview of Copilot, so the feature may or may not work correctly.

  1. Open Start > search for Registry Editor > click the Open button.How to enable new Copilot on Microsoft Excel_1
  2. Navigate to the following path:
    Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\ExperimentConfigs\ExternalFeatureOverrides\excel

    How to enable new Copilot on Microsoft Excel_2

  3. Right-click the Excel key, select the New menu, and select the String Value option.How to enable new Copilot on Microsoft Excel_3
  4. Name the key: Microsoft.Office.Excel.Copilot > press Enter on the keyboard.How to enable new Copilot on Microsoft Excel_4
  5. Double-click the newly created key > set its value to true to enable Copilot > click the OK button.How to enable new Copilot on Microsoft Excel_5
  6. Restart the computer.
  7. When done, launch or re-open Microsoft Excel, and the Copilot experience should appear on the right side.

Read more:

About the Author

I'm a passionate tech enthusiast here to break down the latest trends, gadgets, and software. Whether you're a seasoned programmer or just curious about the digital world, I aim to deliver insightful articles that are both informative and engaging.