Forum Discussion
Formula and Functions
I have a value from a previous Copy and Paste operation that keeps appearing in a cell when trying to enter a new value. I can erase the value from the cell and then reenter the data. But I want to c...
This is probably Autocomplete. Is that value by any chance in any of the cells above the one you are entering data into? To turn off Autocomplete:
1.Click File > Options.
2.Click Advanced, and then under Editing options, select or clear the Enable AutoComplete for cell values check box to turn this option on or off.
1.Click File > Options.
2.Click Advanced, and then under Editing options, select or clear the Enable AutoComplete for cell values check box to turn this option on or off.