The validation basic functions
<imagemap>Image:EN_Excel_Menüband_Inhalt_Validierungen.jpg|1200px|center rect 2 85 204 193 The_basic_functions_of_firesys rect 211 82 515 192 The_account_workbook rect 522 82 612 192 The_functions_of_the_master_value_manager rect 614 81 698 191 Synchronise_and_detach rect 884 82 1041 184 The_validation_basic_functions rect 702 114 879 136 Synchronise_and_detach rect 702 140 880 168 Insert_transmitter_values rect 705 81 878 110 Insert_values_in_Excel rect 1046 83 1181 190 An_overview_of_the_rolling_forward_function desc none </imagemap>
| |||||
|
With the help of a single validation you can create a new validation whereby two individual values are related to each other. more
|
With the help of a multiple validation you can create a new validation whereby you can summarise several values in formulas. This enables you to validate related values in one step. more |
With an auto-validation you can search your Excel file for additional occurrences of the selected number. Multiple selection of up to 10 cells is possible. more | |||
|
When you process a validation, you can change the selected validation and also edit the comment or the designation. more
|
You can delete validations that were created. Multiple selection is also possible here. more
|
Use this function to approve non-relevant deviations of validations (e.g. in the area after the decimal point which is not displayed). Approved deviations are no longer listed as errors in the validation sheet nor are they marked as errors in the Word tables. more | |||
See also
Maintain Excel contents
The account workbook
The functions of the master value manager
Insert values in Excel
An overview of the roll forward functions