Leading the way in Microsoft Office Development

Controlling the height of the Drop-Down list

You can only have a source reference to cells on the active sheet, although if you want to refer to a range on a different worksheet then you can use a named range.

You can just type the entries directly into the source box as a comma separated list or use a named range.

To view cells that contain validation rules select (Edit > GoTo), click the special button and select the Data Validation button. Any cells with rules will appear as a non contiguous selection. Use the Tab key to cycle through all cells.

Does not allow references to other worksheets or workbooks

You can use this to set up cells and references that only accept entries of a certain type or within a certain value range. There is an option on the paste special to paste Validation Rules.

You can restrict cell entries to a predefined list. (Data > Validation). In the allow box, select list. Make sure the “in cell” drop-down is selected.

There are three levels of data validation Information, Warning and Stop. The default is Stop which means that data or numbers cannot be entered outside the validation rules. If you use the Warning or Information levels then the last two buttons on the auditing toolbar will add and clear circles around any invalid entries