'Auto-fill full name of person according to the existing names in Google Sheets

Example

I want Google Sheet to give me the option to auto-fill from existing people's names in the same google sheet while I start typing the first few letters of person's name. Example picture is above. How can I do this?



Solution 1:[1]

Google Sheets have auto-fill with dropdown lists. It doesn't look like what you want, but it solves your problem.

Create an in-cell dropdown list

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 rollsover