Aug 29, 2019 · In the same or in another spreadsheet, select a cell or several cells in which you want your primary drop-down list to appear. Go to the Data tab, click Data Validation and set up a drop-down list based on a named range in the usual way by selecting List under Allow and entering the range name in the Source box. The exclamation point in Excel formulas separates sheet names from a cell address within that sheet. So you may be typing in ‘Two Tables’! and clicking B2. That’s all I can think of because Excel will still pull in the sheet name if the formula is on a different sheet.

Oct 25, 2018 · Select an item from one of the the data validation drop down lists. Video: Drop Down List from Another Workbook. To see the steps for creating the data validation drop down from a list in another workbook, watch this short Excel video tutorial. If you just want to copy the drop down list, but not the selections already made. 1. Copy the cells 2. Instead of using the default paste option, choose paste special (I like to use CTRL+ALT+V, but you can select the bottom half of the Paste butto...