Related topics
Use AutoFill and Flash Fill
Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Use AutoFill and Flash Fill


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

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

Use AutoFill

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

  1. Type the first date in the series.

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

  3. Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And Excel fills in the series for you automatically using the AutoFill feature.

Want more?

Fill data automatically in worksheet cells

Split a column of data based on what you type

Change the case of text

In the previous video, you saw how AutoFill automatically fills a series down a column of adjacent cells, like this.

But it can also go up a column, to the right and the left in a row.

When I move the cursor over what's called the Fill Handle and it turns into a black plus sign, this time I hold down the right mouse button while I drag.

When I let go of the mouse button, I am presented with a list of options.

Copy Cells is pretty straight forward.

AutoFill copies what's in the A2 cell to the adjacent cells I selected.

It even works with cells containing formulas.

We just copied the data from a single cell, but you can also copy multiple cells, like this.

Fill Series populates the adjacent cells with data that follows a pattern in the copied cells.

And, as expected, the formulas update automatically.

You can also fill a series with time, like this.

You can even change the results of fill series by giving Excel more data to base the series on.

In this example, I'm creating a series that's every half hour.

AutoFill has many options when creating a series based on calendar data.

With dates, you can Fill Days, Weeks, Months, and Years.

When you're working with days of the week, you can fill in all seven days or just weekdays. You can even create a series for quarters based on dates and based on abbreviations.

And you can create a series of years.

In the next video, we'll cover Flash Fill in detail.

Need more help?

Want more options?

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

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!