This video focuses on how to use a cell range and named range.

How to create drop down list in microsoft excel 365. Web in the ribbon, click data > sort. Change to the workbook that is to contain the dropdown and select the new worksheet (list) select the. If you don't want users to.

Select one or more cells where you want the picklist to appear. Web with the cells selected, go up to the name box on the left side of the formula bar and enter a name for the cell group. Web on the data tab, in the sort & filter group, click advanced.

Enter a name, for example choices, and press enter. When the name manager opens, select the named range and. Go to the data tab and.

Web simply click the arrow and select an option. Web on the ribbon, click data > data validation. Web select this range, then click in the name box on the left hand side of the formula bar.

Let's say that the cell. Select the range of cells, click copy to another location,. In the dialog, set allow to list.

The list is hidden until the user clicks the. This will open the code window for that. Web select and copy the source list range in the source workbook.