Detroit Lakes, Minnesota, USA |

Excel 2007: How to Create a Custom Fill Series

August 14th, 2008 | by Loren |

If you frequently have to type in a list of names, cities, locations, anything really, you can save that list and use the fill option to quickly generate the list. You do have to type in one of the names in the list to start the fill action.

  1. Click the Office button, then Excel Options.
  2. Click the Popular category in the left pane, then in the Top options for working with Excel section click Edit Custom Lists.
  3. At this point, you can either import a previously typed up list from the workbook you’re in or manually type in a new list.
    • To import a list, click the little red identify range button and select the range to import. (You could also highlight the list before opening the Office button, then the list range would automatically show up.) Verify the range is correct, then click the click the Import button to finish.



    • If typing in a list, be sure to push Enter after each item. Click Add to finish.



  4. Click OK, then OK again to finish.


Popularity: 4% [?]

You might also want to look at:

`

  1. 2 Responses to “Excel 2007: How to Create a Custom Fill Series”

  2. By Georg on Dec 6, 2009 | Reply

    Hi is there a way to create custom lists with formula?
    e.g.
    =”JAN” & TEXT (YEAR(NOW()))
    =”FEB” & TEXT (YEAR(NOW()))
    =”MAR” & TEXT (YEAR(NOW()))
    …
    =”DEC” & TEXT (YEAR(NOW()))
    =”JAN” & TEXT (YEAR(NOW())+1)
    and so on..

  3. By Mohsin Rasool on Jun 20, 2009 | Reply

    Hi Loren,

    Thank you very much for this post. I knew it in Office 2003, but here in 2007 office, i was not sure where was this option of custom fill series.

    Mohsin

You must be logged in to post a comment.

`