Excel remembers! How?

  • Thread starter Thread starter ian
  • Start date Start date
I

ian

I type in "FRENCH"(no quatos) in cell A1
The I type in ENGLISH in cell b1
When I get back to cell a2 and type in the letter F the etxt is completed
and it says FRENCH
How does this happen/what is it called/how do you turn it OFF
Thanks for the help
 
Ian,

It is called "AutoCompletion". To turn it off, go to the Tools
menu, choose Options, then the Edit tab. There, uncheck the
"Enable AutoComplete for cell values" options.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top