close

When entering data into an excel spreadsheet, it starts to recognise
repetitive words being used which is very handy and time saving, however, one
of the columns has stopped recognising anything. There are no blank spaces
and I can't understand why it has stopped picking up the previous words.

Any suggestions would be much appreciated.

Thanks!If there are many similar entries, Autocomplete may appear to stop
working, because so many letter must be entered before a unique match is
found.

Or if you're far from the previous entry, it may not be detected, as
described in the following MSKB article:

XL2000: AutoComplete Works Differently After 102 Rows Past Last
Occurrence
support.microsoft.com/default.aspx?id=212069Nikki wrote:
gt; When entering data into an excel spreadsheet, it starts to recognise
gt; repetitive words being used which is very handy and time saving, however, one
gt; of the columns has stopped recognising anything. There are no blank spaces
gt; and I can't understand why it has stopped picking up the previous words.
gt;
gt; Any suggestions would be much appreciated.
gt;
gt; Thanks!
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()