Excel – use Flash Fill to automatically fill data when it senses a pattern.

Excel – use Flash Fill to automatically fill data when it senses a pattern.

Sometimes you need to enter a lot of repetitive information in Excel, such as dates, and it can be really tedious. But the AutoFill feature can help. Or say you have information in Excel that isn’t formatted the way you need it to be and going through the entire list manually to correct it is daunting. In this case, Flash Fill (a new feature in Excel 2013) can do the work for you. Flash Fill is on by default and automatically fills your data when it senses a pattern.


Excel – Flash Fill YouTube Video

Here is the Microsoft support article for flash fill.

Skills

Posted on

November 1, 2016

Submit a Comment

Your email address will not be published. Required fields are marked *

Pin It on Pinterest