Excel remembers! How?

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
 
C

Chip Pearson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
VBA Coding Help for Beginner 0
Conditional Formatting 2
Merging from an Excel file with graphics 1
How to remove external organization from Office. 0
What is this called in Excel or how it works? 0
If, Or, and 5
Calculate the median value before a specified list 0

Top