Microsoft Office Tutorials and References
In Depth Information
Coaching Flash Fill with a Second Example
Figure 2.5.
Figure 2.5. Excel understands the pattern and fills in many cells.
Excel understands the pattern and fills in many cells.
Type Mike
Mike HH. in C2, and then type J in C3. Excel sees that you are doing first
name, last initial, and a period. The preview shows many names being filled in,
as shown in Figure 2.5 .
However, the status bar indicates Flash Fill Blank Cells: 3 Flash Fill
Changed Cells: 18. When there is missing data, such as no last name for Ch-
er, Excel leaves column C blank (see Figure 2.6 ) .
Search JabSto ::




Custom Search