Autocomplete for nonadjacent cells...is this possible?

[Viva_Excel]

Using Autocomplete: I have a lot of cells in one column that I need to input using Autocomplete. However, whenever there is a blank adjacent cell, the autocomplete is disabled. Does anyone know how to “enable” autocomplete even when there is a blank cell adjacent to the cell.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[Jerry Sullivan]

Hi, My understanding is that autocomplete will not work if there are any blank cells between the active cell and the cell in the same column that has the text you want to repeat.

Is that what you mean by "blank adjacent cell" or are you referring to adjacent cells in the adjacent column to the right or left? Adjacent columns shouldn't affect AutoComplete.

This might help with a few workarounds....not ideal but something to try.

http://excel.tips.net/T001986_Making_AutoComplete_Work_for_an_Entire_Column.html