Microsoft Office Tutorials and References
In Depth Information
Coaching Flash Fill with a Second Example
Figure 2.6. When Excel isn ’ t sure, it leaves the cell blank.
When Excel isn ’ t sure, it leaves the cell blank.
At this point, Excel is hoping you will provide a second example. Go to cell
C5, type Cher
Cher, and press Enter. Excel now understands the rule for people
without a last name. Excel fills in Sting in C10 and Pele in C15, as shown in
two cells are automatically selected. You could change the font color to
red and then sort or filter by color to inspect those changed cells.