It’s the question everyone is asking – can you use Copilot in Excel? Yes… but there are limits. Lifewire explains:

If you can launch Copilot in Excel, but find that it won’t let you input any requests, it may be because you haven’t selected any data for it to work with. Unlike Copilot in other Microsoft 365 applications, like Word and Powerpoint, Copilot in Excel is designed to only work with data, rather than the entire document. You’ll need to select the cells you want it to work with before inputting your request.

You’ll know whether this is the case, because Copilot will warn you that it only works in an Excel Table.

Excel is the weakest area of Copilot Pro – where it should be the strongest.

Read their helpful guide here.