Getting rid of previously typed data from a cell

[Guest]

In the spreadsheet I am working on, there is a heading of A/B; now whenever I
type a capital A in another cell it fills the cell with A/B; how can I get
rid of this so that no previously typed data appears in another cell? I have
tried clearning cells but this does not work.
Thanks

 

[Max]

Perhaps try clicking Tools > AutoCorrect
Look for the line Replace: A, With A/B
and delete it

 

[Arvi Laanemets]

Hi

One possible solution is to add a empty row below headers (and hide it)
Another solution (probably it is the right one, I haven't checked it) is to
turn AutoComplete off (Tools>Options>Edit)
And at last, you always can copy the entry from another cell.

 

[Bernie Deitrick]

Amste,

When you type A and "A/B" appears, press backspace to not accept the autocomplete suggestion (enter
will accept it). That is one drawback of autocomplete, but worth living with.

HTH,
Bernie
MS Excel MVP

 

[Guest]

Thanks so much, I have removed the auto-complete, this seems to have worked
Thanks again.