These may be appropriate:

To turn on autofill: Tools | Options | Edit | Allow cell drag and drop

To add to a list used by autofill: Tools | Options | Custom Lists | Add

To turn on autocorrect: Tools | AutoCorrect | Replace text as you type

To add entries to autocorrect: Tools | AutoCorrect | Replace ... With ...

- Mike

"Spudd" wrote in message
...
I manually create spreadsheets with very different information. What I am
looking for is how to turn on the autofill feature so that i dont have to
retype duplicate entries over and over and without using copy/paste.

Thanks