auto suggestion on excel 2007

When I type d  then auto suggestion David etc but auto suggestion is not work well when i have a lot of record may be it diifficult to au to suggest I type the name  surname so i want it auto suggestion the row that near i type can In surname row can i do that on excel 2007
Who is Participating?
zorvek (Kevin Jones)ConsultantCommented:
No, you cannot. Excel either auto suggests or does not (there is an option to turn it on and off) but you can't refine or change how it suggests. It's rather annoying but that's what it is.

Can you explain what it is your are entering? If you are choosing from a specific list of values then you can use a validation drop down list.

A validation list provides the same functionality as a combo box control but is easier to set up, easier to use, and does not introduce the probability of workbook problems and corruption that are possible when using an ActiveX or Forms control. To create a drop-down menu for a cell select the cell and then choose the menu command Data->Validation to open the Data Validation dialog box. Choose List from the Allow drop-down list. Enter the list of possible values in the Source text box:

   Value 1, Value 2, Value 3

Once the validation list is defined for a cell it can be copied to other cells the same way any other cell formatting is copied. To copy, select the source cell and press CTRL+C. Select the destination cells, choose the menu command Edit->Paste Special, select Formatting, and click OK.

Hello Teera :)

I believe English is not your main language and hence I am having a little difficulty in understanding what you want. Could you rephrase your question? If you want to use a sample workbook then even better :)

Try  [Alt] + [Down Arrow] to select Autocomplete drop-down list...
teeraAuthor Commented:
Hi experts
Can I select method that auto suggest fill the text when I type
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

The following is with regards to data entry WITHOUT using data validation or combo boxes:

Excel will use auto-complete when you have entries in a list in the worksheet and start typing in the same column. The auto-complete suggestion will come up as soon as Excel can clearly identify a unique value in the same column. For example, if you have in a column


and you start typing in the next empty cell. As soon as you type a D, auto-complete will show "David", because it only takes one letter to identify this as the value that matches what you have typed so far. However, if the current entries in the list are like

Project one
Project two
Project three

then you will need to type "project o" until you see an auto-complete suggestion for "Project one" and you will need to type "project tw" until you see an auto-complete suggestion for "Project two".

Also, I've found that in very long lists with lots of blank rows, Excel does not ALWAYS recognise and take into consideration ALL the entries and I will often need to type the whole text, even though it already exists in the same column.

Go figure.

cheers, teylyn
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.

All Courses

From novice to tech pro — start learning today.