View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Rekey data faster

ToolsOptionsEditEnable Autocomplete works if you have contiguous data above
or below the entry point.


Gord Dibben MS Excel MVP

On Wed, 25 Jun 2008 09:14:03 -0700, TQ wrote:

1.How can I make the process of having to rekey the same data faster? (Except
by data validation)

2.How to do the setting of auto fill ?

Thanks