Hi Ray This is really becoming perplexing now as I have loaded many other spreadsheets, both with numbers, and text and tried without any success to get the autocomplete to work. It just doesnt work any more in any sheets!!??
So I thought I would load up my previous version of Excel (Excel: Mac X) and AutoComplete works perfectly, in the same spreadsheets as I had just tried. In addition it works when there are more than one blank cell between other cells with entries (only talking about columns here). Im really stumped now Ray. Must be something wrong with my version of excel, or perhaps some other setting is interferring with the autocomplete!? Many thanks Chris On 29/05/2012, at 5:32 PM, Ray Forma wrote: > 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> -- 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>
