Submitted by Celine Chen on May 28, 2009 12:17:59 AM

Spreadsheet tip

To specify data validation options from another sheet, define a name for the range, then go to Manipulate > Validity to specify the criteria