Click Data Validation, select List, click in Source, press F3, select the name, click OK, and click OK again. Select the cell where you want a drop-down list. Now, you are ready to create a drop-down list that uses the named range. When you select the cells of a named range, you'll see the name in the name box. The rest of the name can be letters, numbers, periods, and underscores.Īnd you can't use predefined statements, such as true or false, or cell references, such as A1. The first character of a name must be a letter or an underscore. In the name box, type the name you want for the range. To use a named range for the options in your drop-down list, you start by creating one. Then select the destination cells and press Ctrl+V to paste it.Ī named range, such as Fruits, is easier to remember than a cell range, such as A2:A37. You can use the keyboard shortcut Ctrl+C to copy the cell.
This way, text and numbers won't appear in the destination cells, so it doesn't seem like an entry was already selected. If it shows a text or number entry, press Delete to clear it.
To use this drop-down list in other locations, copy it to other cells. Verify the cell contains a drop-down list with the options provided by the cell range. The range must be a single row or column, and click OK. It can be on a different worksheet, as in this example, giving you greater flexibility in configuring and protecting the worksheets. To provide the options in your drop-down list, click in Source and select the cell range that contains the options. Leave Ignore blank selected we'll cover this in the next video. Leave In-cell drop-down selected this enables a drop-down list in the cell. On the data sheet I have a list of shapes in column A, this wor. On the KSS Prep sheet I have shape and description. In the Data Validation dialog, set Allow to List this enables a list in the cell. Hello I am trying to create a formula to insert into a cell that will choose a dropdown list dependent on the value entered in a different cell. Select a cell where you want a drop-down list.Ĭlick the DATA tab, and click Data Validation. To avoid the problem, let's use a cell range for the entries in the drop-down list. This can be a problem when someone types an entry instead of picking it from the list.įor example, typing YES in all capital letters returns an error, if error messages are enabled, which is the default. We'll cover managing drop-down lists in video 4.Ī comma-delimited list is also case sensitive. If you need to change the list entries, such as adding and deleting entries, this type of drop-down list is more time consuming to manage. You might use such a list if there are just a few values, and they are unlikely to change. We used a comma-delimited list in the previous video. You can use a comma-delimited list, a cell range, or a named range to define the options in a drop-down list.
0 kommentar(er)
