Microsoft notes that you can combine its new AI function with other Excel functions, including IF, SWITCH, LAMBDA, or ...

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

Microsoft Excel is integrating Copilot, allowing users to manipulate spreadsheet data using natural language commands.