| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down boxes/tick boxes
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down boxes/tick boxes
Its best when we can see your workbook for your structure and sample questions, we will then be able to add some items to it to give you some options. feel free to join our forums where you can upload a workbook using manage attachments at the bottom of your new pots window. -- The Code Cage Team Regards, The Code Cage Team www.thecodecage.com ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=7987 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down boxes/tick boxes
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. Jane wrote: 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? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tick boxes in excel | Excel Discussion (Misc queries) | |||
| how do I insert tick boxes in excel | Excel Discussion (Misc queries) | |||
| How can I add tick boxes to my Excel spreadsheet? | Excel Discussion (Misc queries) | |||
| Tick Boxes | Excel Worksheet Functions | |||
| Copying Tick Boxes | Excel Worksheet Functions | |||
Linear Mode
