Results 1 to 2 of 2
  1. #1
    5 Star Lounger ibe98765's Avatar
    Join Date
    Aug 2001
    Bay Area, California, USA
    Thanked 4 Times in 4 Posts

    Repeating data (Excel 2002)

    Sometimes, when I start typing new data in a cell, if previously inputed data matches, Excel will display the old data in th enew cell and I don't have to retype it (or I can edit it). However, this doesn't work consistently. Sometimes Excel wil display the previously enetered data in the new cell, other times, it just acts dumb and doesn't display anything. Is there some sort of control for this feature?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Repeating data (Excel 2002)

    If "Enable AutoComplete for cell values" has been ticked in the Edit tab of Tools | Options..., Excel will automatically complete an entry if the following conditions are met:

    1) It is a text value - numbers and dates are never autocompleted, even if there is a match.
    2) There is a unique match: if the column already contains litigation and litigious and you start typing l, i, g, ..., AutoComplete won't jump in before you typed either litiga or litigi
    3) There are no empty cells in between. AutoComplete only looks for a match in the current contiguous range.
    4) if the matching value is more than 50 rows away from the active cell, you must enter one more character than you'd expect.

    You can show a dropdown list of entries to choose from by pressing Alt+down arrow.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts