Use AutoFill and Flash Fill

AutoFill and Flash Fill

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

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.

Want more?

Fill data automatically in worksheet cells

Split a column of data based on what you type

Change the case of text

Sometimes you need to enter a lot of repetitive information in Excel, such as dates, and it can be really tedious.

If you think there might be an easier, automated way to do this, you'd be right.

Type the first date in the series.

Put the mouse pointer over the bottom right-hand corner of the cell until it's a black plus sign.

Click and hold the left mouse button, and drag the plus sign over the cells you want to fill.

And the series is filled in for you automatically using the AutoFill feature.

Or, say you have information in Excel that isn't formatted the way you need it to be, such as this list of names.

Going through the entire list manually to correct them is daunting.

You'd think there'd be an easier automated way to do this, too, and you'd be right again.

Type the first name the way you want it.

Start to type the next name, and, as if by magic, Excel provides a preview of the names formatted the way you want.

Press Enter, and the names are all filled in for you using the Flash Fill feature, which is new in Excel 2013.

AutoFill and Flash Fill are tremendous time savers, and they can do much more than we have covered in this introduction.

In the next videos, we'll cover them in more detail.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×