+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : stop autofill of similar words

  1. #1
    Registered User
    Join Date
    05-03-2011
    Location
    New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    1

    Smile stop autofill of similar words

    I have excel 2007 and am trying to turn off the autofill function.
    I am typing columns of data (language spelling tests) which are often starting with the same letters. Excel is finishing the words for me and I am constantly having to cancel the auto-filled word which slows me down and means I have to watch the screen as I type. How do I turn this off?
    Last edited by caroline123; 05-04-2011 at 11:07 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,487

    Re: stop autofill of similar words

    Click on the Office Button, top left

    Click on Excel Options, at the bottom

    Click on Advanced

    Remove the tick in "Enable AutoComplete for cell values"

    Click OK

    Done


    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1