Microsoft Office Tutorials and References
In Depth Information
Learning some handy data-entry techniques
FIGURE 13.9
Using manually entered examples in B1 and B2, Excel makes some incorrect guesses.
As you see, Excel identifi 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
Figure 13.10).
13
FIGURE 13.10
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 fi rst 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.
Search JabSto ::




Custom Search