Save Custom List

Question

I've created an alphabet custom list for use in a spread sheet.  How can this custom list be saved for use in all spreadsheets?

Answer 1

Have you tried File -> Options -> Advanced -> Edit Custom Lists...?

You can enter a new custom list manually there, or import it from a range in a worksheet, and then that list should be available for all of your new workbooks after that.

HTH,

Eric

Answer 2

In Excel 2010 I can only get the custom list to save in the spreadsheet I've created it in.  When I open a new spreadsheet it does not show up in the "edit custom lists" option.  I have to create it all over again.

Answer 3

I want it to be available in my custom lists like the days of the week, months of the year, etc. are for all spreadsheets.  I don't want to have to re-create it every time I want to use it.

Answer 4

I've created an alphabet custom list for use in a spread sheet.  How can this custom list be saved for use in all spreadsheets?

In earlier versions you could add the custom list to your Custom Lists under Excel Options>Popular>Create Lists.

Is that feature gone from 2010 version?

Gord

Answer 5

Hi, could you provide more information, do you want to have the list always in column A?, or in a drop down list?, you might consider saving it as a template