Create a likert scale in excel

[thobbs]

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

 

[JLatham]

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.

 

[Mike Middleton]

thobbs -

Before you try to do this using Excel, if you are using a Likert scale for
survey responses, I suggest a more appropriate tool like the online Survey
Monkey or similar questionnaire software. If you don't like the format of
the Survey Monkey results, you can always download the data and use Excel
for analysis and charts.

- Mike
http://www.MikeMiddleton.com


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