True False True True 6 6 12 True False _Allow: True allow 0 0 0 False True _Data: True data 0 0 4 True False All values Whole Numbers Decimal Date Time Cell range List Text length Custom Click a validation option for the selected cell(s). 1 0 False True equal less than greater than less than or equal greater than or equal to not equal valid range invalid range Select the comparative operator that you want to use. 1 4 True False _Minimum: True mingrid 0 0 5 True False True True False True 12 True True True True True Enter the minimum value for the data validation option that you selected in the Allow box. 0 0 True True True center center 1 0 0 0 True True True True in True True True True Enter the entries that will be valid values or text strings. 0 1 1 5 False True Ma_ximum: True max 0 0 7 Allow _empty cells True True False True True In conjunction with Tools - Detective - Mark invalid Data, this defines that blank cells are shown as invalid data (disabled) or not (enabled). 1 1 Show selection _list True True False True True Shows a list of all valid strings or values to select from. The list can also be opened by selecting the cell and pressing Ctrl+D. 1 2 Sor_t entries ascending True True False 12 True True True Sorts the selection list in ascending order and filters duplicates from the list. If not checked, the order from the data source is taken. 1 3 False True A valid source can only consist of a contiguous selection of rows and columns, or a formula that results in an area or array. True 50 0 0 1 6 True True True True True Enter the maximum value for the data validation option that you selected in the Allow box. 1 7 Specify the validation rules for the selected cell(s).