Welcome to Excel

Fill data automatically

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

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

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

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.