MrExcel Publishing
Your One Stop for Excel Tips & Solutions

When Excel tries to "help"

Posted by Mark on June 23, 2001 4:00 AM

When I enter the first letter in a cell, Excel tries to "help" by continuing with a previous entry. Sometimes this does actually save time but I have one spreadsheet where it is totally annoying. Can I disable that feature? What is it called?

Posted by Ivan F Moala on June 23, 2001 4:41 AM

Tools / Options / Edit
deselect [enable autocomplte for cell values]


Posted by Mark on June 23, 2001 9:12 AM

Thanks Ivan. I appreciate it.... Mark