Now, you can try Copilot if you join the Microsoft Insider program. How to enable Copilot in Excel and how to use it? This post from MiniTool Partition Wizard will offer the guide.

Is Microsoft Copilot 365 Available to You?

In 2023, Microsoft introduced Microsoft 365 Copilot, designed for Microsoft 365 applications and services. This chatbot can simplify many tasks. In Excel, it allows you to ask anything using natural language, get suggestions for formulas for your queries, predictions for “what if “scenarios, create a SWOT analysis, and more.

Do you want to use Copilot in Excel? If so, you need to enable it first. How to enable Copilot in Excel? The premise is that you are using the 16.0.16401.20000 or higher version of the Excel app. But, if you are not, then you will have to register your Office installation in the Insider program. For this, you would need to subscribe to Microsoft 365 Family or Personal.

Tips:
Copilot for Microsoft 365 for consumers and for businesses are still in the early testing with a small group of consumers. However, Copilot for Microsoft 365 for enterprise is currently available for purchase to organizations that have a Microsoft 365 E3 or E5 license and with 300 or more employees.

To join the Microsoft 365 Insider program, launch Microsoft Excel > File > Account > Office Insider > Join Office Insider > Beta Channel > OK. Then, restart Excel and go to Account again. You need to check for updates and make sure it’s updated to the latest preview version.

Also Read:How to Use Copilot in Windows 11?

How to Enable Copilot in Excel

To enable Copilot in Excel, you can refer to the following steps:

  1. Press the Windows logo key + R to open the Run box.
  2. In the Run box, type “regedit” and press Enter to open Registry Editor.
  3. Go to Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\ExperimentConfigs\ExternalFeatureOverrides\excel.
  4. Right-click the excel entry and click New > String Value.
  5. Rename the new String Value as Microsoft.Office.Excel.Copilot.
  6. Double-click on this string value and set the value as true.
  7. Press OK to save the changes. Then, exit the Registry Editor and restart your PC to make changes take effect.
edit registry
Copilot Is Not Available on Windows 11 23H2 Update? [Fixed]
Copilot Is Not Available on Windows 11 23H2 Update? [Fixed]

Have you come across the Copilot not available on Windows 11 23H2 issue? This post provides several effective ways to fix Copilot not available on 23H2.

Read More

How to Use Copilot in Excel

Now that Copilot for Excel has been enabled, the Copilot button should appear on the upper right side of your Excel. How to use Copilot in Excel? You can refer to the following guide.

  1. Launch Excel and create a new workbook or open the current one you have been working on.
  2. Under the Home tab, press the Copilot button in the upper right corner. A sidebar will open on the right side of the screen.
  3. Type your question or request there. Microsoft Copilot will give you the answer or result within a few seconds. In addition, it can also help you generate visuals quickly to present your results.
use Copilot in Excel

Undoubtedly, Copilot is very useful in Excel. It can make your daily financial tasks like budgeting, forecasting, etc., more efficient.

Use Copilot to Make Your PowerPoint Presentation Better
Use Copilot to Make Your PowerPoint Presentation Better

This post shows you how to get Microsoft Copilot for Microsoft 365 and then enable and use it in PowerPoint.

Read More

Bottom Line

Do you have other suggestions about using Copilot in Excel? Please share them with us in the following comment zone. In addition, MiniTool Partition is a multifunctional tool that can format USB drives and hard drives, clone disks, recover lost data and partitions, convert the system disk from MBR to GPT without data loss, etc. It’s worth trying.

MiniTool Partition Wizard DemoClick to Download100%Clean & Safe

  • linkedin
  • reddit

About The Author

Linda
Linda

Position: Columnist

Linda has been working as an editor at MiniTool for 5 years. She is always curious about computer knowledge and learns it crazily. Her articles are simple and easy to understand. Even people who do not understand computer can gain something. By the way, her special focuses are disk management, data recovery and PDF editing.