Microsoft Office Tutorials and References
In Depth Information
Figure 16-10: Using manually entered examples in B1 and B2, Excel makes some incorrect guesses.
Figure 16-11: After entering an example of a decimal number, Excel gets them all correct.
This simple example demonstrates two important points:
• You must examine your data very carefully after using Flash Fill. Just because the first few rows are correct,
you can't assume that Flash Fill worked correctly for all rows.
• Flash Fill increases accuracy when you provide more examples.