Excel can restrict data entry to certain cells by using data validation , prompt users to enter valid data when a cell is selected, and display an error message when a user enters invalid data.

You can use data validation to restrict the type of data or values that users enter into cells. This is an advanced topic on data validation. For an introduction to data validation, and how to …

You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.

By adding data validation to controls in your form template, you can ensure that the data that you collect is accurate and consistent, and that it conforms to any standards that are already in use …

You can find cells in a workbook that contain data validation by using the Go To Special dialog box. On the Edit menu, point to Find, and then click Go To. Click Special. Select Data …

If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you.

Utilisez les règles de validation des données pour contrôler le type de données ou les valeurs que les utilisateurs entrent dans une cellule. Une liste déroulante (aussi appelée « menu déroulant …

To remove a drop-down list, click the cell with the list, then click Data > Data Validation, and then on the Settings tab, click Clear All, then OK. A drop-down list is also known as a drop-down …

Verwenden Sie Regeln zur Datenüberprüfung, um die Datentypen oder Werte zu steuern, die von Benutzern in eine Zelle eingegeben werden. Ein Beispiel der Datenüberprüfung ist eine …

选择要对其创建规则的单元格。 选择“ 数据 >数据验证 ”。 在 “设置” 选项卡上的“ 允许 ”下，选择一个选项： 整数 - 将单元格限制为仅接受整数。 Decimal - 将单元格限制为仅接受十进制数。 …