• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

drop down box

I have alot of cells on some of my sheets that I would like the user to be able to type common things in easily and to type new thing in as well. But rather than chosing the words can it be like predictive text. eg I would have a list of the most common works and if they type say S then the work Sick would come up. Common words are:


Or do you have any other suggestions? this has to happen about 10 - 20 times on a single sheet.

  • 2
1 Solution
If the common words are going to be in the same column, you can pre-fill several rows above the input range and hide these rows.  Excel has a built in predictive text option when you begin typing in a cell.

So, as an example you can enter the pre-filled list (SICK,RDO,OFF,HOLIDAY) starting in A1.  Do this for each column you'd like to pre-fill.  Hide these rows from the user.

Now when the user types the letter "S", all they have to do is press ENTER.

They will have to enter more than one letter if there are words that begin the same letter(s).  For example, you would have to enter "SIC" if you had SICK and SINGLE in your pre-filled list.

Also, as the user enters other unique values in the column, these will also become available in the predictive text.
RobJanineAuthor Commented:
Ok, only thing is I dont have any free cells above, can it be linked to a single cell for predictive text?
No, each item has to be in it's own cell.

If you cannot insert rows above your input range, the only other way is to write a class that would watch inside of your input range and search the current column based on each keystroke and present a word or list of words.  Unfortunately, I'm not even really sure if this can be done.
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now