Excel Cell Autocomplete

Question

I am using Excel to create a large spreadsheet. I continuously am inputting the same ~50 words into each cell. After working with a specific spreadsheet for a given amount of time the cells begin to autofill the words based on what I've entered. For instance I input the word "Critical" after a while as I type "Cri-" it provides the full "Critical" in a selectable dropdown box below the cell that I can choose "Critical" from without having to type the rest of the word.

Is it possible to set a master list of sorts for a given spreadsheet so that it knows what data will be entered into the cells ahead of time and it can better predict what I'll be typing?

Answer 1

Hi

What I had in mind is using the List feature of Data Validation with the list being in a column somewhere in the workbook (doesn't have to be on the same worksheet). Your list can have up to 32,767 entries.

This feature does not give you the ability to type partial words and show an autocomplete so you could press Tab or Return to complete the typing. For that, you need to do some Visual Basic programming. It does allow you to restrict entries to your list of acceptable entries.

Answer 2

To save you from wasting some time: In the article Jim referred you to you'll have to use the option of storing the list of entries on a worksheet & referring to that range. Typing the list directly into the Data Validation dialog restricts the total number of characters [including separators] to 256... I'm sure your list of 50 possible items well exceeds that limit.

Answer 3

Hi

Please use Data Validation

Here a video that could help you. 

Do let me know if you need more help

https://www.youtube.com/watch?v=FRiFfKb_B_A&t=544s

Answer 4

Yes. Use Data Validation's List feature.

How to Create Drop Down Lists in Excel - Complete Guide ...