Excel for doyourpartparks.org 365 Excel 2021 Excel 2021 because that Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 because that Mac Excel 2013 More...Less

Flash Fill automatically fills her data once it senses a pattern. For example, you can use Flash fill to separate an initial and last names native a solitary column, or combine first and last names from two different columns.

You are watching: Which of the following excel features recognizes a pattern in the data of a worksheet?

Let"s say tower A contains very first names, column B has actually last names, and also you want to fill shaft C with first and last names combined. If you establish a pattern by keying the full name in obelisk C, Excel"s flash Fill attribute will to fill in the remainder for you based upon the pattern you provide.

Enter the full name in cabinet C2, and press ENTER.

Start keying the next full name in cell C3. Excel will feeling the pattern you provide, and also show friend a preview the the remainder of the obelisk filled in through your an unified text.

To accept the preview, push ENTER.


If Flash to fill doesn"t generate the preview, it could not it is in turned on. You deserve to go to Data > Flash Fill to operation it manually, or push Ctrl+E. To rotate Flash fill on, walk to Tools > Options > Advanced > modifying Options > inspect the Automatically speed Fill box.

Let"s say shaft A contains an initial names, shaft B has last names, and also you want to fill shaft C with an initial and critical names combined. If you create a pattern by typing the complete name in tower C, Excel"s flash Fill feature will fill in the rest for you based upon the pattern you provide.

Enter the full name in cell C2, and also press ENTER.

walk to Data > Flash Fill, or press Ctrl+E.

Excel will feeling the pattern you detailed in C2, and also fill the cells below.

See more: Structured Programming Vs Object Oriented Programming, A Comparative Analysis Of Structured And Object

Need much more help?

You can constantly ask an skilled in the Excel technology Community or gain doyourpartparks.org in the answers community.

See Also

cultivate video: AutoFill and also FlashFill

integrate text from two or much more cells into one cabinet


Need much more help?

Expand your skills
Explore Training
Get new features first
Join doyourpartparks.org Insiders

A subscription to make the most of your time
Try one month free

Was this information helpful?

Thank you! Any much more feedback? (The an ext you tell us the much more we have the right to help.) have the right to you assist us improve? (The an ext you tell us the an ext we have the right to help.)

What impacted your experience?

Resolved mine issue
Clear instructions
Easy to follow
No jargon
Pictures helped
Didn't complement my screen
Incorrect instructions
Too technical
Not enough information
Not sufficient pictures

Any additional feedback? (Optional)

Submit feedback

Thank girlfriend for your feedback!

What's new
doyourpartparks.org Store
English (United States) © doyourpartparks.org 2021