{"id":5299,"date":"2020-11-25T14:48:49","date_gmt":"2020-11-25T14:48:49","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=5299"},"modified":"2024-03-26T12:32:52","modified_gmt":"2024-03-26T12:32:52","slug":"drop-down-list","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/drop-down-list\/","title":{"rendered":"Drop Down List in Excel"},"content":{"rendered":"\n
Drop-down lists are useful when it comes to selecting one item from multiple choices. They are very popular in online forms, especially for languages, countries, cities, etc.<\/p>\n\n\n\n
But the web is not the only place you can find them; They can also be present on desktop applications.<\/p>\n\n\n\n
Excel is one of them. It offers a pretty extensive set of tools that allows manipulating drop-downs in many different ways.<\/p>\n\n\n\n
To use drop-down lists, you have to prepare data. It’s a good idea to place data in a different worksheet than drop-down lists. This will help you to organize it better and avoid accidental deletions.<\/p>\n\n\n\n
Inside our example, there are two sheets: “countries” and “countries data”.<\/p>\n\n\n\n