excel下拉隐藏
You can add a drop down list in a cell, to make it easy for people to enter data. It's really easy to make a simple drop down. Then, after you've made a basic list, experiment with fancier features, like hiding items that have been previously selected.
您可以在单元格中添加一个下拉列表,以方便人们输入数据。 简单地下拉菜单确实很容易。 然后,在创建基本列表之后,尝试使用更高级的功能,例如隐藏先前选择的项目。
制作基本的下拉列表 (Make a Basic Drop Down List)
It's easy to make a drop down list with Data Validation. In this example, people will pick the name of the printers that they use in the office.
使用Data Validation轻松创建一个下拉列表 。 在此示例中,人们将选择他们在办公室中使用的打印机的名称。
列出项目 (List the Items)
First, create a list of printers for the drop down
首先,为下拉列表创建打印机列表
- List the printers on a different sheet, in a single column 在不同的工作表中单列列出打印机
- Then, to name the list, select all the cells, click in the Name Box, type a one-word name "PrimaryList", and press Enter 然后,要命名列表,请选择所有单元格,在“名称”框中单击,键入一个单词名称“ PrimaryList”,然后按Enter
Here is the name, "PrimaryList", being typed in the Name Box.
这是在名称框中键入的名称“ PrimaryList ”。
创建下拉列表 (Create the Drop Down List)
Next, sel