Hi, I'm not real familuar with the Excel program, so I will try to explain
myself as best as I can. How can I program my XL sheet not to duplicate
names when I type them? Such as: Redman, Redmond, Redcast and most comon
Smith. When I type Re, excel adds the extension of "dman", this seems to
slow me down when I add my names to the sheet. I have gone to Format cells,
but not sure if this is the right place. Thanks, Vicky.

toolsoptionserror checking

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Vicky" wrote in message
...
Hi, I'm not real familuar with the Excel program, so I will try to
explain
myself as best as I can. How can I program my XL sheet not to duplicate
names when I type them? Such as: Redman, Redmond, Redcast and most comon
Smith. When I type Re, excel adds the extension of "dman", this seems to
slow me down when I add my names to the sheet. I have gone to Format
cells,
but not sure if this is the right place. Thanks, Vicky.

Click Tools Options Edit tab
Uncheck "Enable AutoComplete for cell values" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Vicky" wrote:
Hi, I'm not real familuar with the Excel program, so I will try to explain
myself as best as I can. How can I program my XL sheet not to duplicate
names when I type them? Such as: Redman, Redmond, Redcast and most comon
Smith. When I type Re, excel adds the extension of "dman", this seems to
slow me down when I add my names to the sheet. I have gone to Format cells,
but not sure if this is the right place. Thanks, Vicky.