简短加密_简短或完整的Excel下拉列表

简短加密

You can make data entry easier in Excel, by create a drop down list with data validation. Sometimes those lists are so long, that they become a pain to use. Here's a technique from AlexJ, that lets users switch between a short or full Excel drop down list of customers.

通过创建带有数据验证的下拉列表，可以使在Excel中的数据输入更加容易。 有时，这些列表太长了，以至于难以使用。 这是AlexJ的一项技术，可让用户在简短或完整的Excel下拉客户列表之间切换。

简短或完整的Excel下拉列表 (Short or Full Excel Drop Down List)

With this technique, you can see a full list of customers in a drop down list. Or, switch to a short list, with just your top customers. The technique is driven by a formula -- no macros required!

使用这种技术，您可以在下拉列表中看到完整的客户列表。 或者，仅与您的主要客户一起切换到简短列表。 该技术由公式驱动-不需要宏！

设定清单 (Set Up the Lists)

The first step is to create two named lists -- they will be used as the source for the drop down lists.

第一步是创建两个命名列表-它们将用作下拉列表的源。

1. Type the full list of customers
   输入完整的客户清单

2. Select all the cells in that list, and name the range: FullList

   选择该列表中的所有单元格，然后命名范围 ：FullList

3. In another column, type "Full List" in row 2.
   在另一列中，在第2行中键入“完整列表”。
4. Starting in row 3, type the short list of top customers
   从第3行开始，输入主要客户的简短列表
5. Select all the cells in that list, including the "Full List" cell
   选择该列表中的所有单元格，包括“完整列表”单元格
6. Name that range: ShortList
   命名范围：ShortList

创建下拉列表 (Create the Drop Down List)

Next, you'll create the drop down list, by using data validation with an IF formula:

接下来，您将使用带有IF公式的数据验证来创建下拉列表：

1. Select the cell(s) where you want the drop down list of customers
   选择您要在其中客户下拉列表的单元格
2. On the Ribbon, click the Data tab, then click Data Validation
   在功能区上，单击“数据”选项卡，然后单击“数据验证”
3. In the Data Validation dialog box, under Allow, select List
   在“数据验证”对话框的“允许”下，选择“列表”

4. • =IF($E$3="Full List",FullList,ShortList)

     = IF($ E $ 3 =“ Full List”，FullList，ShortList)

   • OR
     要么

   • =IF(E3="Full List",FullList,ShortList)

     = IF(E3 =“ Full List”，FullList，ShortList)

5. Click OK, to close the dialog box.
   单击确定，关闭对话框。

使用下拉列表 (Use the Drop Down List)

Select the cell with the data validation list, and click the drop down arrow. If the cell does not contain the text "Full List", the drop down will show the short list of top customers.

选择带有数据验证列表的单元格，然后单击下拉箭头。 如果该单元格不包含文本“完整列表”，则下拉列表将显示顶级客户的简短列表。

If you need to see the full list, select "Full List" from the top of the drop down list, and then click the drop down arrow again.

如果需要查看完整列表，请从下拉列表的顶部选择“完整列表”，然后再次单击下拉箭头。

观看视频 (Watch the Video)

To see the steps for creating a variable short or long drop down list, watch this short Excel video tutorial.

要查看创建可变短或长下拉列表的步骤，请观看此简短的Excel视频教程。

演示地址

翻译自: https://contexturesblog.com/archives/2011/02/07/short-or-full-excel-drop-down-list/

简短加密