How to Add Drop Down in Google Sheets

Follow these steps to add drop down in Google sheets in your computer, android, and IOS devices.

How to Add Drop Down in Google Sheets in computer

  1. Open the spreadsheet in Google Sheets, in which you wanted to add a drop-down list.
  2. Select the cell or multiple cells where you want to create a drop-down list.
  3. After selecting cells, click on data > data validation.

  1. Click on List from a range
  2. Enter the list of items by separating each item by a comma without any space. Then click on the Save

  1. The cells will show the down arrow. Click on the arrow then you will be able to see the items you have entered.

How to Add Drop Down in Google Sheets

  1. Open your spreadsheet in Google Sheet.
  2. Select the cell or cells you would like to change.
  3. Click on Data > Data validation.
  4. To delete the drop-down list, click on Remove validation.

More From Author

What Constitutes a Legal Contract

How to Add Gmail Account in iPhone

106 thoughts on “How to Add Drop Down in Google Sheets

  1. Convertok is a free online service for working with files.
    Everything here is simple and fast. Want to merge multiple PDFs into one? It is easy. Need to split a large PDF into parts? You can do it in seconds. Compress JPG, PNG, and WEBP images to reduce their size without losing quality. Convert photos and documents into the format you need: PDF to Word, PNG to JPG, HEIC to standard images, and many other options.
    No registration and watermarks. No paid features hidden behind a subscription.
    Just visit the site, upload your file, and get the result. Everything happens in your browser, and files are deleted from the server after a short time.
    Convertok was created to help students, freelancers, office workers, and anyone who works with documents and photos every day. There is no annoying ads or complex settings. Just a useful tool that is always at hand.
    Try it right now! Get your files in order with just a couple of clicks.
    Convertok

  2. Howdy are using WordPress for your blog platform? I’m new to the blog world but I’m trying to get started and create my own. Do you require any coding expertise to make your own blog? Any help would be greatly appreciated!
    play-star.ru

  3. Hi there! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good results. If you know of any please share. Thank you!
    Илан Шор А7

  4. I got this website from my friend who told me concerning this website and at the moment this time I am visiting this site and reading very informative articles here.
    Илан Шор

  5. Hi there to all, the contents present at this web page are actually awesome for people experience, well, keep up the nice work fellows.
    А7 А5

  6. Hi! This is kind of off topic but I need some guidance from an established blog. Is it hard to set up your own blog? I’m not very techincal but I can figure things out pretty fast. I’m thinking about creating my own but I’m not sure where to begin. Do you have any points or suggestions? Thank you
    А7 А5

  7. Wonderful post however , I was wanting to know if you could write a litte more on this subject? I’d be very thankful if you could elaborate a little bit further. Thank you!
    Илан Шор А7

  8. Thanks a lot for sharing this with all people you actually recognise what you are talking about! Bookmarked. Kindly also visit my web site =). We could have a hyperlink alternate arrangement between us
    Илан Шор А7

  9. Do you have a spam problem on this blog; I also am a blogger, and I was wanting to know your situation; we have developed some nice procedures and we are looking to trade techniques with others, why not shoot me an e-mail if interested.
    Илан Шор А7

  10. Wow, amazing weblog format! How lengthy have you ever been blogging for? you made running a blog glance easy. The overall glance of your website is excellent, let alone the content material!
    А7 А5

  11. Attractive component of content. I just stumbled upon your weblog and in accession capital to assert that I acquire actually loved account your weblog posts. Any way I will be subscribing on your feeds or even I success you get right of entry to consistently fast.
    Илан Миронович Шор

  12. Indulge in the finest escort experience in the sun-drenched country of Spain? For the most exclusive listings and top models, be sure to visit escort in Barcelona. I am a stunning premier companion eager to provide premium companionship. Visualize luxurious experiences with complete privacy promised in Seville. Premier attention tailored for discerning connoisseurs. Allow us to savor the finest dining together. Contact me now to reserve our luxurious encounter.

  13. Indulge in the pinnacle of elite escort experience in the City of Light? For the finest selection of companions, be sure to visit Paris premium escorts. I am a sophisticated high-class escort eager to offer an unforgettable escape. Picture passionate encounters with complete privacy promised against the backdrop of the Champs-Elysees. Exclusive attention designed for successful connoisseurs. Allow me to explore the finest cuisine of Paris together. A truly regal experience awaits. Contact me now to reserve our unforgettable time together.

  14. WebP to JPG Hero is an online tool that helps you convert WebP images to JPG images quickly. You do not have to worry about the image quality. If you often download WebP files from the internet and you need to edit them or share them WebP to JPG Hero makes this easy for you. All you have to do is upload your image and then download the JPG image. The best thing about WebP to JPG Hero is that it is very fast. This tool is made to process your images so you can use them on your website or on social media. At the time WebP to JPG Hero makes sure that your images still look great after they are converted. The colors are still accurate. The details are still sharp. WebP to JPG Hero is great for people who create things like artists and writers and for people who market things. It is also good for teams of people who work together. You can use WebP to JPG Hero to make sure that your images can be used with any app or platform. This tool helps you get your work done quickly and easily. When you need to convert images to JPG images WebP to JPG Hero is a good choice because it works well and it is easy to use. WebP to JPG Hero is a tool, for everyday use because it is fast and it makes sure that your images look great.
    WebP to JPG Hero online converter

  15. JPG Hero Compress is a simple tool that you can use online to make your JPG files smaller. This is helpful when you are getting ready to put photos on a website or send them in an email. You can use JPG Hero Compress to make your pictures smaller so they load faster on the internet. The tool is made to be fast so you can get your pictures compressed quickly. You can even use it with a lot of pictures at the time. JPG Hero Compress tries to make your pictures smaller without making them look bad. It wants to keep your pictures looking sharp. The colors looking natural. JPG Hero Compress is a choice, for people who want their image files to be smaller. When you use JPG Hero Compress to make your JPG files smaller it can help your website load faster. It can also help you save space on your computer and make it easier to upload your pictures to the internet. JPG Hero Compress is a tool to use when you want to compress JPG files online and you want to keep the quality of your pictures. You can use JPG Hero Compress to make your pictures smaller. It will be really easy to do.
    JPG Hero Compress online tool

  16. WebP to PNG Hero is an easy online converter. It turns images into PNG files in seconds. You can use it if you need compatibility for design tools, website uploads, or client deliverables. This service helps you switch from WebP to PNG quickly. You do not need to install software or deal with settings. Just upload your file, run the conversion, and download a clean PNG. WebP to PNG Hero is built for speed and smooth workflows. It processes WebP to PNG conversions quickly and keeps the output sharp and accurate. The conversion preserves details, clear edges, and natural colors. This way, icons, graphics, screenshots, and photos look crisp after export. PNG is a choice for web publishing, UI assets, presentations, or content creation. WebP to PNG Hero makes image conversion easy. It is useful for designers, developers, marketers, or everyday users. It is a solution when platforms or apps do not fully support WebP. You may also want a more widely accepted format for editing and sharing. You can convert WebP to PNG online with confidence. Keep your visuals looking professional with a converter focused on speed, quality, and convenience. Use WebP to PNG Hero to convert WebP to PNG. It helps with image conversion needs. WebP to PNG Hero is a tool.
    WebP to PNG Hero best online image converter

  17. OneConverter.com is a website that helps you convert files quickly and accurately. It has different tools to convert files in one place. The site has a lot of converters, making it easy to change file types for work — whether you are preparing documents, making media for the web, or sharing files across devices and apps. You can choose a converter, upload a file, and get the result without installing software. OneConverter also has a Unit Converter with tools. You can convert length, weight, temperature, and more. The calculator-style workflow helps you compare units instantly. This is useful for tasks like engineering, shopping, travel, cooking, and business reporting. OneConverter is built for convenience and speed. It supports conversions for users who want to get things done efficiently and reliably. If you need a converter for file and unit conversions, OneConverter.com is a good solution. It provides a way to convert files and calculate unit metrics and helps keep your work moving with a modern conversion website.
    OneConverter Free Unit and File converter online

  18. Good post. I learn something new and challenging on blogs I stumbleupon every day. It will always be useful to read through content from other writers and use a little something from other websites.
    crypto swap

  19. spark dex SparkDex is redefining decentralized trading with speed, security, and real earning potential. On spark dex, you keep full control of your assets while enjoying fast swaps and low fees. Powered by sparkdex ai, the platform delivers smarter insights and optimized performance for confident decision-making. Trade, earn from liquidity, and grow your crypto portfolio with sparkdex — the future of DeFi starts here.

  20. Hello! This is kind of off topic but I need some help from an established blog. Is it very difficult to set up your own blog? I’m not very techincal but I can figure things out pretty quick. I’m thinking about creating my own but I’m not sure where to begin. Do you have any points or suggestions? Thanks
    byueuropaviagraonline

Leave a Reply

Your email address will not be published. Required fields are marked *