Drop down boxes/tick boxes

  • Thread starter Thread starter Jane
  • Start date Start date
J

Jane

I have received paper questionaires and now I want to enter them into an
excel spreadsheet. Some of the questions say rate the following 5 case
studies on a scales of 1-10. If I entered each of the 5 into seperate columns
then it would take up alot of space. Is there a way I can condense it down.
Also I have questions which say put these in the correct order from 1-6. is
there any way I can condense these down. I am able to do drop down boxs for
other questions but some questions have more than one answer from the drop
down box, how can I allow this to be done?
 
Instead of one row for questions with 5 case studies, use 5 rows. For
example:

Question Response
Question 6a 7
Question 6b 4

Do the same thing for questions that put items in the correct order,
using 6 rows if there are 6 items to put in order.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down with dynamic named range offsheet source list 14
customize drop-down box 1
Odd Drop Down Box Behavior 4
drop down box code 2
Protecting Sheets with drop down boxes 1
Drop down box issue 2
How do I create a drop down box within a drop down box? 1
Dependent drop down dynamic range formula, off sheet. 7

Back
Top