Chris, I have just tested my Excel 14.2.2 under MacOS 10.6.8, with AutoComplete ticked.
Excel offers to AutoComplete only if one of the cells directly above has the same starting sequence. Note that a blank cell breaks the sequence. Try entry in any other cell and there is no offer to AutoComplete. I have plagiarised the following from elsewhere: Excel only tries to match your new entry with immediately adjacent cells above the one in which you are entering the information. It stops trying to match entries when a blank cell is reached. For instance, suppose you have information in cells A1 through A14 and A16 through A23. When you start typing an entry in cell A24, Excel only tries to match it with values in A16 through A23; the blank cell at A15 halts the comparisons. In addition, Excel does not try to match with cells that contain only numbers, dates, or times. The cells must contain either text or a combination of text and numbers. On 29/05/2012, at 5:12 PM, Chris Burton wrote: > Hi Ray > > Thanks so much for your persistence on this. I just updated to 14.2.2 and I > am on a Mac Book Pro with 10.6.8. I then restarted the machine and repaired > permissions. > > Still No luck. I also typed in known names that were just above the cell and > it didnt recognise the letters. > > I did some searching and it seems that others have had similar problems for > quite a while with no solution I could find. > > Not sure what to do now Ray > > Many thanks > > Chris Regards, Ray Forma Mob +61 (0) 428 596938 -- The WA Macintosh User Group Mailing List -- Archives - <http://www.wamug.org.au/mailinglist/archives.shtml> Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml> Settings & Unsubscribe - <http://lists.wamug.org.au/listinfo/wamug.org.au-wamug>
