Excel: Overtime Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
 

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.