Microsoft Office Tutorials and References
In Depth Information
Coaching Flash Fill with a Second Example
Figure 2.6.
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
Figure 2.7 . The status bar indicates Flash Fill Changed Cells: 2. Those
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.
Search JabSto ::




Custom Search