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: [email protected] 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>
