Microsoft Office Tutorials and References
In Depth Information
Coaching Flash Fill with a Second Example
Second, a tiny on-grid Flash Fill drop-down icon appears next to the first
changed cell (see Figure 2.4 ) . Open the drop-down for choices such as Undo
and Accept. You can also choose to select all changed cells or all un-
changed cells. You find out more about unchanged cells in the next section.
Figure 2.4.
Figure 2.4. The drop-down lets you undo or select the changed or unchanged
The drop-down lets you undo or select the changed or unchanged
cells.
cells.
Excel easily recognizes all sorts of patterns. You could fill from Mike ,
Mike H. , or HENDERSON, MIKE . Sometimes, Excel needs a bit more in-
formation. If you start with Mr. Mike Henderson in C2, nothing happens when
you start to type M in C3. You have to type Mr. James Moore in C3. As soon
as you type M in C4, Excel fills the column. However, Excel blindly uses Mr.
for Marilyn, Lori, and Christine.
Coaching Flash Fill with a Second Example
That first Flash Fill example looks cool, right? In the world of imperfect
data, things are not always so clear. In Figure 2.5 , three people have been
replaced by people with a single name. If your data includes Cher, Pele, or
Sting, Excel doesn t know what to do.
Search JabSto ::




Custom Search