excel创建下拉列表多选
To make it easier to people to enter data in your Excel workbook, you can create drop down lists in the cells, by using Excel data validation. These lists will also help prevent invalid entries in your worksheets.
为了使人们更轻松地在Excel工作簿中输入数据,可以使用Excel 数据验证在单元格中创建下拉列表。 这些列表还将帮助防止工作表中的无效条目。
A couple of years ago, one of the first videos that I uploaded to YouTube showed how to create data validation drop down lists in Excel 2003.
几年前,我上传到YouTube的第一批视频之一展示了如何在Excel 2003中创建数据验证下拉列表。
I've just finished a new version, for Excel 2007 and Excel 2010, and you can see it at the end of this blog post. The new video includes a couple of shortcuts that will make it even easier to create those drop down lists.
我刚刚为Excel 2007和Excel 2010完成了一个新版本,您可以在此博客文章的末尾看到它。 新视频包含几个快捷方式,这些快捷方式将使创建这些下拉列表更加容易。
命名项目清单 (Name the Item List)
When creating drop down lists, you can use a list of items from a different worksheet, as long as you give a name to that list of items first.
创建下拉列表时,您可以使用其他工作表中的项目列表,只要先为该项目列表指定名称即可。
Here's the quickest way to name the list of items:
- Select the items 选择项目
- Click in the Name Box 在名称框中单击
- Type a one-word name, and press Enter. 输入一个单词的名称,然后按Enter。
创建下拉列表 (Create the Drop Down Lists)
After you've named the source list, you can add the drop down lists, by following these instructions:
在命名源列表之后,可以按照以下说明添加下拉列表:
- Select all the cells where you want the drop downs. 选择要放置下拉列表的所有单元格。
- On the Excel Ribbon, click the Data tab, then click the Data Validation command. 在Excel功能区上,单击“数据”选项卡,然后单击“数据验证”命令。
- In the Data Validation dialog box, under Allow, select List. 在“数据验证”对话框的“允许”下,选择“列表”。
- Then, click in the Source box, and press F3 on your keyboard, to open the Paste Name box. (Quicker than typing the name) 然后,在“源”框中单击,然后在键盘上按F3,以打开“粘贴名称”框。 (比输入名称更快)
- Click on the Name that you want to use in the drop down list, then click OK 在下拉列表中单击要使用的名称,然后单击确定。
- An equal sign and the name will appear in the Source box. 等号和名称将出现在“源”框中。
- Click OK, to create the drop down lists. 单击确定,以创建下拉列表。
观看数据验证视频 (Watch the Data Validation Video)
To see the steps for creating drop down lists with data validation in Excel 2007 and Excel 2010, watch this short video.
若要查看在Excel 2007和Excel 2010中使用数据验证创建下拉列表的步骤,请观看此简短视频。
翻译自: https://contexturesblog.com/archives/2010/10/27/shortcuts-to-create-drop-down-list-in-excel/
excel创建下拉列表多选