View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Autofile text box

Tools.OptionsEdit. Uncheck "enable autocomplete for cell values"

Thses instructions are for 2003 and earlier.


Gord Dibben MS Excel MVP

On Wed, 24 Sep 2008 12:58:00 -0700, Linda
wrote:

When typing text into a cell, Excel will sometimes autofill in what I have
previously typed into another cell. If I have many cells to type, I do not
want it auto filling. How do I stop Excel from doing this.