Using Flash Fill - Exercise

Contact Us or call 1-877-932-8228
Using Flash Fill - Exercise

Using Flash Fill

Duration: 05 to 10 minutes.

In this exercise, you will use the new Flash Fill feature.

  1. Open a new, blank worksheet in Excel.
  2. In column A, enter the following:
    1. Angela Ang
    2. Bobbi Born
    3. Chris Carter
    4. Doris Day
    5. Edward Everly
  3. Use Flash Fill to enter just the first names in column B.


  1. In a new, blank document, enter the data in column A. Flash Fill
  2. Click in cell B1, and type "Angela" and press Enter. Flash Fill
  3. Click in cell B2, and as you begin to type "Bobbi", Flash Fill fills in rest of the first names. Flash Fill
  4. To accept the rest of the data, press Enter. Flash Fill
  5. Close the worksheet without saving your changes.