Excel Drop Downs From List on Different Sheet
✅ Get the sample Excel file to follow along: https://myctx.link/dvdrop Make it easy for people to enter data in an Excel workbook. Create drop down lists in the cells, with Excel data validation. This example has a list of products on one worksheet, and drop down lists are created on a different sheet. 🔴 Related Excel Videos 🔴 Easy Steps to Make Drop Down List ► • How to Make Excel Drop Down Lists - Easy S... Drop Down Shows Blank at End of List ► • Excel Drop Down Selects Blank at End of List 💡 Related Links 💡 Data Validation Drop Down Lists ► https://myctx.link/dvdrop Create Dependent Drop Down Lists ► https://myctx.link/dvdep Data Validation Troubleshooting ► https://myctx.link/dvtips ✅ Excel resources I recommend ► https://myctx.link/xlpick Instructor: Debra Dalgleish, Contextures Inc. More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu... #ContexturesExcelTips '---------------------- Transcript for Excel Drop Downs From List on Different Sheet In this workbook, there's a sheet where people will enter order information. They'll put in a date, and then a product, and the quantity sold. To make it easier for people, in the Product column, instead of them typing a product name, which could result in errors or invalid products, we're going to create a drop-down list so they just have to select a product instead of typing it. On a different worksheet, on the Products sheet here, there's a list of products and we'll use that to create the drop-down list. Because this is on a different worksheet, we're going to have to name this list first before we can use it for the drop downs. I'm going to select all the cells that have product names, and then click in the name box, and I'm going to type a one-word name for this. I'm going to call this ProductList and then I'll press the Enter key to finish naming that range. And you can see the name up here now. If I select a different cell, and select ProductList, it goes to that list right away. So this is a name in the workbook now and I can go back to the Orders sheet and I'll select all the cells where I'd like that drop-down to appear. Then on the Data tab of the ribbon, in the Data Tools section, I'll click, at the top of this Data Validation command, and that opens this window. Under Settings, for Allow, I would like a list. As the Source of this list, I could type an equal sign and the name of the list, but an easier way is on your keyboard, press the F3 key, and that opens up a Paste Name window. I'll click on the list I want to use. Click OK and you can see it now, just as if we had typed it. Click OK and now each of these cells has a drop-down list. The arrow only appears when you click on the cell. You can only have one drop-down visible at any time. You can't make these appear all the time but you can then click that arrow and select one of the products and it'll automatically then appear in the cell.
