excel表格选择下拉多选_Excel下拉多个选择或删除

excel表格选择下拉多选

There's a popular sample file on my website, that lets you select multiple items from a data validation drop down list. Since the original article, I've posted updates:

我的网站上有一个受欢迎的示例文件，可让您从数据验证下拉列表中选择多个项目 。 自从原始文章以来，我已经发布了更新：

• how to set up multiple selection

  如何设置多项选择

• edit multiple selection cells

  编辑多个选择单元格

• prevent duplicates in multiple selection column

  防止在多个选择列中重复

And here is the latest update.

这是最新的更新。

从单元格中删除先前的选择 (Remove Previous Selections From Cell)

In the comments on the original post, Dan asked for a way to remove items if they been previously selected. For example, the cell contains four items -- "One, Two, Three, Four".

在原始帖子的评论中，Dan要求删除以前选定的项目。 例如，该单元格包含四个项目-“一个，两个，三个，四个”。

When you select Three again, that number is removed from the cell, instead of being added at the end of the cell.

当您再次选择“三”时，该数字将从单元格中删除，而不是添加到单元格的末尾。

下载样本文件 (Download the Sample File)

To experiment with this technique, you can download the sample file from the Contextures website, on the Excel Data Validation - Select Multiple Items page. The file is in Excel 2003 format and zipped. There are macros in the file so enable them to test the features.

若要试验此技术，可以从Contextures网站的“ Excel数据验证-选择多个项目”页上下载示例文件。 该文件为Excel 2003格式并已压缩。 文件中包含宏，因此可以使它们测试功能。

The new sample is on the SameCellAddRemove worksheet.

新示例在SameCellAddRemove工作表上。

Please let me know in the comments if there are other features you'd like to see in this workbook. Thanks!

如果您想在此工作簿中看到其他功能，请在评论中让我知道。 谢谢！

购买高级版 (Buy the Premium Version)

There is a premium version of this technique, and you can see the details here: Data Validation Multi Select Premium. Instead of selecting from the drop down, a list box appears when you click the cell.

该技术有一个高级版本，您可以在此处查看详细信息： 数据验证多选高级 。 单击该单元格时，会出现一个列表框，而不是从下拉列表中进行选择。

It automatically selects any items that are already in the cell. It also has buttons to Clear all the selections, and select all the items.

它会自动选择单元格中已经存在的所有项目。 它还具有清除所有选择并选择所有项目的按钮。

The premium version works with dependent lists too, and runs on a protected worksheet. There is also an option of showing a multi-select listbox, or a single-select version (this is helpful when working with dependent lists -- you don't want multiple items selected in the main columns).

高级版本也可用于从属列表，并在受保护的工作表上运行。 还有一个显示多选列表框或单选版本的选项(这在处理从属列表时很有用-您不希望在主列中选择多个项目)。

The kit has 3 sample files, and a user guide, with details and screen shots, on how to add this technique to your own workbooks. Click here for details: Data Validation Multi Select Premium.

该工具包包含3个示例文件和一个用户指南，其中包含有关如何将此技术添加到您自己的工作簿中的详细信息和屏幕截图。 单击此处了解详细信息： 数据验证多选Premium 。

观看Excel教程视频 (Watch the Excel Tutorial Video)

This video shows how the multiple select and remove features work. You can also see the Excel VBA code, and the steps that it goes through, when you make a selection in the drop down list.

该视频显示了多个选择和删除功能的工作方式。 在下拉列表中进行选择时，您还可以查看Excel VBA代码及其通过的步骤。

演示地址

翻译自: https://contexturesblog.com/archives/2011/09/09/excel-drop-down-multiple-select-or-remove/

excel表格选择下拉多选