Forum Discussion
trouble using autocomplete for text in cells in Excel 2007
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 ...
Please refer here:
https://bettersolutions.com/excel/cells-ranges/entering-auto-complete.htm
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.