Create a custom list by typing in values Click the Microsoft Office Button , and then click Excel Options. Click the Popular category, and then under Top options for working with Excel, click Edit Custom Lists. In the Custom Lists box, click NEW LIST, and then type the entries in the List entries box, beginning with the first entry. Press ENTER after each entry.
When the list is complete, click Add. The items in the list that you selected are added to the Custom lists box. Click OK twice. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel