RE: custom lists

Dear Fiona

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.

I am assuming this query relates to Excel 2007. It was a bit too technical in 2003 version. Normally the Custom Lists are stored in the registry of the computer.

In Excel 2007 it is a bit tricky but not as complicated as in 2003 version!

Please follow these steps:

1. I hope you know how to create custom lists. Click on the Office Button and then choose Excel options button.

2. In the popular section Choose Edit Custom Lists...

3. Either type your new custom lists in the list entries by pressing enter after each entry or use the Import list from cells box to choose the entries and select the cells and then press the Import button.

4. Press OK to close the Custom list dialog box. Click OK to close the Excel Options dialog box.

5. Choose any data in your table and on the Ribbon click on data tab and under the Sort and filter group click on the Sort Button.

6. In the Sort Dialog box click on the drop down arrow for Order and choose Custom List...

7. Choose the custom list that you added in Step 3. Press Add. Then Press OK.

8. You will be able to see the custom list in the Order box. Press OK button.

9. Save the file with some appropriate name and close it. (Please remember to save the files as 2007 version and not earlier otherwise you'll get a compatibility error which will say that the data will be lost).

10. Open the same file in another computer

11. Choose the same cells that you selected in step 5. And then choose Data tab on the ribbon and then press the Sort button.

12. You should be able to see the custom list that you added in another computer. Click on the Dropdown arrow of the order column and then choose Custom List...

13. Choose your custom list and then press Add button to ensure that it gets copied on the registry of that computer.

Next time when you use the custom list it will be available in this computer.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007