Probably the easiest way, especially when it comes time to generate the
scores, would be to enter the question in column A, then make it wide enough
to accomodate the longest question (word wrap could help here to keep the
sheet from getting too wide to print). In column B I'd put a data validated
list with the choices you use, such as "strongly disagree", "disagree
somewhat", "neither agree nor disagree", "agree somewhat" and "strongly
agree". Of course you may have more options, but make sure your list shows
them all so that the respondents know what all they have to choose from.

To score later, you'll have to evaluate the entries in column B.


"thobbs" wrote:

I need to create a likert scale in excell that includes data validation
through dropdown selection. How do I do this?