How do I edit a drop

In the previous tutorial, we went through a simple guide on how to create a drop-down list in Excel.

In this tutorial, we’ll go a bit further and you’ll learn how to edit the drop-down menu and change options offered on the list.

Actually, it’s very simple!

See the video tutorial and transcription below:

See this video on YouTube:
https://www.youtube.com/watch?v=qIh4psSxsE8

Here, I’ll use two different examples to show how editing a drop-down menu works, so you’ll know two ways how to do it. The first one will be the longer list.

I’ll show the shorter one later on, and I’ll use the lists we created together in the previous tutorial.

How to Edit Longer Drop-Down List in Excel

So, here’s the longer one – the months of the year.

Let’s say we want to make changes to the first question and we want to use, for example, ‘Which is your favourite summer month?’ instead. Our items now include months that are irrelevant – the list of three summer months will do for this question. What we need to do is edit the list according to this.

Click on the cell that contains the drop-down list you want to edit – it’s the cell with the list of months.

Next, click on ‘Data’ tab. In the section ‘Data Tools’, go to ‘Data Validation’.

In the pop-up window that appeared, go to the tab ‘Settings’ and click into the box ‘Source’.

Excel will take you to the location of the source cells for this drop-down list. In this case, it’s the sheet ‘Months’. Our list is made of options saved in the cells range A1 to A12.

If we want to edit the drop-down menu, we need to remove the information in the ‘Source’ box. Highlight it and press ‘Delete’. Now we’ll select only the months we need – the summer months June, July and August.

You can notice how the information in the section ‘Source’ changed, too. The list is now made of the data contained in the cells A6 to A8.

Double-check whether everything is correct and confirm with OK.
Ta-da!
The drop-down menu has been edited and there are only those three options that we wanted to show.

You can use these steps to edit the list in whatever way you need. The drop-down menu will display only the items present in the cells you included as the source.

How to Edit Shorter Drop-Down List in Excel

And now we can have a look at the other way – how to edit the shorter list containing only ‘Yes’ and ‘No’. We might want to expand the menu and add ‘Maybe’ on the list.&lt;/p&gt;&lt;p&gt;&lt;span id="ezoic-pub-ad-placeholder-120" class="ezoic-adpicker-ad"&gt;&lt;/span&gt;&lt;span class="ezoic-ad ezoic-at-0 leader-1 leader-1120 adtester-container adtester-container-120" data-ez-name="easyclickacademy_com-leader-1"&gt;&lt;span id="div-gpt-ad-easyclickacademy_com-leader-1-0" ezaw="250" ezah="250" style="position:relative;z-index:0;display:inline-block;padding:0;width:100%;max-width:1200px;margin-left:auto!important;margin-right:auto!important;min-height:50px;min-width:320px" class="ezoic-ad"&gt;&lt;script data-ezscrex="false" data-cfasync="false" style="display:none"&gt;if(typeof ez_ad_units!='undefined'){ez_ad_units.push([[250,250],'easyclickacademy_com-leader-1','ezslot_7',120,'0','0'])};__ez_fad_position('div-gpt-ad-easyclickacademy_com-leader-1-0');We’ll follow the first couple of steps as in the previous example – click on the cell with the drop-down list, go to ‘Data’, then ‘Data Validation’. As you can see, the source here is not a&nbsp;range of cells, but specific text, so it’s alright if you just type in ‘Maybe’ at the end of the line and don’t forget to separate it with a&amp;nbsp;comma.&lt;/p&gt;&lt;figure class="wp-block-image"&gt;&lt;img decoding="async" loading="lazy" width="1024" height="576" src="https://www.easyclickacademy.com/wp-content/uploads/2019/05/How-to-edit-drop-down-list-in-Excel-overwrite-drop-down-list-1024x576.jpg" alt="How to edit drop down list in Excel - overwrite drop down list" class="wp-image-780" srcset="https://www.easyclickacademy.com/wp-content/uploads/2019/05/How-to-edit-drop-down-list-in-Excel-overwrite-drop-down-list-1024x576.jpg 1024w, https://www.easyclickacademy.com/wp-content/uploads/2019/05/How-to-edit-drop-down-list-in-Excel-overwrite-drop-down-list-300x169.jpg 300w, https://www.easyclickacademy.com/wp-content/uploads/2019/05/How-to-edit-drop-down-list-in-Excel-overwrite-drop-down-list-768x432.jpg 768w, https://www.easyclickacademy.com/wp-content/uploads/2019/05/How-to-edit-drop-down-list-in-Excel-overwrite-drop-down-list-970x546.jpg 970w, https://www.easyclickacademy.com/wp-content/uploads/2019/05/How-to-edit-drop-down-list-in-Excel-overwrite-drop-down-list-461x259.jpg 461w, https://www.easyclickacademy.com/wp-content/uploads/2019/05/How-to-edit-drop-down-list-in-Excel-overwrite-drop-down-list-297x167.jpg 297w, https://www.easyclickacademy.com/wp-content/uploads/2019/05/How-to-edit-drop-down-list-in-Excel-overwrite-drop-down-list-213x120.jpg 213w, https://www.easyclickacademy.com/wp-content/uploads/2019/05/How-to-edit-drop-down-list-in-Excel-overwrite-drop-down-list-171x96.jpg 171w, https://www.easyclickacademy.com/wp-content/uploads/2019/05/How-to-edit-drop-down-list-in-Excel-overwrite-drop-down-list.jpg 1920w" sizes="(max-width: 1024px) 100vw, 1024px"&gt;&lt;/figure&gt;&lt;p&gt;Add the option, click on OK and that’s it – a&amp;nbsp;piece of cake, right?&lt;/p&gt;&lt;p&gt;The second list has been updated.&lt;/p&gt;&lt;p&gt;Don’t miss out a&amp;nbsp;great opportunity to learn:&lt;/p&gt;&lt;ul&gt;&lt;li&gt;&lt;a rel="noreferrer noopener" aria-label="(opens in a&nbsp;new tab)" href="https://www.youtube.com/watch?v=mMOe32zFaHU" target="_blank"&gt;How to Create a&amp;nbsp;Drop-Down List in Excel&lt;/a&gt; or&lt;/li&gt;&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=Y_vrBmn3sBw" target="_blank" rel="noreferrer noopener" aria-label="(opens in a&nbsp;new tab)"&gt;How to Remove Drop-Down List in Excel&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;If you’ve found this tutorial helpful, &lt;a href="https://www.youtube.com/c/ExcelTutorialsByEasyClickAcademy?sub_confirmation=1" target="_blank" rel="noreferrer noopener" aria-label="(opens in a&nbsp;new tab)"&gt;like us and&amp;nbsp;subscribe to receive more videos from EasyClick Academy.&lt;/a&gt;&amp;nbsp;Look at more tutorials that help you use Excel quick and easy!&lt;/p&gt;&lt;p&gt;See you in the next tutorial!&lt;/p&gt;&lt;/div&gt;&lt;div class="in_share_element in_share_element_1 blog_share_buttons"&gt;&lt;div class="fb-like" data-href="https://www.easyclickacademy.com/how-to-edit-drop-down-list-in-excel/" data-layout="button_count" data-action="like" data-show-faces="false" data-share="true"&gt;&lt;/div&gt;&lt;div class="twitter-like"&gt;&lt;a target="_blank" href="https://twitter.com/share" class="twitter-share-button" data-url="https://www.easyclickacademy.com/how-to-edit-drop-down-list-in-excel/'" data-count="horizontal" data-lang="cs"&gt;Tweet&lt;/a&gt; &lt;script&gt;!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+'://platform.twitter.com/widgets.js';fjs.parentNode.insertBefore(js,fjs);}}(document,'script','twitter-wjs');</p></div></div><div class="related_posts"><div class="related_posts_title title_element_container">Similar posts</div><div class="related_posts_container"><div class="related_post col col-three col-first"><a target="_blank" class="related_post_thumb" href="https://www.easyclickacademy.com/how-to-resize-multiple-columns-in-excel/"><img width="461" height="346" src="https://www.easyclickacademy.com/wp-content/uploads/2022/11/How-to-Resize-Multiple-Columns-in-Excel-461x346.jpg" class="attachment-mio_columns_2 size-mio_columns_2 wp-post-image" alt="How to Resize Multiple Columns in Excel" decoding="async" loading="lazy" srcset="https://www.easyclickacademy.com/wp-content/uploads/2022/11/How-to-Resize-Multiple-Columns-in-Excel-461x346.jpg 461w, https://www.easyclickacademy.com/wp-content/uploads/2022/11/How-to-Resize-Multiple-Columns-in-Excel-970x727.jpg 970w, https://www.easyclickacademy.com/wp-content/uploads/2022/11/How-to-Resize-Multiple-Columns-in-Excel-297x223.jpg 297w, https://www.easyclickacademy.com/wp-content/uploads/2022/11/How-to-Resize-Multiple-Columns-in-Excel-213x160.jpg 213w, https://www.easyclickacademy.com/wp-content/uploads/2022/11/How-to-Resize-Multiple-Columns-in-Excel-171x128.jpg 171w" sizes="(max-width: 461px) 100vw, 461px"></a> <a target="_blank" class="related_post_title title_element_container" href="https://www.easyclickacademy.com/how-to-resize-multiple-columns-in-excel/">How to Resize Multiple Columns in Excel (3 Most Common Ways)</a><p>Today we’ll be talking about three most common ways how to resize…</p></div><div class="related_post col col-three"><a target="_blank" class="related_post_thumb" href="https://www.easyclickacademy.com/how-to-show-gridlines-in-excel/"><img width="461" height="346" src="https://www.easyclickacademy.com/wp-content/uploads/2022/09/How-to-Show-Gridlines-in-Excel-461x346.png" class="attachment-mio_columns_2 size-mio_columns_2 wp-post-image" alt="How to Show Gridlines in Excel" decoding="async" loading="lazy" srcset="https://www.easyclickacademy.com/wp-content/uploads/2022/09/How-to-Show-Gridlines-in-Excel-461x346.png 461w, https://www.easyclickacademy.com/wp-content/uploads/2022/09/How-to-Show-Gridlines-in-Excel-970x727.png 970w, https://www.easyclickacademy.com/wp-content/uploads/2022/09/How-to-Show-Gridlines-in-Excel-297x223.png 297w, https://www.easyclickacademy.com/wp-content/uploads/2022/09/How-to-Show-Gridlines-in-Excel-213x160.png 213w, https://www.easyclickacademy.com/wp-content/uploads/2022/09/How-to-Show-Gridlines-in-Excel-171x128.png 171w" sizes="(max-width: 461px) 100vw, 461px"></a> <a target="_blank" class="related_post_title title_element_container" href="https://www.easyclickacademy.com/how-to-show-gridlines-in-excel/">How to Show Gridlines in Excel (Quick and Simple)</a><p>Today we’re going to talk about how to show gridlines in Excel.…</p></div><div class="related_post col col-three"><a target="_blank" class="related_post_thumb" href="https://www.easyclickacademy.com/how-to-insert-the-degree-symbol-in-excel/"><img width="461" height="346" src="https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Degree-Symbol-in-Excel-461x346.png" class="attachment-mio_columns_2 size-mio_columns_2 wp-post-image" alt="How to Insert Degree Symbol in Excel" decoding="async" loading="lazy" srcset="https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Degree-Symbol-in-Excel-461x346.png 461w, https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Degree-Symbol-in-Excel-970x727.png 970w, https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Degree-Symbol-in-Excel-297x223.png 297w, https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Degree-Symbol-in-Excel-213x160.png 213w, https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Degree-Symbol-in-Excel-171x128.png 171w" sizes="(max-width: 461px) 100vw, 461px"></a> <a target="_blank" class="related_post_title title_element_container" href="https://www.easyclickacademy.com/how-to-insert-the-degree-symbol-in-excel/">How to Insert the Degree Symbol in Excel (Two Useful Ways)</a><p>Today we’re going to go through two useful ways how to insert…</p></div></div></div><div id="blog_comments_container"><div class="commenttitle title_element_container">Comments</div><div class="element_comment_1 blog_comments"><div id="comments" class="comments"><span id="ezoic-pub-ad-placeholder-123" class="ezoic-adpicker-ad"></span><span class="ezoic-ad ezoic-at-2 nativedouble-1 nativedouble-1123 adtester-container adtester-container-123" data-ez-name="easyclickacademy_com-nativedouble-1"><div class="OUTBRAIN" data-ob-contenturl="https://www.easyclickacademy.com/how-to-edit-drop-down-list-in-excel/" data-ob-installation-key="EZOICL9MFJN21JB32NFBE7ODP" data-external-id="213741_1_123_100x480" data-widget-id="AR_1"></div><div data-expand="100" class="ezlazyload" data-script="//widgets.outbrain.com/outbrain.js"></div></span><div id="respond" class="comment-respond"><h3 id="reply-title" class="comment-reply-title">Add comment <small><a target="_blank" rel="nofollow" id="cancel-comment-reply-link" href="https://www.easyclickacademy.com/how-to-edit-drop-down-list-in-excel/?utm_campaign=How+to+EDIT+DROP-DOWN+LIST+in+Excel#respond" style="display:none">Delete answer</a></small></h3><form action="https://www.easyclickacademy.com/wp-comments-post.php" method="post" id="commentform" class="comment-form"><p class="comment-notes"><span id="email-notes">Your email address will not be published.</span> <span class="required-field-message">Required fields are marked <span class="required">*</span></span></p><p class="comment-form-comment"><label for="comment">Comment <span class="required">*</span></label> <textarea id="comment" name="comment" cols="45" rows="8" maxlength="65525" required></textarea></p><p class="comment-form-author"><label for="author">Name <span class="required">*</span></label> <input id="author" name="author" size="30" maxlength="245" autocomplete="name" required></p><p class="comment-form-email"><label for="email">Email <span class="required">*</span></label> <input id="email" name="email" size="30" maxlength="100" aria-describedby="email-notes" autocomplete="email" required></p><p class="comment-form-url"><label for="url">Website</label> <input id="url" name="url" size="30" maxlength="200" autocomplete="url"></p><p class="mw_field_gdpr_accept"><input type="hidden" value="Your personal information will only be used for the purpose of processing this comment." name="mw_comment_gdpr">Your personal information will only be used for the purpose of processing this comment.</p><p class="form-submit"><input name="submit" type="submit" id="submit" class="ve_content_button ve_content_button_style_x" value="Insert comment"> <input type="hidden" name="comment_post_ID" value="765" id="comment_post_ID"> <input type="hidden" name="comment_parent" id="comment_parent" value="0"></p><p style="display:none"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="ed2cf925e0"></p><p style="display:none!important"><label>Δ<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js" value="15"><script>document.getElementById("ak_js_1").setAttribute("value",(new Date()).getTime());

How do I edit drop do?

How do I edit a drop

How do I add or remove items from a drop

How do I insert a drop?