You have seen online application forms where the Country Names are selected from a drop-down box. Or to select the Name of an Employee, or Cost Center Codes, or Departments etc.?
1. It makes it easy for the user to select a value, rather than type it.
2. It makes the data consistent. No garbage values come in. The user can only select from the list of values provided.
Well, it is extremely easy to make a drop down list like this in Microsoft Excel. Here’s how you do it, step by step. And this will work in any version of Excel – Excel 2003 , Excel 2007, Excel 2010 and Excel 2013.
1. First of all, make a list of all the country names you want to display in your drop down list.
2. Select all the country names, and then go to Formula tab > Name Manager, and click New button.
3. Type a name like countries for the range. You must make sure you write it as one word. Range names can not have blanks, spaces or special characters, except for the Underscore.
6. Key in the Source as =countries. This must be the name of the range you just created in Step 3. Now click OK to close this dialog box.
7. Once this is done, you will see a drop down arrow showing up in the cell C1. You will see the list of countries showing up here.
You could have your master list of countries on another sheet in the same workbook, or in the same worksheet. If you do not want your users to see the individual names, you could hide the sheet and even protect it from any changes. But these things will be covered in a separate lesson.
Hope this helps. Do post a comment if you enjoy this little tip!
Are you facing any problem in using Excel? Any Question?
You have come to the right place. Tell us your needs. We’ll be glad to help you!