Applies ToExcel 2013
Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Use Flash Fill to fill out data based on an example. Flash Fill typically starts working when it recognizes a pattern in your data, and works best when your data has some consistency.

Flash fill is also available for Excel on Mac as of version 16.13, but it does not automatically trigger. The user needs to manually trigger it.

Use Flash Fill

You have information in Excel that isn’t formatted the way you need it to be, such as this list of names, and going through the entire list manually to correct them is daunting. Here, Flash Fill can help.

  1. Type the first name the way you want it.

  2. Start to type the next name, and Excel provides a preview of the names formatted the way you want.

  3. Press Enter, and Flash Fill fills in the names for you.

Want more?

Fill data automatically in worksheet cells

Split a column of data based on what you type

Change the case of text

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.