Microsoft Office Tutorials and References
In Depth Information
Learning some handy data-entry techniques
Using manually entered examples in B1 and B2, Excel makes some incorrect guesses.
As you see, Excel identiﬁ ed most of the values. Accuracy increases if you provide more
examples. For example, provide an example of a decimal number. Delete the suggested
values, enter 3.12 in cell B6, and press Ctrl+E. This time, Excel gets them all correct (see
After you enter 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 ﬁ rst few rows are correct, you can’t assume that Flash Fill worked correctly for
Flash Fill increases accuracy when you provide more examples.