Flash Fill Option In Excel 2010. For example use flash fill in excel to reformat the numbers in column a below. Flash fill example 3.
Flash fill is a great excel tool. Start typing the next full name in cell c3. Excel offers many tools for you to organize your data the flash fill option will help you format your data quickly.
To accept the preview press enter.
Let s see how it did in our case. Enter the full name in cell c2 and press enter. Select the example cells right click and drag the fill handle down release the right click choose flash fill from the resulting menu. Flash fill is a great excel tool.
