If I type a word in a cell on the spreadsheet, and further down the column if I type the beginning letter of that word, it will repeat. However, that only works with words. I cannot find a way to get a number to repeat in that same fashing. I have two columns where a certain number is used almost 100% of the time. Is there a way that I can get the number to repeat the same way that words do.