When I create a new spreadsheet by cutting and pasting rows from other spreadsheets, frequently (usually? always?) the auto-complete function doesn't seem to work. I'm talking about when I start to type data into a cell and if as I type it matches a previous cell earlier in the same column it will auto-complete the rest of the cell.

The auto-complete ignores the cells that were filled by cut and paste, but does fill from cells that I have typed. In other words, if "King, Stephen" is pasted from another spreadsheet, the next time I type "Kin..." I get no auto-complete but have to type the whole thing. However, if I subsequently have yet another "King, Stephen" to enter in that column, it will auto-complete using the one I typed as a source.

What are the rules on how the auto-complete is supposed to work? And, yes, the "Enable AutoComplete" box is checked in Tools-->Options-->Edit.

tanstaafl.