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.

If you prefer using Microsoft Excel keyboard shortcuts, press Ctrl+E. When you run Flash Fill, Excel looks for patterns in the data, and tries to apply them to the remaining data in the range.