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.

Fill Blank Cells in Excel Using Dynamic Array Functions Watch this video on YouTube. Expand your understanding of Excel functions with additional resources from our extensive library of articles.