For example, check to see if the cell is wide enough to show your updated entries. Here is a snapshot of what you finally get: You can now hide the original data if you want. Can we extract the data from multiple drop-down selection? Closing all If statements. Hi sumit, Is there any way of showing all items in a product which is in dropdown list? All Rights Reserved. This article is a guide to Edit Drop-Down List in Excel. Can i send you my file. He can choose a specific one. Select List. I am having a problem with cross referencing the data. Explore subscription benefits, browse training courses, learn how to secure your device, and more. Hi Sumit, can you do this so it is not AND. Select the worksheet that has the data for your drop-down list. Having placed the cursor on the Source: field, go to the sheet and select the required cells alternately. I cannot sort the first database by last name as the blank lines will not properly adjust with the associated name. Are you able to advise how I should go about achieving this or point me in the right direction of where I can find tutorials around this please? In the Source box, add new list items to the list or remove the ones you no longer want. Dear sir, when i make like this including date format and number, My answer is wrong. 234 1 In Cell D4, there is a dropdown list created which holds the values (e.g., Grapes, Orange, Apple, Mango, Apple) retrieved from the generic list (range B5:B9). Here is our table with a list on one sheet: The "smart table", which easily "expands" and changes, has helped us to perform our task. Yep but I just found a problem!!! [CDATA[ This would give us something as shown below in the pic: Now when we have the number together, we just need to extract the data in that number. In the cell we want to enter the validation, we will select the cell, cell B2. Because we are going to be placing the code on the "List" sheet, we will right-mouse-click on the "List" sheet tab and select View Code. So for example in your tutorial. Hello Jon.. The process to add a drop-down list with color formatting is much the same in Google Sheets as it is in Excel. Remember that the name cannot contain spaces or punctuation. //