Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


auto suggestion on excel 2007

Posted on 2011-05-04
Medium Priority
Last Modified: 2012-05-11
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
Question by:teera
LVL 30

Expert Comment

ID: 35695928
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 :)


Expert Comment

ID: 35696056
Try  [Alt] + [Down Arrow] to select Autocomplete drop-down list...

Author Comment

ID: 35696124
Hi experts
Can I select method that auto suggest fill the text when I type
LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 1000 total points
ID: 35699167
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.

LVL 50

Assisted Solution

by:Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 1000 total points
ID: 35701737

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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question