Home

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
Fibber_Magee
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
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.
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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies