To keep your drop-down lists current, use data validation lists that automatically include new items. Set up your list in an Excel table, which is dynamic and expands as you add new data ...

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 ...