Microsoft Office Tutorials and References
In Depth Information
Entering data by using Flash Fill
Entering data by using Flash Fill
Your worksheet might contain a list of names where the first
name, middle initial, and last name all appear in the same cell.
If you need to separate the first name, middle initial, and last
name into separate cells, you can do so using Flash Fill, which is
new in Excel 2013.
Hassall. If you want to store the person’s first name in one cell
and last name in another, you would type Mark in the first cell
and hassall in the second. You then repeat the process for the
second row of the list, at which point Flash Fill recognizes the
data pattern and offers to fill in the remaining values.
To use Flash Fill, click a cell to the right of the list that contains
the data you want to work with and then type the correct value
for that cell. For example, your list might contain the name Mark
If your data set contains rows with additional data, such as a
middle initial, you can correct the first example of that differing
pattern to update similar rows in the new columns.
Combine data by using Flash Fill
1 Click the cell to the right of the first row you want to work with.
2 Type the combined value for the row’s data in the active cell, and
press Enter.
3 In the cell directly below the first, start typing the combined value
for the row.
4 Press Enter to accept the suggested Flash Fill values for the
remaining rows.
5 If necessary, click a cell to the right of a row that contains data with
a different pattern.
6 Type the combined value for that row’s data in the active cell, and
press Enter.
1
2
3
4
5
TIP Start Flash Fill by typing a target value for a row that
contains the simplest data pattern, such as a row with just a first
and last name. Then you can create a pattern for more complex rows,
such as those that also have a middle initial.
6
Search JabSto ::




Custom Search