The validation basic functions

<imagemap>Datei:EN-Excel-Validierung-Menüband-Grundfunktionen.jpg|center|1200px rect 2 78 215 197 The_basic_functions_of_firesys rect 328 84 785 202 Validations_in_Excel rect 224 83 325 200 The_account_workbook rect 791 86 1063 199 The_validation_worksheet rect 1069 88 1387 200 The_functions_of_the_master_value_manager

rect 215 81 317 194 Edit_validations rect 323 80 403 195 Create_validations rect 409 80 484 192 Edit_validations rect 488 82 565 190 Delete_validations rect 574 81 757 110 Approve_deviation rect 580 116 755 144 Approve_deviation desc none

</imagemap>

The validation basic functions You can (automatically) compare two or more numbers from one Excel document. You can allocate these to a group and display them in the comparison sheet in a clear overview.
Create validations With the help of a single validation you can create a new validation whereby two individual values are related to each other. more	Create multiple validations 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	Auto-validations 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
Edit and update validations When you process a validation, you can change the selected validation and also edit the comment or the designation. more	Delete validations You can delete validations that were created. Multiple selection is also possible here. more	Approve deviations 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

Further contents

→ firesys website
→ Customer area
→ YouTube