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 Share this:TwitterFacebookLike this:Like Loading... Related Post navigation Key Shortcut to navigate from one Sheet to Another Sheet in Excel Enable Fill Handle in Microsoft Excel