Create a list of names on the worksheet as shown
Select the list
Now click on 'Insert' in the menu bar
Select Name
Select 'Define Name..'
In the 'Define Name' dialogue box under 'Names in workbook' define a name like 'name' for the list
Then click on 'Data' in the menu bar
Select 'Validation...'
In the 'Data Validation' Window under 'Validation criteria' and under 'allow' click on the drop-down arrow and select 'list'.
Under the source field write '=name'. This is the name you defined earlier for the range of selected cells starting with 'Tom'.
Finish by clicking 'OK'
A drop-down arrow appears on the selected cells under the column heading 'Name'
Clicking on this arrow shows a list of names from which you can select
This name then fills the cell
|