Microsoft Office Tutorials and References
In Depth Information
Using Filter to Flash Fill a Subset of Records
44. In the Custom AutoFilter dialog, choose Movie List Begins With. Type
The
The and click OK (see Figure 2.16 ) .
Figure 2.16.
Figure 2.16. Filter to just the records that start with The.
Filter to just the records that start with The.
At this point, you see the headings in row 1 and then movie titles from rows
12 15. If you select cell B12, type Full
The, and press Enter, then
Flash Fill fixes the remaining three records (see Figure 2.17 ). The status bar
indicates 4 of 15 Records Found. Flash Fill Changed Cells: 3.
Full Monty,
Monty, The,
Figure 2.17.
Figure 2.17. Flash Fill only works on the visible rows if you ve applied
Flash Fill only works on the visible rows if you ve applied
a filter.
a filter.
You can now turn off the filter by clicking the Filter icon in the Data tab.
You can now see all the movie information.
Search JabSto ::




Custom Search