Need a formula for your Excel spreadsheet in a flash? Try ChatGPT. In this guide, we'll show you how to write Excel formulas using ChatGPT.

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.