how to make a drop down list in excel table

i know this is a long shot to get a reply but figured what the hell. I am struggling just trying to explain this so searching google has been frustrating. this works great to provide an answer in C2, but when i pick something from the list in A3-A13, it still pulls the formula but still links it to the number inputted in B2 instead of finding the corresponding “B column” that matches the item picked in the “A” column. “so if i pick countersink in cell A2 from the list, the formula attached is main1B2*20+15. all the formulas are linked to the number you input in B2 on the main tab.

so when i pick the item from the drop down, it pulls the formula. each item in the list is linked to a formula. I have a drop down list in column A2-A13. i do have a pretty direct question that i am struggling to find help with.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you.Hello, i really enjoyed this and it will be very helpful as i navigate through excel. And also you can follow us on Twitter and Facebook. If you liked our blogs, share it with your friends on Facebook. 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. 3.1 Create a simple dependent drop-down list 4 Conclusion You can easily allow users to choose an item from a pre-defined list, by using a dropdown list in Excel. 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. 2.2 Create a dynamic drop down list by using Table Formatting 2.3 Create a dynamic drop down list by using the UNIQUE Function 3 How to create a dependent drop-down list. 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. 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.

How to make a drop down list in excel table