Use AutoFill and Flash Fill

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

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.

AutoFill and Flash Fill are tremendous time savers, and in this course, we’ll cover them in more detail.

Inside this course:

AutoFill and Flash Fill (1:47)
Watch this video for a quick introduction to AutoFill and Flash Fill, two helpful time savers that we’ll cover in more detail in this course.

AutoFill (3:01)
Instead of entering data manually on a worksheet, you can use the Auto Fill feature to fill cells with data that follows a pattern or that is based on data in other cells.

Flash Fill (3:10)
Use Flash Fill, new in Excel 2013, 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.

Course summary
A brief reminder of the key points in this course.

More courses available at Microsoft Office Training.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!