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
- Aug 14 Mon 2006 20:09
Exel Data Entry
close
全站熱搜
留言列表
發表留言