Table of contents
Welcome to Excel
Welcome to Excel

Fill data automatically

Your browser does not support video.

Try it!

Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells. Watch this video from community expert Mike Girvin to learn how.

  1. Select the cell or cells you want to use as a basis for filling additional cells.

    Note: If you want a series like 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8..., type 2 and 4. If you want the series 2, 2, 2, 2..., you can leave the second cell blank.

  2. Drag the fill handle Fill handle.

  3. If needed, click Auto Fill Options Button image, and choose the option you want.

Want more?

Fill data automatically in worksheet cells

See more from Mike Girvin on YouTube at excelisfun

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!