{"id":5067,"date":"2021-05-08T12:28:50","date_gmt":"2021-05-08T12:28:50","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=5067"},"modified":"2024-01-03T06:59:38","modified_gmt":"2024-01-03T06:59:38","slug":"create-drop-down-list-in-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel","title":{"rendered":"How to Create Drop Down List in Excel (Guide 2023)"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">In MS Excel, a drop-down list is an efficient way that helps the user to select the values or text from a list of various options, instead of entering them manually in the cell. Thus, if you also want to create &amp; take advantage of Excel drop down list, read this post till the end. In this blog, I will show you <strong>how to create drop down list in Excel<\/strong> using different tricks. Also, you will learn<strong> how to add\/remove items from the drop down list<\/strong> or steps to delete the drop-down list.<!--more--><\/p>\n<p>So, let\u2019s get started\u2026<\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To recover Excel file data, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h2 style=\"text-align: justify;\"><strong>What Are Data Validation Lists?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Creating the drop-down list is the best way to keep the data entries in an uniform and error-free structure. You can also restrict the values entry which you don\u2019t want to put on your worksheet. Due to this reason only it is also known as <strong>data validation lists<\/strong>. So, only the valid data will get into the cell after passing the conditions that you have applied to it.<\/p>\n<p style=\"text-align: justify;\">Adding a drop-down list in an Excel sheet is very helpful when several users enter data on the same Excel sheet. Whereas on the hand, you want to assign limited options to the list of values or items that are already approved by you.<\/p>\n<p style=\"text-align: justify;\">Apart from this, one can also use the drop-down list in Excel to create financial models and interactive reports where the result automatically gets changed when the value of a cell is changed.<\/p>\n<p style=\"text-align: justify;\">One of the most useful features of data validation is the ability to create a dropdown list\u00a0that let users select a value from a predefined list.<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/create-flowchart-in-excel\">How to Create a Flowchart in Excel?<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>How to Create Drop Down List in Excel?<\/strong><\/h2>\n<h3 style=\"text-align: left;\"><strong>Method 1- Create Simple Drop-Down List<\/strong><\/h3>\n<p>1. In your new Excel worksheet, you have to type the data you want to show in the drop-down list.<\/p>\n<p style=\"text-align: justify;\">It\u2019s better to have a list of items in the Excel table but if you don\u2019t have such then convert the list to a table by making a selection of the cell ranges and pressing the <strong>Ctrl+T<\/strong> tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5077 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/4018439e-9c1d-4bbd-8618-4301b21d051f.png\" alt=\"Create Drop List In Excel\" width=\"123\" height=\"211\" \/><\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"color: #ff0000;\">Notes<\/span>:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Why should you put your data in a table? When your data is in a table, then as you\u00a0add or remove items from the list, any drop-downs you based on that table will automatically update. You don&#8217;t need to do anything else.<\/li>\n<li>Now is a good time to\u00a0Sort data in a range or table in your drop-down list.<\/li>\n<\/ul>\n<p>2. Choose the worksheet cell where you need to insert the drop-down list.<\/p>\n<p>3. Now hit the <strong>Data<\/strong>&gt; <strong>Data Validation<\/strong> tab from the Excel Ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5076 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/excel-data-validation-ribbon-686-183.png\" alt=\"excel-data-validation-ribbon-686-183\" width=\"686\" height=\"183\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/excel-data-validation-ribbon-686-183.png 686w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/excel-data-validation-ribbon-686-183-300x80.png 300w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Note:<\/strong><\/p>\n<p style=\"text-align: justify;\">If you are unable to hit the <strong>Data Validation <\/strong>tab then this means that your worksheet is either protected or shared.<\/p>\n<ul>\n<li style=\"text-align: justify;\">So immediately, unlock the particular section of your protected workbook or just disable the sharing of worksheets.<\/li>\n<li style=\"text-align: justify;\">After then only try the remaining steps.<\/li>\n<li>From the\u00a0<strong>Settings <\/strong>tab you have to hit the\u00a0<strong>Allow<\/strong>\u00a0box, and then choose the <strong>List <\/strong>option.<\/li>\n<li>Go to the\u00a0<strong>Source <\/strong>box and choose the list range.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">In the shown example we are putting our data on the sheet named as cities in the<strong> A2:A9.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5068 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-a-drop-down-list-1.png\" alt=\"Create a drop-down list 1\" width=\"433\" height=\"292\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-a-drop-down-list-1.png 433w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-a-drop-down-list-1-300x202.png 300w\" sizes=\"auto, (max-width: 433px) 100vw, 433px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"color: #ff0000;\">Remember<\/span><\/strong>: we have left the header row just because we need not to include this in the selection area:<\/p>\n<p style=\"text-align: justify;\">6. If you don\u2019t want that empty cell to create any kind of issue then make a check across the <strong>Ignore blank<\/strong> Also tick the<strong> In-cell dropdown <\/strong>option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5101 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/simple-drop-down-list.png\" alt=\"simple-drop-down-list\" width=\"394\" height=\"319\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/simple-drop-down-list.png 394w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/simple-drop-down-list-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<p>7. Hit the <strong>Input Message<\/strong><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>To make a message box to pop-up when you make a tap over the cell, in that case you need to choose the<strong> \u201cShow input message when cell is selected\u201d<\/strong><\/li>\n<li>Now assign the title and message which you want to show in the dialog box i.e. up to 255 characters.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">In case, you don\u2019t need to show any message then leave the option <strong>\u201cshow input message when cell is selected\u201d<\/strong> unselected.<\/p>\n<p>8. Go to the \u201c<strong>Error Alert\u201d.<\/strong><\/p>\n<ul>\n<li>In case to pop-up a message box when someone put anything wrong that is not present in your list, then make a check across the\u00a0option \u201c<strong>Show error alert after invalid data is entered\u201d<\/strong> .<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5070 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-a-drop-down-list-3.png\" alt=\"Create a drop-down list 3\" width=\"396\" height=\"321\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-a-drop-down-list-3.png 396w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-a-drop-down-list-3-300x243.png 300w\" sizes=\"auto, (max-width: 396px) 100vw, 396px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">After that pick an option from the\u00a0<strong>Style <\/strong>box: <strong>Information, Warning<\/strong>\u00a0<strong>and stop. <\/strong>After that type the <strong>title <\/strong>and <strong>error message<\/strong>. If you don\u2019t wants to display any pop-up message then remove the text from the <strong>error message<\/strong> section and uncheck the <strong>\u201cshow error alert after invalid data is entered\u201d.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5079 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Disable-Error-Alerts.png\" alt=\"Disable Error Alerts\" width=\"394\" height=\"319\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Disable-Error-Alerts.png 394w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Disable-Error-Alerts-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"8\">\n<li style=\"list-style-type: none;\"><\/li>\n<li>If you are confused about the options to choose from the<strong> Style\u00a0<\/strong>box. Then read this out:<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><strong>Information or warning:<\/strong> choosing this option will show the message but doesn\u2019t prevent users from entering unavailable data of the drop-down list.<\/p>\n<p style=\"text-align: justify;\"><strong>Stop:<\/strong> this option will stop users from inputting data which is not present in the drop-down list.<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #ff0000;\"><strong>Note:<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\">If you forgot to add the title or error message then by default the title will be considered as Microsoft Excel and message is taken as &#8220;The value you entered is not valid. A user has restricted values that can be entered into this cell.&#8221;<\/p>\n<h3 style=\"text-align: left;\"><strong>Method 2- Create Drop-Down List Using data From Cells<\/strong><\/h3>\n<p style=\"text-align: justify;\">You can easily <strong>create drop-down list in Excel<\/strong> which allows other entries. Here are the steps that you need to perform:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Enter the value which is not available in the drop-down list after this Excel will display the error alert.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">In this case, allow other entries, and perform the following steps.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Go to the <strong>Data <\/strong>tab after that from <strong>Data Tools <\/strong>group, and hit the <strong>Data Validation<\/strong> icon.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5076 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/excel-data-validation-ribbon-686-183.png\" alt=\"excel-data-validation-ribbon-686-183\" width=\"686\" height=\"183\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/excel-data-validation-ribbon-686-183.png 686w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/excel-data-validation-ribbon-686-183-300x80.png 300w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/p>\n<p style=\"text-align: justify;\">This will open the dialog box of <strong>&#8216;Data Validation&#8217;.<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now you have to move onto the <strong>Error Alert<\/strong> tab and untick the <strong>&#8216;Show error alert after invalid data is entered&#8217; <\/strong>option.<\/li>\n<li>Hit the <strong>OK<\/strong> button.<\/li>\n<li>Now you can very easily enter the value which is not present in the drop-down list.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5079 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Disable-Error-Alerts.png\" alt=\"Disable Error Alerts\" width=\"394\" height=\"319\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Disable-Error-Alerts.png 394w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Disable-Error-Alerts-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<h3 style=\"text-align: left;\"><strong>Method 3- Dynamic Drop-Down List<\/strong><\/h3>\n<p style=\"text-align: justify;\">Another very interesting way is to <strong>create dynamic drop\u2013down list in Excel <\/strong>so that whenever any item is added or deleted from the list it automatically gets updated.<\/p>\n<ul style=\"text-align: justify;\">\n<li>From your first sheet choose the cell<strong> B1<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5096 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-1.png\" alt=\"Dynamic Drop-down List 1\" width=\"604\" height=\"81\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-1.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-1-300x40.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Go to the <strong>Data<\/strong> tab and then from the <strong>Data Tools<\/strong> group hit the <strong>Data Validation<\/strong> icon.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5097 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-2.png\" alt=\"Dynamic Drop-down List 2\" width=\"446\" height=\"100\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-2.png 446w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-2-300x67.png 300w\" sizes=\"auto, (max-width: 446px) 100vw, 446px\" \/><\/p>\n<p style=\"text-align: justify;\">This will automatically open the dialog box of <strong>\u00a0&#8216;Data Validation&#8217;<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>From the <strong>Allow<\/strong> box, hit the<strong> List<\/strong> option.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5098 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-3.png\" alt=\"Dynamic Drop-down List 3\" width=\"394\" height=\"319\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-3.png 394w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-3-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Tap on the <strong>Source<\/strong> box and after that enter this <strong>formula: =OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$A:$A),1)<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5099 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-4.png\" alt=\"Dynamic Drop-down List 4\" width=\"604\" height=\"215\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-4.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-4-300x107.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Explanation:<\/strong> here the\u00a0Excel <strong>OFFSET<\/strong> function\u00a0uses the 5 arguments. Reference: Sheet2!$A$1, rows to offset: 0, columns to offset: 0, height: COUNTA(Sheet2!$A:$A) and width: 1. <strong>COUNTA(Sheet2!$A:$A)<\/strong> counts the number of values in column A on Sheet2 that are not empty. When you add an item to the list on Sheet2, <strong>COUNTA(Sheet2!$A:$A)<\/strong> increases.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5100 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-5.png\" alt=\"Dynamic Drop-down List 5\" width=\"604\" height=\"141\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-5.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dynamic-Drop-down-List-5-300x70.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"text-align: justify;\">This will give you the result that range returned from the OFFSET function gets expanded and it will update the drop-down list also.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Hit the <strong>OK<\/strong> button.<\/li>\n<li>Go to the second sheet, and then add any new item at the list end.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Result:<\/strong><\/p>\n<h3 style=\"text-align: left;\"><strong>Method 4- Dependent Drop-down Lists<\/strong><\/h3>\n<p style=\"text-align: justify;\">Let\u2019s know how you can create a dependent drop-down list in Excel. Here is an example to show you <strong>how to create <\/strong><strong>dependent drop-down lists<\/strong><strong>\u00a0in\u00a0<\/strong><strong>Excel.<\/strong><\/p>\n<p style=\"text-align: justify;\">From one drop down list when the user chooses the pizza.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5081 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-1.png\" alt=\"Dependent Drop-down Lists 1\" width=\"604\" height=\"101\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-1.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-1-300x50.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"text-align: justify;\">Then in the second drop-down list variants of pizza starts appearing. Perform the following steps to create dependent drop-down lists in Excel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5082 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-2.png\" alt=\"Dependent Drop-down Lists 2\" width=\"604\" height=\"101\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-2.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-2-300x50.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Go to the second sheet, for creating up the following named ranges.<\/li>\n<\/ul>\n<table width=\"292\">\n<tbody>\n<tr>\n<td width=\"178\"><strong>Name<\/strong><\/td>\n<td width=\"114\"><strong>Range Address<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Food<\/td>\n<td>A1:A3<\/td>\n<\/tr>\n<tr>\n<td>Pizza<\/td>\n<td>B1:B4<\/td>\n<\/tr>\n<tr>\n<td>Pancakes<\/td>\n<td>C1:C2<\/td>\n<\/tr>\n<tr>\n<td>Chinese<\/td>\n<td>D1:D3<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul style=\"text-align: justify;\">\n<li>From your first sheet just choose the cell<strong> B1.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5083 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-3.png\" alt=\"Dependent Drop-down Lists 3\" width=\"604\" height=\"215\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-3.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-3-300x107.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Go to the Data tab and after that from the Data Tools group, hit the <strong>Data Validation<\/strong> icon.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5084 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-4.png\" alt=\"Dependent Drop-down Lists 4\" width=\"446\" height=\"100\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-4.png 446w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-4-300x67.png 300w\" sizes=\"auto, (max-width: 446px) 100vw, 446px\" \/><\/p>\n<p style=\"text-align: justify;\">This will open the dialog box of<strong> &#8216;Data Validation&#8217;.<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now on the setting tab go to the Allow box make tap over the List option<\/li>\n<li>In the Source box enter the text <strong>type =Food.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5085 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-5.png\" alt=\"Dependent Drop-down Lists 5\" width=\"394\" height=\"319\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-5.png 394w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-5-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Hit the <strong>OK<\/strong> button.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Result:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5086 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-6.png\" alt=\"Dependent Drop-down Lists 6\" width=\"604\" height=\"101\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-6.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-6-300x50.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now choose the cell <strong>E1.<\/strong><\/li>\n<li>From the opened data validation dialog box go to the <strong>settings <\/strong>tab and then from the Allow box make tap over the<strong> List<\/strong> option.<\/li>\n<li>In the Source box enter the text<strong> type =INDIRECT($B$1).<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5087 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-7.png\" alt=\"Dependent Drop-down Lists 7\" width=\"394\" height=\"319\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-7.png 394w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-7-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Press OK button.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Result:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5088 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-8.png\" alt=\"Dependent Drop-down Lists 8\" width=\"604\" height=\"101\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-8.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Dependent-Drop-down-Lists-8-300x50.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Explanation:<\/strong> here <strong>INDIRECT<\/strong> function\u00a0will give you the reference mainly specified by the text string. Suppose if user selects the Chinese food category then from your first drop-down list. <strong>=INDIRECT($B$1)<\/strong>. This will give you the Chinese item references. Due to this in the second drop-down list has the Chinese items.<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/create-calendar-in-excel\">How to Insert\/Create Calendar in Excel?<\/a><\/strong><\/p>\n<\/blockquote>\n<h3 style=\"text-align: left;\"><strong>Method 5- How to Create Drop Down List in Excel Using Table Magic Method?<\/strong><\/h3>\n<p style=\"text-align: justify;\">Another yet option that you can try for how to create drop-down list in Excel 2016 is <strong>Table Magic Method<\/strong>. This technique will help you for storing your items in MS Excel Table and even make a dynamic list.<\/p>\n<p>Here is how you can use this method:<\/p>\n<ul>\n<li style=\"text-align: left;\">Select the list item in the sheet (as shown below).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7015 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/1.png\" alt=\"How to Create Drop Down List in Excel\" width=\"124\" height=\"137\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">Next, click on \u2018<strong>Insert Tab\u2019<\/strong> in tables group &amp; choose \u2018<strong>Table\u2019<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7016 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/2.png\" alt=\"How to Create Drop Down List in Excel\" width=\"204\" height=\"100\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">Now, Excel will select the stuff. Click on <strong>Ok<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7017 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/3.png\" alt=\"How to Create Drop Down List in Excel\" width=\"230\" height=\"151\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">In case, if you choose the list, Excel will display a structured reference<\/li>\n<li style=\"text-align: left;\">Now, you have to use a <strong>structured reference<\/strong> for creating a dynamic dropdown list.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7018 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/4.png\" alt=\"How to Create Drop Down List in Excel\" width=\"394\" height=\"319\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/4.png 394w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/4-300x243.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">After that, add a new entry at end of a list.<\/li>\n<li style=\"text-align: left;\">Finally, the table magic works &amp; the new entry will be displayed on the drop-down list that you have added.<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>How to Add\/Remove Items From Drop-Down List?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Even without using the <strong>&#8216;Data Validation&#8217;<\/strong> option and making changes in the range reference, you can easily add\/delete items from the<strong> drop-down list in Excel.<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>Let\u2019s know how\u2026!<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>For adding an item in the drop-down list, choose the item first which you want to add.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5089 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-1.png\" alt=\"Add or Remove Items 1\" width=\"604\" height=\"175\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-1.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-1-300x87.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Make a right click, and hit the <strong>Insert<\/strong> option.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5090 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-2.png\" alt=\"Add or Remove Items 2\" width=\"137\" height=\"300\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Choose the <strong>&#8220;Shift cells down&#8221; <\/strong>and hit the <strong>OK <\/strong>button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5091 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-3.png\" alt=\"Add or Remove Items 3\" width=\"173\" height=\"178\" \/><\/p>\n<p style=\"text-align: justify;\">Result:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5092 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-4.png\" alt=\"Add or Remove Items 4\" width=\"604\" height=\"195\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-4.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-4-300x97.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #ff0000;\"><strong>Note:<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\">You will notice that automatically the range reference is get shifted from Sheet2!$A$1:$A$3 to Sheet2!$A$1:$A$4. For checking this out, open the dialog box of <strong>&#8216;Data Validation&#8217;.<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Enter any new item that you want to add.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5093 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-5.png\" alt=\"Add or Remove Items 5\" width=\"604\" height=\"195\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-5.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-5-300x97.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Here is the Result:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5094 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-6.png\" alt=\"Add or Remove Items 6\" width=\"604\" height=\"121\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-6.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Add-or-Remove-Items-6-300x60.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>For removing any item from the drop-down list, got o step 2 and hit the<strong> Delete <\/strong>option. Choose the<strong> &#8220;Shift cells up&#8221; <\/strong>option and hit the <strong>OK <\/strong>tab.<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>How to Remove A Drop-Down List in Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Here are the steps that you need to perform for <strong>removing drop-down list in Excel<\/strong>.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Choose the cell having the drop-down list.<\/li>\n<li>Go to the <strong>Data<\/strong> tab and then from the <strong>Data Tools<\/strong> group choose the <strong>Data Validation<\/strong> icon.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5076 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/excel-data-validation-ribbon-686-183.png\" alt=\"excel-data-validation-ribbon-686-183\" width=\"686\" height=\"183\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/excel-data-validation-ribbon-686-183.png 686w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/excel-data-validation-ribbon-686-183-300x80.png 300w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/p>\n<p style=\"text-align: justify;\">After this, you will see that a dialog box of <strong>&#8216;Data Validation&#8217;<\/strong> starts appearing on your screen.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Hit the <strong>Clear All<\/strong> button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5072 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Clear-all-to-remove-data-validation-completely.png\" alt=\"Clear all to remove data validation completely\" width=\"725\" height=\"343\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Clear-all-to-remove-data-validation-completely.png 725w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Clear-all-to-remove-data-validation-completely-300x142.png 300w\" sizes=\"auto, (max-width: 725px) 100vw, 725px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"color: #ff0000;\">Note<\/span>:<\/strong><\/p>\n<p style=\"text-align: justify;\">For removing entire drop-down lists: on the opened data validation dialog box check the <strong>&#8220;Apply these changes to all other cells with the same settings&#8221;<\/strong> option right before selecting the <strong>Clear All<\/strong> button.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Hit the <strong>OK<\/strong> button.<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>How to Recover Corrupt\/Lost\/Deleted Excel File Data?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Have you ever thought about what initiative you will take if all of a sudden your Excel file data is lost or gets deleted somehow? Well, to deal with such a situation I have a simple solution i.e. to use <a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Excel Recovery Tool<\/strong><\/a>, This software helps you to recover deleted, corrupted, lost Excel files even without any backup. Not only this it is also capable to<strong> repair corrupt, damaged Excel (XLS and XLSX) files<\/strong> and <strong>fix Excel errors<\/strong> as well.<\/p>\n<p style=\"text-align: justify;\">With this, you can <strong>recover<\/strong> <strong>charts, chart sheets, tables, cell comments, images, cell comments, formulas, and sort &amp; filter <\/strong>and all data components from <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53\" target=\"_blank\" rel=\"noopener nofollow\"><strong>corrupt Excel files<\/strong><\/a>.<\/p>\n<ul>\n<li>Quickly recover and repair both .xls and .xlsx files.<\/li>\n<li>Easily <a href=\"https:\/\/www.repairmsexcel.com\/blog\/restore-corrupted-excel-2013-file\" target=\"_blank\" rel=\"noopener\">restore multiple corrupted Excel files<\/a> simultaneously.<\/li>\n<li>Restore everything including worksheets, cell comments, worksheet properties, charts, and other data.<\/li>\n<li>Too easy to use so that even a novice user can also use it.<\/li>\n<li>Supports both <strong>Windows <\/strong>as well as<strong> Mac<\/strong> operating systems.<\/li>\n<\/ul>\n<center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Try Now<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/buy-now' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Buy Now<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> Free version of the product only previews recoverable data.<\/div><\/center>\n<h2><strong>Final Verdict<\/strong><\/h2>\n<p style=\"text-align: justify;\">So, this is all about <strong>how to create drop down list in Excel<\/strong>. Here, I have mentioned both the simple and dynamic ways to create Excel drop down list.<\/p>\n<p style=\"text-align: justify;\">Besides, it is advised to handle your Excel file properly &amp;\u00a0create a valid backup\u00a0of your data saved within it to avoid data loss circumstances.<\/p>\n<p style=\"text-align: justify;\">Thanks for reading!<\/p>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>In MS Excel, a drop-down list is an efficient way that helps the user to select the values or text &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Create Drop Down List in Excel (Guide 2023)\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#more-5067\" aria-label=\"Read more about How to Create Drop Down List in Excel (Guide 2023)\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":7023,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[632],"tags":[1486,1488,1487],"class_list":["post-5067","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-how-to-create-drop-down-list-in-excel","tag-how-to-create-drop-down-list-in-excel-2016","tag-how-to-create-drop-down-list-in-excel-2022","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Create Drop Down List in Excel (Guide 2023)<\/title>\n<meta name=\"description\" content=\"Learn easy tricks for how to create drop down list in Excel. Get more detail on how to add or remove items from the drop down list...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create Drop Down List in Excel (Guide 2023)\" \/>\n<meta property=\"og:description\" content=\"Learn easy tricks for how to create drop down list in Excel. Get more detail on how to add or remove items from the drop down list...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-08T12:28:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-03T06:59:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-in-Excel-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"309\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"How to Create Drop Down List in Excel (Guide 2023)\",\"datePublished\":\"2021-05-08T12:28:50+00:00\",\"dateModified\":\"2024-01-03T06:59:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel\"},\"wordCount\":2085,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-in-Excel-1.png\",\"keywords\":[\"how to create drop down list in Excel\",\"how to create drop-down list in Excel 2016\",\"how to create drop-down list in Excel 2022\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel\",\"name\":\"How to Create Drop Down List in Excel (Guide 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-in-Excel-1.png\",\"datePublished\":\"2021-05-08T12:28:50+00:00\",\"dateModified\":\"2024-01-03T06:59:38+00:00\",\"description\":\"Learn easy tricks for how to create drop down list in Excel. Get more detail on how to add or remove items from the drop down list...\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-in-Excel-1.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-in-Excel-1.png\",\"width\":550,\"height\":309,\"caption\":\"Create Drop Down List in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create Drop Down List in Excel (Guide 2023)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\/\/www.repairmsexcel.com\/\",\"https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242\"],\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create Drop Down List in Excel (Guide 2023)","description":"Learn easy tricks for how to create drop down list in Excel. Get more detail on how to add or remove items from the drop down list...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel","og_locale":"en_US","og_type":"article","og_title":"How to Create Drop Down List in Excel (Guide 2023)","og_description":"Learn easy tricks for how to create drop down list in Excel. Get more detail on how to add or remove items from the drop down list...","og_url":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2021-05-08T12:28:50+00:00","article_modified_time":"2024-01-03T06:59:38+00:00","og_image":[{"width":550,"height":309,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-in-Excel-1.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"How to Create Drop Down List in Excel (Guide 2023)","datePublished":"2021-05-08T12:28:50+00:00","dateModified":"2024-01-03T06:59:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel"},"wordCount":2085,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-in-Excel-1.png","keywords":["how to create drop down list in Excel","how to create drop-down list in Excel 2016","how to create drop-down list in Excel 2022"],"articleSection":["Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel","name":"How to Create Drop Down List in Excel (Guide 2023)","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-in-Excel-1.png","datePublished":"2021-05-08T12:28:50+00:00","dateModified":"2024-01-03T06:59:38+00:00","description":"Learn easy tricks for how to create drop down list in Excel. Get more detail on how to add or remove items from the drop down list...","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-in-Excel-1.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Create-Drop-Down-List-in-Excel-1.png","width":550,"height":309,"caption":"Create Drop Down List in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/create-drop-down-list-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"How to Create Drop Down List in Excel (Guide 2023)"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=5067"}],"version-history":[{"count":1,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5067\/revisions"}],"predecessor-version":[{"id":7757,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5067\/revisions\/7757"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/7023"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=5067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=5067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=5067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}