![how to make a drop down list in excel list in google sheets how to make a drop down list in excel list in google sheets](https://static1.makeuseofimages.com/wordpress/wp-content/uploads/2018/09/Google-Sheets-Drop-Down-Menu-1.png)
And also you can follow us on Twitter and Facebook.
![how to make a drop down list in excel list in google sheets how to make a drop down list in excel list in google sheets](https://www.automateexcel.com/excel/wp-content/uploads/2021/04/DDList_intro.jpg)
On the Settings tab, select List from the Allow drop-down list (see, drop-down lists are everywhere).
![how to make a drop down list in excel list in google sheets how to make a drop down list in excel list in google sheets](https://usermanual.wiki/Document/SQLWorkbenchManual.24942592-User-Guide-Page-1.png)
In the Data Tools section of the Data tab, click the Data Validation button. If you liked our blogs, share it with your friends on Facebook. Now, select the cell into which you want to add a drop-down list and click the Data tab. You can create a dropdown list in google sheets using the same method. Repeat the process for all the options like Green and Blue and your list will be shown like in below snapshot.ĭrop down list and Conditional formatting tools are very useful in Excel 2016, to view your data in a particular format manner. Select Specific Text option and select the cell for colour as in this case Red. Select New rule from the list and a dialog box will appear. Select the option List in Allow and select the source list in Source option and click OK.Ī dropdown list will be created on the cell. We need that the user has to select from this list.Ĭlick Data > Data Validation option in Excel 2016ĭata Validation dialog box appears as shown above. Here is a list of three colours Red, Green and Blue.
How to make a drop down list in excel list in google sheets how to#
We will be using Conditional Formatting and Data Validation options.įirst, let’s understand how to make a dropdown list in Excel with an example here In this article, we will learn how to create a Dropdown list with color in Microsoft Excel.ĭrop down list limits the user to choose a value from the list provided instead of adding values in sheet.