In this tutorial, I’ll show you how to populate a dropdown with data on another sheet. I’m using Microsoft 365 desktop on a Windows 10 64-bit system, but you can use older .xlsx versions.

On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders. That means you can add COPILOT to a formula and then use natural language in a ...