Getting rid of previously typed data from a cell
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
"Amste" wrote in message
...
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
|