auto suggestion on excel 2007

Posted on 2011-05-04
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

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

    LVL 8

    Expert Comment

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

    Author Comment

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

    Accepted Solution

    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


    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

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now