I know it's possible for cells to automatically fill in typing that is
identical to cells in the same column, but I can't seem to get it to work.
I've tried the following: Tools...Options...Edit...Enable Auto Complete...OK.
This doesn't work. Any other ideas?