Microsoft Office Tutorials and References
In Depth Information
Coaching Flash Fill with a Second Example
Figure 2.5. Excel understands the pattern and fills in many cells.
Excel understands the pattern and fills in many cells.
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-