excel输入显示日期_在Excel中显示输入和错误消息

excel输入显示日期

With data validation, you can control what is entered in a cell, and prevent invalid data. I usually use drop downs, to create a list of options for people to choose from.

使用数据验证，您可以控制在单元格中输入的内容，并防止无效数据。 我通常使用下拉菜单创建供人们选择的选项列表。

Here is a typical drop down list in Excel, showing a list of month names.

这是Excel中的典型下拉列表，显示了月份名称列表。

Sometimes a list isn’t the best option, and I have to use one of the other data validation settings.

有时列表不是最佳选择，我必须使用其他数据验证设置之一。

输入一个数字 (Enter a Number)

There are several other things that you can allow in a cell, instead of a list, such as whole numbers or dates. In this example, the cell will only allow whole numbers.

您可以在单元格中允许其他一些事情，而不是列表，例如整数或日期。 在此的示例该单元格将只允许整数。

After you select from the Allow drop down, one or more boxes will appear. For most of the data types, you’ll have to choose an operator, such as greater than, less than or equal to, or between.

从“允许”下拉列表中选择后，将出现一个或多个框。 对于大多数数据类型，您必须选择一个运算符，例如大于，小于或等于或介于两者之间。

This cell should only allow numbers between 1 and 10, so the Between operator is selected, then 1 is entered as the minimum number, and 10 as the maximum number.

该单元格只能允许1到10之间的数字，因此选择了Between运算符，然后输入1作为最小数字，并输入10作为最大数字。

测试验证 (Test the Validation)

After you set up the data validation rule, you can test it, by typing an invalid entry. When I type 11 in the cell, an error message appears. It’s not too helpful – it tells me that the entry is not valid, but doesn’t explain why.

设置数据验证规则后，您可以通过键入无效条目来对其进行测试。 当我在单元格中键入11时，会出现一条错误消息。 它不是太有用-它告诉我该条目无效，但没有解释原因。

添加更多信息 (Add More Information)

There are a couple of things that you can do, to help people put valid data into the cell:

您可以执行以下几项操作来帮助人们将有效数据放入单元格中：

• show an input message when the cell is selected. Give a brief description of what can be entered in the cell.
  选择单元格时显示输入消息。 简要说明可以在单元格中输入的内容。
• create an error message, which appears if invalid data is entered. The error message can stop invalid data, or show a warning but allow the invalid data.
  创建一条错误消息，如果输入了无效数据，则会显示该消息。 该错误消息可以停止无效数据，或显示警告，但允许无效数据。

You can read detailed instructions on my Contextures website, for setting up these messages. Or watch the video below, to see the steps.

您可以在我的Contextures网站上阅读有关设置这些消息的详细说明 。 或观看下面的视频，查看步骤。

演示地址

翻译自: https://contexturesblog.com/archives/2013/12/05/show-input-and-error-messages-in-excel/

excel输入显示日期