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
|