Chris, I stupidly forgot to do what I always tell others to do; include version numbers etc.
I use Excel 14.2.2 under MacOS 10.6.8 That version of Excel, with the appropriate preference set, happily offers to AutoComplete data I'm entering in a cell as long as there is another cell somewhere in the sheet that has the same starting character sequence. I therefore suggest you update to the current version 14.2.2 and then keep your fingers crossed. On 29/05/2012, at 2:26 PM, Chris Burton wrote: > Hi Ray and Ronni > > Thanks for your suggestions. Ronnie I dont think it is solver but more like > that which Ray has offered. > > However I already to have that box checked in the AutoComplete section. I Ray > reloaded Excel and in the file which I have been using, typing in names for > which I know there are several above in the column: there is no auto complete > happening. > > I remember, it provides a list to choose from. This seems really weird as it > was working perfectly a few weeks ago. > > One thing Im concerned is that it changed when I did the Office 2011 update > about a month ago. > I have just checked again and there is another update to 14.2.2. Not sure if > I should do this one now, but it may address this problem? Anyone know about > it? > > I will also do a search for any discussion about this in Excel > > Many thanks for your help > > Kind regards > > Chris > > > On 29/05/2012, at 1:55 PM, Ray Forma wrote: > >> Chris, >> >> Excel > Preferences…; then AutoComplete and tick Enable AutoComplete for >> cell values. >> >> On 29/05/2012, at 12:11 PM, Chris Burton wrote: >> >>> Hi everyone >>> >>> I have just noticed that while using Excel (2011 V 14.1.4), it no longer >>> pre-empts (not sure what the appropriate word is here) my cell entry with >>> those of previous cells above. The program used to do this all the time >>> which did help with data entry. >>> >>> I have checked through preferences several times thinking it must be in >>> there somewhere, but to no avail! I can see AutoComplete and this box is >>> ticked. AutoCorrect is also present with boxes ticked. >>> Do I need to restart or something? >>> >>> Can someone please let me know how to switch this back on? >>> >>> >>> Many thanks for any help >>> >>> Chris >>> >>> >>> >>> Christopher L.K. Burton >>> Director >>> Western Whale Research >>> PO Box 1076 >>> Dunsborough WA 6281 >>> Mobile: 0419 199 120 >>> Email: c...@it.net.au 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>
