I use excel to create a daily document that I enter people's names into.
The names are not always in the same cell.
How can I create an Auto Text from a list of hundreds of people names.
I would type in any cell or cells I have determined and if I type "a" then a list of all the people that start with "a" would show and I would click on the correct name?
All the list solutions I have found only work for a preset cell and the auto fill doesn't work if there are empty cells below the list.
Thank you.
Using Mac Excel 2011
The names are not always in the same cell.
How can I create an Auto Text from a list of hundreds of people names.
I would type in any cell or cells I have determined and if I type "a" then a list of all the people that start with "a" would show and I would click on the correct name?
All the list solutions I have found only work for a preset cell and the auto fill doesn't work if there are empty cells below the list.
Thank you.
Using Mac Excel 2011