Training Tips

Training Tips icon
Flash Fill - Microsoft Excel 2016

Let Flash Fill help you enter data faster and more accurate. It predicts the rest of the data based on the first entry posted. Below are different ways you can take advantage of this feature in Excel.

Separate First and Last Name

If you have a list of names in one column, Flash Fill allows you to quickly separate the names in different columns. In the example below, I want first and last name to be in their own columns.

  1. Create first and last columns to the right of Names (See picture below)
  2. Enter the first names. As soon as you start typing the second "First" name, Flash Fill will preview a list, predicting how you want to fill the column

    Flash Fill Predicting

  3. Just hit the Enter key to complete the rest of the column

    Flash Fill Completed

 

Fill a Formula to Adjacent Cells

Flash Fill can also copy formulas by dragging the Fill Handle (bottom right) 

  1. Enter the formula and hit Enter
  2. Click on the formula to select the cell
  3. Point at the Fill Handle (bottom right) until the pointer changes to a black plus sign

    Fill Handle

  4. Click & hold and drag the Fill Handle across the cells you want to fill

Quickly Enter Months of the Year or Days of the Week

  1. Enter the month or day
  2. Click on the month or day
  3. Click & hold on the Fill Handle  
  4. Drag the Fill Handle across the cells you want to fill