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 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
- 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.
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.
