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: