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. In the Data Validation dialog, set Allow to List this enables a list in the 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)
