ahhhh autocomplete..... wasnt sure what the feature was called. This is
exactly what i needed thanks.

"Earl Kiosterud" wrote:

Spudd,

That post got away before I was done. Also, if you mean Autocomplete, look
at Tools - Options - Edit tab, Enable autocomplete for cell values.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Earl Kiosterud" wrote in message
...
Spudd,

Michael's answer enables copying an entry down with the Fill Handle.
Perhaps that's what you meant by autofill. Also, you can use Ctrl - '
(Ctrl plus apostrophe) to repeat the cell above.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"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