![how to make a drop down list in excel from another sheet how to make a drop down list in excel from another sheet](https://2.bp.blogspot.com/-VCj4JJw8Yg4/Wf9iOtTMyZI/AAAAAAAAAiE/B93iBF0L80MxAV4g3WEfQ_a5Gb43NfYWACEwYBhgL/s1600/2.png)
#How to make a drop down list in excel from another sheet how to#
See how to show multiple columns in Excel drop down list we’ll use something different from an ordinary in-cell drop down. In three easy steps, you can create a simple drop-down list. A data validation drop down list in Excel only shows one column of items. Select the List in Allow option in validation criteria. Enter =INDIRECT(B5), click OK, Ignore Error Go to the Data tab and click on Data Validation.
![how to make a drop down list in excel from another sheet how to make a drop down list in excel from another sheet](https://www.jquery-az.com/wp-content/uploads/2019/08/58-excel-create-dropdown-list.gif)
Select Data>Data Validation>Settings>Source (Shortcut: Alt+DL).Select a cell C5 to create a Drop-Down list.Go to worksheet ‘ Dependent’ of Excel working file (Image instructions below).Click in the Source box, and on the keyboard, press F3, to open the Paste Name window. On the Settings tab, from the Allow drop down, choose List. Click the top of the Data Validation command. Select cell A1, and on the Excel Ribbon, click the Data tab. This is very helpful when auditing Excel files. In this example, the drop down list will go in cell A1. The second drop-down list is dependent upon the choice of the First drop-down list, the following are key steps to follow: Data validation is a handy tool in Excel that allows you to control what can be entered in your worksheet. This would essentially work as a lookup to keep the values in the contacts sheet limited to the known companies in sheet 1. 2nd Drop-down list is contnigent upon the choice of 1st drop-down list. I am trying to create a dropdown column listing the companies from Sheet1 to populate the drop down for a column in Sheet2. If you change the contents of the range you've selected, the changes will be made in the list automatically.So, If the user selects a product name from parent drop-down list simultaneously the brand names of the subordinate drop-down list must also change. To delete a list, click Remove validation.To change the options listed, edit the items next to "Criteria.".Select the cell or cells you’d like to change.To change the color of a cell based on the option selected, use conditional formatting. If you want people to only enter items from the list, choose "Reject input" next to "On invalid data." If you enter data in a cell that doesn’t match an item on the list, you’ll see a warning.
![how to make a drop down list in excel from another sheet how to make a drop down list in excel from another sheet](https://support.content.office.net/en-us/media/49b9b06f-1318-4b0c-b2fd-a156f6a97d2f.png)
To remove the arrow, uncheck "Show dropdown list in cell." List of items: Enter items, separated by commas and no spaces.You can solve the problem with the help of the INDIRECT() function: it will form the correct link to an external source of information. List from a range: Choose the cells that will be included in the list. Excel drop-down list with data from another sheet / file When the values for the drop-down list are located on another sheet or in another workbook, the standard method does not work.Select the cell or cells where you want to create a drop-down list.Create drop-down lists in a cell with Google Sheets.