I am using Excel to record various data and some rows have more cells than others. How can I make a list of words for Excel to use to autocomplete when I am entering data manually.
I don't need a drop down
Thanks
4
-
1Welcome to Super User, Jack. This is not a service site, rather a site for specific Q&A when you have attempted something and get stuck. Please expound on what you have tried so far and we will try to help from there. How to Ask may be helpful to improve your question.– CharlieRBCommented Feb 3, 2016 at 16:43
-
Also, is AutoComplete enabled in your options?– CharlieRBCommented Feb 3, 2016 at 16:46
-
1Agree with CharlieRB. As a solution, the only thing I can think of is making a predefined list, f.e. in column A and hide the rows that contain the data. You'll notice that in the cells in that column, you'll have autocomplete. Just make sure you don't have empty cells in between them, that will break autocomplete functionality.– TerryCommented Feb 3, 2016 at 16:48
-
1Watch this Video: Autocomplete Entries With Excel Drop Down List. Is this what you're looking for?– Maher FattouhCommented Feb 3, 2016 at 19:44
Add a comment
|
1 Answer
You need an add-in to complete that. I guess this video is what you exactly need Excel Autocomplete video
The website of the addin is https://www.excelautocomplete.com/. There are demonstrations on the site also.
This is how it works, you create a range which contain the list of items you want to appear in the suggestion list. Then, you select the cells which you want to enable the autocomplete feature and select the range you set up before. After this, all the selected cells now have drop down box appears on focus.
-
Added. However, it is hard to fully describe how the add-in works with just text Commented Nov 14, 2017 at 10:52
-