Step 1 : Navigate to Excel Options -> Click on Advanced 

Step 2 : Navigate to General Section -> Click to Edit Custom Lists
 Step 3 : Custom Lists Dialog Box opens with existing Custom lists

Step 4 : Enter Custom list values in List Entries text and Click on Add and Ok to add new Custom List


Step 5 : You can also add Custom List by Importing values from excel cell values


Leave a Reply

%d bloggers like this: