View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Clearing the autocomplete list in a cell

There isn't a list to clear it uses the cells above the one you are typing in
and as soon as there is no ambiguity Excel offers an auto-complete option.
All you can do is trun it off with:-

Tools|Options|Edit

Mike

"Mike K" wrote:

Oh Wise Ones,
I have stumbled upon this before but I cannot
remember how I did it. I would like to clear the list that excel uses to
complete a cell editing when you start typing. If someone could steer me in
the right direction, it would be most appreciated.

Thanks,
Mike