How do you use a named range in Excel Data Validation?

Use the Name Box This is a quick way to name a range of cells. Click at the top of the heading cell, to select all the cells in the list (the heading will not be selected). Type a one-word name for the selected cell range, e.g. EmpNames, and then press the Enter key, to complete the name.

Table of Contents

How do you name a range in Data Validation?

Select the cell where you want the drop-down list to appear. On the Data tab, click Data Validation. Place the cursor in the Source box or click the Collapse Dialog icon, and select the range of cells to include in your drop-down list. The range may be in the same or in a different worksheet.

How do you use Data Validation in Excel 2007?

Add data validation to a cell or a range

Select one or more cells to validate.
On the Data tab, in the Data Tools group, click Data Validation.
On the Settings tab, in the Allow box, select List.
In the Source box, type your list values, separated by commas.
Make sure that the In-cell dropdown check box is selected.

How do I do a drop down list in Excel 2007?

Click the “Settings” tab and then click “List” from the “Allow” drop-down list box. Click the toggle button at the end of the “Source” box. Select the list of items you want to have in your drop-down box. If you created a range name, in the “Source” box, type an equal sign and then type the name of the range.

How do you add a name to Data Validation in Excel?

Working with your drop-down list

Select the cells that have the drop-down list.
Go to Data > Data Validation.
On the Settings tab, click in the Source box. Then do one of the following: If the Source box contains drop-down entries separated by commas, then type new entries or remove ones you don’t need.

How do I create a dependent drop-down list in Excel 2007?

Creating a Dependent Drop Down List in Excel

Select the cell where you want the first (main) drop down list.
Go to Data –> Data Validation.
In the data validation dialog box, within the settings tab, select List.
In Source field, specify the range that contains the items that are to be shown in the first drop down list.

How do you add names in Excel drop down?

Go to Formulas > Name Manager. In the Name Manager box, click the named range you want to update. Click in the Refers to box, and then on your worksheet select all of the cells that contain the entries for your drop-down list. Click Close, and then click Yes to save your changes.

How do you create a Data Validation list with a defined name?

Select the column in your data entry table that you wish to add data validation to. Go to Data/Data Validation or Alt + D + L to open the Data Validation window. Select “List” from the “Allow” dropdown menu. In the “Source” box, hit the F3 key and select your defined name from the “Paste Name” box.