In Excel, built in lists of day-of-the-week and month-of-the-year are provided however you can also change and create your own custom lists. In this article, we will learn stepwise that how to add and delete custom lists.
Example of pre-built custom lists in Excel
1- Write ‘Jan’ into C2 cell.
How to add custom lists?
1- Click on the File tab, and then click on the Options button.
2- A window will open, click on the advanced option then go to General and click Edit Custom Lists.
5- Now type the word ‘Ali’ in a cell.
Does my custom link open on another computer or server?
When you create a new custom list, it saves in your computer’s registry and this custom list will also available in a new worksheet. However, if you open the worksheet in which you have added a custom list to another computer or server, the custom list will not immediately available for the Fill command. For this, you will need to add the same list in the registry of that computer or server.