The final way to make a drop down list in your Excel spreadsheet does not require a list on any worksheet. Just click on the cell where you want the drop down list. Once again, go to the Data Validation dialog box and choose List. Now type the options for your list directly into the Source box, separating each one with a comma. When you are finished, click OK.
The last method allows you a bit more control. When you create a list on your spreadsheet for the Data Validation tool to refer to, users can type a word into the cell as long as it is in the list. When you create the list directly in the Data Validation box, users can still type in a word, rather than using the drop down button, but the list will be case sensitive.
One other point to remember is that users will not know there is a drop down list ahead of time. The drop down button won’t appear until they click on that cell.
For more tips and tricks, take a look at the other items in Bright Hub’s collection of Microsoft Excel user guides and tutorials. Find out how to use the various lookup and reference functions, learn about constructing charts and graphs, read up on saving Excel objects as images, and more. Additional items are being added on a regular basis, so be sure to check back often.