--- description: Excel can be very powerful if manipulating it intelligently.Today we launch the method of creating multiple choice questions in cells. title: How to Create Multiple Choice Questions in an Excel Form image: https://www.datanumen.com/blogs/wp-content/uploads/2016/07/task-for-students.jpg --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) > How to Create Multiple Choice Questions in an Excel Form # How to Create Multiple Choice Questions in an Excel Form [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Share Now: - - - - - - - - *Excel can be very powerful if manipulating it intelligently. Not only can it be used to store and analyze data, but also Excel has many other usages. Therefore, today we launch the method of creating multiple choice questions in cells.* You may possibly have received questionnaire in the form of Excel. And this is another application of Excel. The format of Excel allows the interface to be much clearer. What’s more, it is easy for people to collect the results. In some cells, there are some common options that you can choose. With this setting, you don’t need to input the information manually. Hence today we will explore the function of creating multiple choice questions in Excel cells. ## An Example of Choosing Tasks Here we use an example of giving students tasks: watering plants, mowing grass and mopping the floor. You need to ask your students which projects they want to do. And you send them the Excel files to fill in. In the task column, click the small arrow on the right and they can choose any one in the list.![Task for Students](https://www.datanumen.com/blogs/wp-content/uploads/2016/07/task-for-students.jpg "Task for Students") ## Steps of Setting Multiple Choices 1. Selected the target cell where you want to create a list. 2. In the data ribbon, click “Data Validation”. And then a new window will pop up.![Click Data Validation](https://www.datanumen.com/blogs/wp-content/uploads/2016/07/clikck-data-validation.jpg "Click Data Validation") 3. And then in the new window, click the small arrow on the right of the “Allow” text box. 4. In the drop down list, choose the option of “List”.![Choose the Option List](<> "Choose the Option List") 5. After that, in the text box of “source”, input the three tasks. And you should remember to use comma to separate them.![Input the Three Tasks](<> "Input the Three Tasks") 6. Click “OK”. And then you can see that all the three tasks are in the drop down menu.![The Tasks in the Menu](<> "The Tasks in the Menu") The above are the steps of creating multiple choice questions in an Excel cell. And the steps are very easy so this purpose is very easy to achieve. After all the settings, you can send it to your students. ## Method to Take When Excel Corruption Happens It is never easy to predict when an Excel file will corrupt. Therefore, once such accident happens, it will cause great trouble to your work. What’s worse, the data disaster will bring you great loss if handling improperly. So you will certainly want to repair your files in a right way and as soon as possible. Hence we suggest that you can use the third party software to [fix Excel](https://www.datanumen.com/excel-repair/). This tool is very effective and can retrieve the lost data to the maximum extent. ## Author Introduction: Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [word recovery](https://www.datanumen.com/word-repair/) and outlook repair software products. For more information visit [www.datanumen.com](https://www.datanumen.com/) Share Now: - - - - - - - - [← Previous post](https://www.datanumen.com/blogs/create-desktop-shortcut-specific-outlook-folder/) [Next post →](https://www.datanumen.com/blogs/4-quick-steps-adjust-font-settings-preview-outlook-messages/) Comments are closed. ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.datanumen.com\/blogs\/create-multiple-choice-questions-excel-form\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/create-multiple-choice-questions-excel-form\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Create Multiple Choice Questions in an Excel Form","datePublished":"2016-07-05T02:01:13+00:00","dateModified":"2025-10-03T09:33:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/create-multiple-choice-questions-excel-form\/"},"wordCount":461,"commentCount":0,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/create-multiple-choice-questions-excel-form\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/07\/task-for-students.jpg","articleSection":["Excel Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/create-multiple-choice-questions-excel-form\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/create-multiple-choice-questions-excel-form\/","url":"https:\/\/www.datanumen.com\/blogs\/create-multiple-choice-questions-excel-form\/","name":"How to Create Multiple Choice Questions in an Excel Form","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/create-multiple-choice-questions-excel-form\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/create-multiple-choice-questions-excel-form\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/07\/task-for-students.jpg","datePublished":"2016-07-05T02:01:13+00:00","dateModified":"2025-10-03T09:33:24+00:00","description":"Excel can be very powerful if manipulating it intelligently.Today we launch the method of creating multiple choice questions in cells.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/create-multiple-choice-questions-excel-form\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/create-multiple-choice-questions-excel-form\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/07\/task-for-students.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/07\/task-for-students.jpg","width":293,"height":100,"caption":"Task for Students"},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]},{"@type":"Person","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957","name":"AuthorCCW","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","caption":"AuthorCCW"},"sameAs":["https:\/\/www.datanumen.com\/"]}]} ```