Flash Fill

Microsoft Excel cover image for the flash fill function

What does Flash Fill do? Flash Fill adds a level of intelligence in recognising a pattern and completing it based upon nearby data. In some instances, it makes functions like concatenating, left/insert and extract redundant, in a flash!