How to Name a Dropdown List in Excel with a Named Range

To name a dropdown list in Excel, give its source cells a name, then use that name as the list source in Data Validation. For example, name the choices in A2:A5 Choices, select the cells that need a dropdown, and set Data Validation’s Source to =Choices. This makes the source easier to recognize and reuse than a typed cell address.

The name applies to the cells containing the options, not to the dropdown arrow or the cells where people make selections. The steps below are for Excel for Microsoft 365 on Windows. You can use the same named-range approach on Mac; ribbon placement can differ slightly by update. Excel for the web has similar features, but if a command is missing or behaves differently, create and configure the name in the desktop app.

What You’ll Need

An Excel workbook with the dropdown choices entered in a single column or row. For the example, use A2:A5 on a worksheet named Lists.
The cells where you want users to make a selection, either on the same sheet or a different one.
A name for the source range. Use a short, descriptive name such as Choices or DepartmentList. Excel range names cannot contain spaces.

Keep the choices together and avoid blank cells inside the list. A heading above the options is fine, but do not include it in the range you name unless you want it to appear as a selectable choice.

Step-by-Step

Enter and check the dropdown choices. Put one option in each cell, with no empty cells between options. For example, on the Lists sheet, enter North, South, East, and West in A2:A5. Keep the heading, if there is one, in A1. Check spelling and remove accidental spaces before naming the cells, because those details will affect what users see in the dropdown.
Select only the option cells. Select A2:A5, not the whole column and not the heading. You can select the range by dragging over the cells or by clicking the Name Box to the left of the formula bar, typing Lists!A2:A5, and pressing Enter. If the sheet name contains spaces, enclose it in single quotation marks when referring to it, such as 'My Lists'!A2:A5.
Open the name definition controls. With the source cells selected, go to Formulas > Define Name. Excel opens a New Name dialog. You can also use Formulas > Name Manager and choose New if you want to review existing names first. The Name Box can also create a name, but Define Name makes the scope and cell reference easier to inspect.
Enter a clear name. In the New Name dialog, type Choices in the Name field. A name must begin with a letter, an underscore, or a backslash; it cannot include spaces or look like a cell address such as A1. Use an underscore or capitalize words for readability, for example Office_Locations or OfficeLocations. Names are not case-sensitive, so Excel treats Choices and choices as the same name.
Set the scope and confirm the reference. Set Scope to Workbook if you want to use the name from any worksheet. In Refers to, confirm that the selected cells are the source. For this example, the reference should be =Lists!$A$2:$A$5. If it shows a different range, edit the reference or cancel and select the correct cells again. Click OK to save the name.
Select the cells that should have the dropdown. Go to the worksheet where people will make selections and highlight the destination cell or range. For example, select B2:B20 to add the same dropdown to twenty rows. If you select only one cell, only that cell gets the validation rule; selecting a range applies it to each selected cell.
Open Data Validation and choose a list. Go to Data > Data Validation. In the Settings tab of the dialog, set Allow to List. Leave In-cell dropdown checked so the arrow appears when a destination cell is selected. You can also leave Ignore blank checked if users are allowed to leave the cell empty.
Use the name as the list source. With source entries in Lists!A2:A5 and the range named Choices, enter =Choices in the Source box. Include the equals sign. Click OK to apply the rule. The named range is what connects the dropdown to its options; typing only Choices may not be interpreted as the intended named reference.
Test the dropdown and the name. Click a destination cell and open its arrow. Confirm that North, South, East, and West appear, then choose one option. To check the name later, go to Formulas > Name Manager, select Choices, and review the Refers to entry. You can also use the Name Box’s dropdown to jump to the named source range.

If the source and destination are on the same sheet, the process is identical. A named range is especially useful when the list is on another sheet: it lets the validation rule refer to the source by name instead of putting a cross-sheet cell reference directly into the Source box.

Common Mistakes

Leaving off the equals sign. In the Data Validation Source box, enter =Choices. The equals sign tells Excel to use the defined name as a reference.
Naming the wrong cells. If the named range includes a heading, blank cells, or unrelated values, those may show up in the dropdown. Check the Refers to field in Name Manager and make sure it covers only the intended choices.
Using a name with spaces. Excel defined names do not allow spaces. Replace them with underscores or join the words, such as PaymentMethods.
Choosing worksheet scope by accident. If a name has worksheet scope, it is available only on that sheet. For a list intended for use on several sheets, choose Workbook scope. A worksheet-level name can also take precedence over a workbook-level name with the same spelling, which can make a dropdown show an unexpected list.
Expecting a fixed range to grow automatically. A name that refers to A2:A5 will still refer to those four cells if you type a new option in A6. Update the name or use a source designed to expand as the list grows.
Thinking the dropdown cell itself has been named. The name in this procedure labels the source options. It does not rename the destination cell or change the text shown after a user makes a selection.

Tips

Use a name that describes the contents, rather than a generic label, when a workbook has several dropdowns. Names such as Regions, JobTitles, and PriorityLevels are easier to identify in Name Manager than List1 or Data. Keep a brief note in the worksheet near the source list if other people maintain the workbook.

For a dropdown that appears on multiple sheets, use a workbook-scoped name and apply Data Validation to each destination range. You do not need to create a separate source name for every cell. If you need different options in different parts of the workbook, create a distinct name for each source and carefully match each validation rule to the right one.

If options change occasionally, edit the source cells and then inspect the named range. If options are regularly added, consider converting the source list to an Excel Table with Insert > Table. A defined name can refer to the table’s column, so the reference can include new table rows. For example, if the table is named OptionsTable and its column header is Choice, set the name’s Refers to entry to =OptionsTable[Choice], then keep the Data Validation Source as =Choices. Check the result in your workbook after adding a row; table names and column headings must match exactly.

To change the name or its range, open Formulas > Name Manager, select the name, choose Edit, and update the Name or Refers to field. If you change the name, also update any validation rules that still use the old name. The Name Manager is also a useful place to remove obsolete names, but check that no formulas or dropdowns depend on one before deleting it.

Troubleshooting

The dropdown arrow does not appear. Select a cell that should have the rule and open Data > Data Validation. Confirm that Allow is set to List and In-cell dropdown is checked. Also make sure the cell is not part of a merged range, which can complicate validation and selection.
Excel reports that the Source evaluates to an error. Confirm that the name exists, is spelled correctly, and begins with an equals sign in the Source box. Open Name Manager and verify that the name points to a valid range. Look for a deleted sheet or moved source range in the Refers to field.
The dropdown is empty or includes the wrong items. Check the exact source cells in Name Manager. Remove unwanted blanks or headings, and verify that the name is not being overridden by a worksheet-scoped name with the same spelling. Test the rule in a cell on the intended worksheet.
The name works on one sheet but not another. In Name Manager, inspect Scope. A sheet-scoped name is limited to its worksheet; create a workbook-scoped name if the same source should be available throughout the file. If same-named entries exist at both scopes, rename or remove the conflicting one after checking dependencies.
New choices are missing. A fixed reference does not automatically include cells added below it. Edit the name’s Refers to range to include the new cells, or use a table-based source as described above. Then reopen the dropdown to confirm that the added option appears.
You cannot find Define Name or Name Manager. Make sure you are using the desktop Excel app and look on the Formulas tab. On Mac, the command names are similar, though the ribbon layout can vary. In Excel for the web, available name-management features may depend on the current interface; open the workbook in desktop Excel if you cannot create or edit the defined name there.

Frequently Asked Questions

Can I name a dropdown list without naming its source cells?
A list-type validation rule needs a source, such as a cell range or typed values. Naming the source range is the practical way to give that source a reusable label. The dropdown itself is not an independently named Excel object.

Can I use spaces in a dropdown list name?
No. Excel range names cannot contain spaces. Use a name such as Customer_Types or CustomerTypes, then use it with an equals sign in the Source box.

Can I use the same named list for more than one dropdown?
Yes. Apply Data Validation to each destination cell or range and use the same Source entry, =Choices. Changes to the cells covered by the name then affect all dropdowns that use it.

Does the named range update when I add another option?
Not if it refers to a fixed address such as A2:A5. Expand the reference in Name Manager, or use a table column as the named range’s reference so new table rows can be included.

Can I name the cell where someone makes a selection?
Yes, but that is separate from naming the dropdown source. You can select the destination cell and enter a name in the Name Box if you want to refer to that cell in formulas. It does not change the validation list or the displayed selection.

Can I put the list on another worksheet?
Yes. Define a workbook-scoped name for the source range on the other sheet, then enter that name with an equals sign in Data Validation’s Source box. This avoids relying on a direct cross-sheet reference in the validation field.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.