{"id":438902,"date":"2022-04-28T21:00:34","date_gmt":"2022-04-28T18:00:34","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-add-to-or-edit-a-drop-down-list-in-google-sheets\/"},"modified":"2022-04-28T21:00:34","modified_gmt":"2022-04-28T18:00:34","slug":"how-to-add-to-or-edit-a-drop-down-list-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-add-to-or-edit-a-drop-down-list-in-google-sheets\/","title":{"rendered":"#How to Add To or Edit a Drop-Down List in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a364daec20c2\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a364daec20c2\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-to-or-edit-a-drop-down-list-in-google-sheets\/#%E2%80%9CHow_to_Add_To_or_Edit_a_Drop-Down_List_in_Google_Sheets%E2%80%9D\" >&#8220;How to Add To or Edit a Drop-Down List in Google Sheets&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-to-or-edit-a-drop-down-list-in-google-sheets\/#Add_or_Remove_Items_From_the_Drop-Down_Menus_in_Google_Sheets\" >Add or Remove Items From the Drop-Down Menus in Google Sheets<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Add_To_or_Edit_a_Drop-Down_List_in_Google_Sheets%E2%80%9D\"><\/span>&#8220;How to Add To or Edit a Drop-Down List in Google Sheets&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-741481\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The Google Sheets logo.\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Google Sheets makes it easy to add and remove items from the existing drop-down menus in your spreadsheets. You can also change your drop-down settings, and even completely remove them if you want. Here\u2019s how to do that.<\/p>\n<p>Sheets lets you selectively make changes to your drop-downs. This way, you can select a drop-down and make changes to it, while keeping all other drop-downs as is.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Create a Drop-Down List in Google Sheets<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_or_Remove_Items_From_the_Drop-Down_Menus_in_Google_Sheets\"><\/span>Add or Remove Items From the Drop-Down Menus in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To tweak the drop-down list items in your spreadsheets, first, launch a web browser on your computer and open <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/\">Google Sheets<\/a>. Then access the spreadsheet in which your drop-down lists are located.<\/p>\n<p>On your spreadsheet screen, select the cells containing drop-down items that you want to tweak.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796017\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/1-select-drop-down-menus.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select drop-down lists.\" width=\"650\" height=\"342\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>While your drop-down menus are selected, in Google Sheets\u2019 menu bar, click Data &gt; Data Validation.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796018\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/2-edit-drop-down-lists.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Data &gt; Data Validation from the menu bar.\" width=\"597\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>A \u201cData Validation\u201d window will open where you\u2019ll customize your drop-down list items.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796019\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/3-drop-down-menu-configuration.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The &quot;Data Validation&quot; window.\" width=\"650\" height=\"370\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>On this window, the \u201cCriteria\u201d menu defines the kind of items your drop-down menus have. To add or remove items, then use the box next to this menu.<\/p>\n<p>You can add a new list item by typing a comma and then entering your item name. Or, you can remove an item by clearing it in the list. Feel free to change any other options you want on this window.<\/p>\n<p>When you\u2019re done, at the bottom of the \u201cData Validation\u201d window, click \u201cSave.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796020\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/4-add-remove-items-drop-down-list.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Edit drop-down list items and click &quot;Save.&quot;\" width=\"650\" height=\"444\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Your spreadsheet will now display the updated items in your drop-down lists.<\/p>\n<p>You\u2019re probably wondering what h<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ens to the cells where you\u2019ve selected a list item that\u2019s no longer available. In those cells, Sheets displays a warning message saying the entered item is invalid. You\u2019ll want to select a new valid item from the drop-down list in these cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796021\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/5-invalid-entries.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Invalid drop-down entries.\" width=\"650\" height=\"272\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019d like to remove a drop-down list from a cell, select that cell and choose Data &gt; Data Validation in the menu bar. Then, on the \u201cData Validation\u201d window, click \u201cRemove Validation.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796022\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/6-remove-drop-down-list-items.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose &quot;Remove Validation.&quot;\" width=\"650\" height=\"445\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Your drop-down list is now removed, but the values you selected previously are still there for you to use.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-796023\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/7-drop-down-list-items-removed.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Drop-down list items removed.\" width=\"650\" height=\"340\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And that\u2019s how you edit your drop-down lists in Google Sheets to add new items as well as remove existing ones. Very useful!<\/p>\n<hr\/>\n<p>You can edit existing drop-down menus in Microsoft Excel, too.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Edit a Drop-Down List in Microsoft Excel<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/796013\/how-to-add-to-or-edit-a-drop-down-list-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Add To or Edit a Drop-Down List in Google Sheets&#8221; Google Sheets makes it easy to add and remove items from the existing drop-down menus in your spreadsheets. You can also change your drop-down settings, and even completely remove them if you want. Here\u2019s how to do that. Sheets lets you selectively make&#8230;<\/p>\n","protected":false},"author":1,"featured_media":438903,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-438902","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/438902","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=438902"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/438902\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/438903"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=438902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=438902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=438902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}