Have Excel complete your lists

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.


It helps you save time and avoid mistakes when you are typing a series of information.


  1. Type the first item in the series — January, for example.

    Type first item in series

  2. Drag the fill handle across the cells that you want to fill.

    Drag fill handle across cells

  3. To change the way that the cells are filled, click Auto Fill Options.

    Click Auto Fill Options

    Tip: To repeat the word January in the cells, click Auto Fill Options > Copy Cells.


  • To have Excel automatically complete other kinds of lists, such as days of the week, start with the name of a day instead of the name of a month.

  • To create your own lists, click Excel > Preferences, and then under Formulas and Lists, click Custom Lists.

See also

Enter a series of numbers, dates, or other items

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

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.