This is a great tip especially for those who are having a blog contest. By the way my $200 blog contest ends this March 15 so join now. Since my contest is by points system, I tally the score using the help of Microsoft Excel. To make my life easier in typing the words I usually use, I created a drop down list for a certain column.

Here is the sample worksheet of my tally sheet:


Column F by the way has the drop down list that I am discussing. To create that drop down list in Excel, you need first to define a name. At the Insert menu, select Name then the Define selection. Label your desired name then followed by placing the range of the selection you want to appear in the drop down list. In the given example, my range is E2 to E17 of “PT Value” worksheet. Click the Add button afterwards.


After we have defined the name, we need to add the validation in the cells. In this case, highlight the entire column F. Go to the Data menu followed by selecting Validation. At the settings tab, select List from the Allow drop down list. At the source text box, type the name of the defined name earlier. Make sure to type an equal sign before the name.


Voila, you should be able to see the drop down list that you have created.

If you like this post, buy me a cup of coffee.

• 16 comments »