Getting rid of previously typed data from a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Perhaps try clicking Tools > AutoCorrect
Look for the line Replace: A, With A/B
and delete it
 
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.
 
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
 
Back
Top