怎么在国内创建谷歌账号_如何在Google表格中创建下拉列表

怎么在国内创建谷歌账号

If you’re working with others on a shared Google Sheets file, sometimes people can enter unexpected data or something that breaks a formula. One way to ensure everyone enters the data you want is to provide it for them in a drop-down validation list.

如果您在共享的Google表格文件中与他人合作，则有时人们可能会输入意外的数据或破坏公式的内容。 确保所有人输入所需数据的一种方法是在下拉验证列表中为他们提供数据。

如何创建一个下拉列表 (How to Create a Drop-Down List)

A drop-down list is a great way to ensure the data people enter into your form, application, or spreadsheet is exactly what you’re expecting. It also provides a much faster way for people to input that data since they’re selecting from a pre-configured list you provide.

下拉列表是确保人们输入到您的表单，应用程序或电子表格中的数据的理想方法。 由于人们正在从您提供的预配置列表中进行选择，因此它还为人们提供了一种更快的输入数据的方法。

The first thing you need to do is open up your Google Sheets file and select the cell(s) for which you want to use a drop-down list.

您需要做的第一件事是打开Google表格文件，然后选择要使用其下拉列表的单元格。

RELATED: 5 Google Sheets Features You Should Know

相关： 您应该知道的5种Google表格功能

Next, open the “Data” menu and select the “Data Validation” command.

接下来，打开“数据”菜单，然后选择“数据验证”命令。

From the Criteria drop-down, choose either “List From a Range” or “List of Items.”

从“条件”下拉列表中，选择“从范围列出”或“项目列表”。

• List From a Range: A list of values that have been selected from other cells in the same or a different sheet. For example, if you want to use the values in cells B1-B9 on sheet 2, you’d type Sheet2!B1:B9 to have the data contained in them appear in the drop-down list, or by selecting any of the cells from your Sheet directly.

  从范围中列出：从相同或不同工作表中其他单元格中选择的值的列表。 例如，如果要使用工作表2上单元格B1-B9中的值，则可以键入Sheet2!B1:B9使其中包含的数据出现在下拉列表中，或者选择任何一个单元格直接从工作表中获取。

• List of Items: A list of predetermined data items. This can be either text or numbers, and you’ll type each value yourself, separating them by commas (and no spaces). This option does not allow you to insert data directly from other cells.

  项目列表：预定数据项目的列表。 可以是文本，也可以是数字，您可以自己键入每个值，并用逗号分隔(不能有空格)。 此选项不允许您直接从其他单元格插入数据。

Here, we’re using the “List of Items” option and providing several numeric choices.

在这里，我们使用“项目列表”选项并提供几个数字选择。

After you’ve entered the data you want to appear in a drop-down list, make sure you have “Show Drop-Down List In Cell” option enabled or else the values won’t appear in the selected cells.

输入数据后，要显示在下拉列表中，请确保已启用“在单元格中显示下拉列表”选项，否则值将不会出现在所选单元格中。

You can also select what happens when someone tries to enter a value that isn’t on the list. The “Show Warning” option lets them enter the invalid data, but marks it in the sheet (we’ll look at how in just a bit). The “Reject Input” option prevents them from entering anything that’s not on your list.

您还可以选择当某人尝试输入不在列表中的值时发生的情况。 “显示警告”选项使他们可以输入无效数据，但会在工作表中对其进行标记(我们将稍后介绍)。 “拒绝输入”选项可防止他们输入不在列表中的任何内容。

And finally, you can enable the “Show validation help text” option to give people some indication about what they can choose in the cells. After selecting the option, type whatever instructions you want.

最后，您可以启用“显示验证帮助文本”选项，以向人们表明他们可以在单元格中选择什么。 选择选项后，键入所需的任何说明。

Go ahead and click “Save” when you’re done.

完成后，单击“保存”。

如何使用新的下拉列表 (How to Use Your New Drop-Down List)

When you’re done, anyone using the sheet can click the drop-down arrow in those cells and choose a value from the list.

完成后，使用该工作表的任何人都可以单击这些单元格中的下拉箭头，然后从列表中选择一个值。

If you selected the “Show validation help text” option, that text pops up whenever anyone selects one of the validated cells.

如果您选择了“显示验证帮助文本”选项，则只要有人选择一个经过验证的单元格，该文本就会弹出。

If someone enters a value that does not match something on the list and you have the “Show Warning” option turned on, the invalid data is marked in the cell.

如果有人输入的值与列表中的内容不匹配，并且您打开了“显示警告”选项，则在单元格中标记了无效数据。

Hovering your mouse over it shows why it’s marked.

将鼠标悬停在上面可以显示标记的原因。

If instead, you have the “Reject Input” option selected, people will get a warning like this one when they try to enter anything that isn’t on your list.

相反，如果您选择了“拒绝输入”选项，当人们尝试输入不在列表中的任何内容时，他们会收到类似这样的警告。

If you need to remove or modify any of the items from your drop-down list head back to Data > Data Validation to edit any items from the lists you’ve created. Removing the list completely is as easy as clicking the “Remove Validation” button located at the bottom.

如果您需要删除或修改下拉列表中的任何项目，请回到“数据”>“数据验证”以编辑您创建的列表中的任何项目。 完全删除列表就像单击底部的“删除验证”按钮一样简单。

翻译自: https://www.howtogeek.com/395616/how-to-create-a-drop-down-list-in-google-sheets/

怎么在国内创建谷歌账号