Excel Cell Autocomplete

S

smd111

Is there any function, so we can use auto complete while entering
similar entry in to cell, which saves lot's time when entering similar
data.

DEFAULT AUTO COMPLETE WORKS VERY LIMITED, WILL NOT WORK IF SEQUENCE
WILL BREAK, ALSO FOR NUMBERS (A/C) IS NOT WORKING.

I have tried with alt+down arrow, but it's giving entry which below of
that cell...better if we have some thing to lookup which can shows us
all entry in to that column( up & below).
 
Top