trouble using autocomplete for text in cells in Excel 2007

%3CLINGO-SUB%20id%3D%22lingo-sub-883147%22%20slang%3D%22en-US%22%3Etrouble%20using%20autocomplete%20for%20text%20in%20cells%20in%20Excel%202007%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-883147%22%20slang%3D%22en-US%22%3E%3CP%3EEven%20though%20I%20have%20enabled%20%22AutoComplete%20for%20cell%20values%22%20using%20Excel%20options%2FAdvanced%2FEditing%20options%2C%20the%20autocomplete%20function%20does%20not%20work%20in%20my%20spreadsheets%3B%20i.e.%2C%20if%20I%20have%20%22walmart%22%20typed%20in%20a%20cell%2C%20when%20I%20type%20%22w%22%20in%20the%20cell%20below%20it%20in%20the%20same%20column%20Excel%20does%20not%20automatically%20enter%20%22walmart%22%20in%20the%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-883147%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886014%22%20slang%3D%22en-US%22%3ERe%3A%20trouble%20using%20autocomplete%20for%20text%20in%20cells%20in%20Excel%202007%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886014%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F417554%22%20target%3D%22_blank%22%3E%40Fibber_Magee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20refer%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fbettersolutions.com%2Fexcel%2Fcells-ranges%2Fentering-auto-complete.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fbettersolutions.com%2Fexcel%2Fcells-ranges%2Fentering-auto-complete.htm%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886593%22%20slang%3D%22en-US%22%3ERe%3A%20trouble%20using%20autocomplete%20for%20text%20in%20cells%20in%20Excel%202007%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886593%22%20slang%3D%22en-US%22%3EThank%20you%20PReagan.%20I%20find%20that%20autocomplete%20works%20only%20in%20the%20cell%20directly%20below%20the%20cell%20that%20is%20filled%20in.%20I%20was%20hoping%20autocomplete%20would%20work%20for%20any%20cell%20below%20the%20cell%20that%20is%20filled%20in%20in%20the%20column%2C%20even%20there%20are%20blank%20cells%20between%20the%20two.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886729%22%20slang%3D%22en-US%22%3ERe%3A%20trouble%20using%20autocomplete%20for%20text%20in%20cells%20in%20Excel%202007%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886729%22%20slang%3D%22en-US%22%3EIf%20the%20first%20few%20characters%20of%20the%20text%20that%20you%20type%20match%20an%20existing%20text%20in%20that%20column%20due%20to%20this%20autocomplete%20may%20not%20work.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Even though I have enabled "AutoComplete for cell values" using Excel options/Advanced/Editing options, the autocomplete function does not work in my spreadsheets; i.e., if I have "walmart" typed in a cell, when I type "w" in the cell below it in the same column Excel does not automatically enter "walmart" in the cell.

3 Replies
Highlighted
Thank you PReagan. I find that autocomplete works only in the cell directly below the cell that is filled in. I was hoping autocomplete would work for any cell below the cell that is filled in in the column, even there are blank cells between the two.
Highlighted
If the first few characters of the text that you type match an existing text in that column due to this autocomplete may not work.