Create drop down list in excel 2019 from different sheet materials

I'd like to create a drop-down list of options for the user to choose from. The options would be listed in another worksheet, but in the same workbook. I am running Microsoft Excel 2008 for Mac, version 12.2.8. Thanks for your help, and have a super day!

Jan 16, 2012 · In cell A1 of Worksheet 2, I used the Data Validation tool to create a drop-down list which lists all of those construction items from Worksheet 1. That drop-down list has been copied and pasted into cells A2, A3, A4, etc. so that I can input multiple items on the same bid sheet. Furthermore, each list entry should have a link to the corresponding worksheet so that you can easily click on it and will be taken to this worksheet at once. Basically, there are four methods for creating such table of contents: Do it manually, apply a complex formula, use a VBA macro or an Excel add-in.

Sep 19, 2016 · Creating drop-down lists From the course: ... And set up a data validation rule by way of a Drop Down List. Data Validation. ... We make a choice. Next cell down. Make another choice. And so on ... Jan 20, 2014 · To collapse all the sections, click the #1 button at the top of the worksheet. Figure 8. It is possible to create additional levels of grouping. In Figure 9, rows 13:14 are grouped to create a new sub-level. Note there are now level buttons at the top for 1, 2, and 3. Figure 9. Clicking the #2 level will hide the third level. Figure 10 When someone selects a cell, the drop-down list’s down-arrow appears, and they can click it and make a selection. Create a drop-down list. You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow, and then clicks an entry in the list. Select the cells that you want to contain the lists.

Jun 25, 2018 · Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.