Name the Data Source
The Drop Down List will use our Accounts spreadsheet as
the data source. Here are the steps to prepare for the Data Validation.
1. Go to the Accounts spreadsheet and select cells A1
through A8.
2. Name that Range: Clients
The Name Box is located right above cell A1. Click
in the Name box, type, then click Enter on your keyboard to save your
settings.