XLSX download.microsoft.com

Excel Data Validation ExamplesThe following worksheets have various completed Data Validation examples as mentioned in the following Support. article: See more online: Apply Data Validation to cellsEach worksheet is listed below, along with what kind of Data Validation you'll findWorksheetData Validation Type• Data Validation is limited to the following options:Whole numberLimit entries to whole numbersDecimalLimit entries to decimal (percentage) valuesDepartmentsLimit selections to list choicesCost centers tableTable for Cost center list sourceCost center budgetLimit selections to Cost center list choicesDateLimit entries to dates within a rangeTimeLimit entries between a time frameText lengthLimit entries to a certain number of charactersHR BudgetLimit entries to a certain maximum amountProductsRequire entries to meet certain text guidelinesAge verificationLimit entries below a certain ageCustom valuesLimit entries to unique values only (no repeated entries)E-MailRequire entries to contain the @ symbol• Cells highlighted like this are for input:Input here ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download