Flash Fill Option In Excel 2010. Start typing the next full name in cell c3. Flash fill example 3.
Select the example cells right click and drag the fill handle down release the right click choose flash fill from the resulting menu. The flash fill feature is a new option in excel 2013 and is not available in excel 2010. Using flash fill in excel.
Start typing the next full name in cell c3.
On the data tab in the data tools group click flash fill or press ctrl e. First type both the name in the single column and by holding on ctrl key press e i e. Enable flash fill in excel click file options. Excel offers many tools for you to organize your data the flash fill option will help you format your data quickly.
